Windsor brings all your LinkedIn Business Manager data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

LinkedIn Business Manager Field Reference

Sample

The LinkedIn Business Manager connector helps you to stream LinkedIn Revenue Attribution Report data.

https://connectors.windsor.ai/linkedin_business_manage?api_key=[your API key]&date_preset=last_7d&fields=all_click_ad_spend_amount,all_click_ad_spend_currency_code,all_click_average_days_to_close,all_click_average_deal_size_amount,all_click_average_deal_size_currency_code,all_click_closed_won_opportunities,all_click_lead_conversion_rate,all_click_leads,all_click_open_opportunities,all_click_opportunity_amount_amount,all_click_opportunity_amount_currency_code,all_click_opportunity_win_rate,all_click_return_on_ad_spend,all_click_revenue_won_amount,all_click_revenue_won_currency_code

`All Impression Metrics` and `Daily Impression Metrics` report metrics are both click and impression based.

 


Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDBusiness Manager Account IDDimensions
account_nameTEXTAccount nameBusiness Manager Account NameDimensions
all_click_ad_spend_amountNUMERICAll click ad spend amountAmount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcAll Click Metrics
all_click_ad_spend_currency_codeTEXTAll click ad spend currency codeCurrency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcAll Click Metrics
all_click_average_days_to_closeNUMERICAll click average days to closeThe average number of days to close a won deal attributed to LinkedIn marketing (Opportunity length/Number of closed wonopportunities)All Click Metrics
all_click_average_deal_size_amountNUMERICAll click average deal size amountAmount of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)All Click Metrics
all_click_average_deal_size_currency_codeTEXTAll click average deal size currency codeCurrency code of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)All Click Metrics
all_click_closed_won_opportunitiesNUMERICAll click closed won opportunitiesNumber of closed-won opportunities attributed to LinkedIn marketingAll Click Metrics
all_click_lead_conversion_rateNUMERICAll click lead conversion rateRate of total number of leads which are converted to contacts out of all the leads in CRM (Number of converted leads / Total number of leads)All Click Metrics
all_click_leadsNUMERICAll click leadsNumber of active leads in the pipeline attributed to LinkedIn marketingAll Click Metrics
all_click_open_opportunitiesNUMERICAll click open opportunitiesNumber of active opportunities in the pipeline attributed to LinkedIn marketing.All Click Metrics
all_click_opportunity_amount_amountNUMERICAll click opportunity amount amountAmount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingAll Click Metrics
all_click_opportunity_amount_currency_codeTEXTAll click opportunity amount currency codeCurrency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingAll Click Metrics
all_click_opportunity_win_rateNUMERICAll click opportunity win rateRate at which the opportunities are won out of all the closed opportunities (Number of closed won opportunities / Number of closed opportunities)All Click Metrics
all_click_return_on_ad_spendNUMERICAll click return on Ad spendRatio of total revenue won attributed to LinkedIn marketing divided by LinkedIn ad spend (Revenue Won / Total Ad Spend)All Click Metrics
all_click_revenue_won_amountNUMERICAll click revenue won amountAmount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsAll Click Metrics
all_click_revenue_won_currency_codeTEXTAll click revenue won currency codeCurrency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsAll Click Metrics
all_impression_ad_spend_amountNUMERICAll impression ad spend amountAmount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcAll Impression Metrics
all_impression_ad_spend_currency_codeTEXTAll impression ad spend currency codeCurrency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcAll Impression Metrics
all_impression_average_days_to_closeNUMERICAll impression average days to closeThe average number of days to close a won deal attributed to LinkedIn marketing (Opportunity length/Number of closed wonopportunities)All Impression Metrics
all_impression_average_deal_size_amountNUMERICAll impression average deal size amountAmount of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)All Impression Metrics
all_impression_average_deal_size_currency_codeTEXTAll impression average deal size currency codeCurrency code of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)All Impression Metrics
all_impression_closed_won_opportunitiesNUMERICAll impression closed won opportunitiesNumber of closed-won opportunities attributed to LinkedIn marketingAll Impression Metrics
all_impression_lead_conversion_rateNUMERICAll impression lead conversion rateRate of total number of leads which are converted to contacts out of all the leads in CRM (Number of converted leads / Total number of leads)All Impression Metrics
all_impression_leadsNUMERICAll impression leadsNumber of active leads in the pipeline attributed to LinkedIn marketingAll Impression Metrics
all_impression_open_opportunitiesNUMERICAll impression open opportunitiesNumber of active opportunities in the pipeline attributed to LinkedIn marketing.All Impression Metrics
all_impression_opportunity_amount_amountNUMERICAll impression opportunity amount amountAmount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingAll Impression Metrics
all_impression_opportunity_amount_currency_codeTEXTAll impression opportunity amount currency codeCurrency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingAll Impression Metrics
all_impression_opportunity_win_rateNUMERICAll impression opportunity win rateRate at which the opportunities are won out of all the closed opportunities (Number of closed won opportunities / Number of closed opportunities)All Impression Metrics
all_impression_return_on_ad_spendNUMERICAll impression return on Ad spendRatio of total revenue won attributed to LinkedIn marketing divided by LinkedIn ad spend (Revenue Won / Total Ad Spend)All Impression Metrics
all_impression_revenue_won_amountNUMERICAll impression revenue won amountAmount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsAll Impression Metrics
all_impression_revenue_won_currency_codeTEXTAll impression revenue won currency codeCurrency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsAll Impression Metrics
daily_click_ad_spend_amountNUMERICDaily click ad spend amountAmount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcDaily Click Metrics
daily_click_ad_spend_currency_codeTEXTDaily click ad spend currency codeCurrency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcDaily Click Metrics
daily_click_average_days_to_closeNUMERICDaily click average days to closeThe average number of days to close a won deal attributed to LinkedIn marketing (Opportunity length/Number of closed wonopportunities)Daily Click Metrics
daily_click_average_deal_size_amountNUMERICDaily click average deal size amountAmount of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)Daily Click Metrics
daily_click_average_deal_size_currency_codeTEXTDaily click average deal size currency codeCurrency code of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)Daily Click Metrics
daily_click_closed_won_opportunitiesNUMERICDaily click closed won opportunitiesNumber of closed-won opportunities attributed to LinkedIn marketingDaily Click Metrics
daily_click_lead_conversion_rateNUMERICDaily click lead conversion rateRate of total number of leads which are converted to contacts out of all the leads in CRM (Number of converted leads / Total number of leads)Daily Click Metrics
daily_click_leadsNUMERICDaily click leadsNumber of active leads in the pipeline attributed to LinkedIn marketingDaily Click Metrics
daily_click_open_opportunitiesNUMERICDaily click open opportunitiesNumber of active opportunities in the pipeline attributed to LinkedIn marketing.Daily Click Metrics
daily_click_opportunity_amount_amountNUMERICDaily click opportunity amount amountAmount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingDaily Click Metrics
daily_click_opportunity_amount_currency_codeTEXTDaily click opportunity amount currency codeCurrency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingDaily Click Metrics
daily_click_opportunity_win_rateNUMERICDaily click opportunity win rateRate at which the opportunities are won out of all the closed opportunities (Number of closed won opportunities / Number of closed opportunities)Daily Click Metrics
daily_click_return_on_ad_spendNUMERICDaily click return on Ad spendRatio of total revenue won attributed to LinkedIn marketing divided by LinkedIn ad spend (Revenue Won / Total Ad Spend)Daily Click Metrics
daily_click_revenue_won_amountNUMERICDaily click revenue won amountAmount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsDaily Click Metrics
daily_click_revenue_won_currency_codeTEXTDaily click revenue won currency codeCurrency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsDaily Click Metrics
daily_impression_ad_spend_amountNUMERICDaily impression ad spend amountAmount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcDaily Impression Metrics
daily_impression_ad_spend_currency_codeTEXTDaily impression ad spend currency codeCurrency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etcDaily Impression Metrics
daily_impression_average_days_to_closeNUMERICDaily impression average days to closeThe average number of days to close a won deal attributed to LinkedIn marketing (Opportunity length/Number of closed wonopportunities)Daily Impression Metrics
daily_impression_average_deal_size_amountNUMERICDaily impression average deal size amountAmount of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)Daily Impression Metrics
daily_impression_average_deal_size_currency_codeTEXTDaily impression average deal size currency codeCurrency code of closed-win opportunities, what is the average size of the deals Linkedin is driving (Revenue Won / Number of closed won opportunities)Daily Impression Metrics
daily_impression_closed_won_opportunitiesNUMERICDaily impression closed won opportunitiesNumber of closed-won opportunities attributed to LinkedIn marketingDaily Impression Metrics
daily_impression_lead_conversion_rateNUMERICDaily impression lead conversion rateRate of total number of leads which are converted to contacts out of all the leads in CRM (Number of converted leads / Total number of leads)Daily Impression Metrics
daily_impression_leadsNUMERICDaily impression leadsNumber of active leads in the pipeline attributed to LinkedIn marketingDaily Impression Metrics
daily_impression_open_opportunitiesNUMERICDaily impression open opportunitiesNumber of active opportunities in the pipeline attributed to LinkedIn marketing.Daily Impression Metrics
daily_impression_opportunity_amount_amountNUMERICDaily impression opportunity amount amountAmount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingDaily Impression Metrics
daily_impression_opportunity_amount_currency_codeTEXTDaily impression opportunity amount currency codeCurrency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketingDaily Impression Metrics
daily_impression_opportunity_win_rateNUMERICDaily impression opportunity win rateRate at which the opportunities are won out of all the closed opportunities (Number of closed won opportunities / Number of closed opportunities)Daily Impression Metrics
daily_impression_return_on_ad_spendNUMERICDaily impression return on Ad spendRatio of total revenue won attributed to LinkedIn marketing divided by LinkedIn ad spend (Revenue Won / Total Ad Spend)Daily Impression Metrics
daily_impression_revenue_won_amountNUMERICDaily impression revenue won amountAmount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsDaily Impression Metrics
daily_impression_revenue_won_currency_codeTEXTDaily impression revenue won currency codeCurrency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn adsDaily Impression Metrics
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDateDimensions
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date