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
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Business Manager Account ID | Dimensions |
| account_name | TEXT | Account name | Business Manager Account Name | Dimensions |
| all_click_ad_spend_amount | NUMERIC | All click ad spend amount | Amount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | All Click Metrics |
| all_click_ad_spend_currency_code | TEXT | All click ad spend currency code | Currency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | All Click Metrics |
| all_click_average_days_to_close | NUMERIC | All click average days to close | The 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_amount | NUMERIC | All click average deal size amount | Amount 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_code | TEXT | All click average deal size currency code | Currency 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_opportunities | NUMERIC | All click closed won opportunities | Number of closed-won opportunities attributed to LinkedIn marketing | All Click Metrics |
| all_click_lead_conversion_rate | NUMERIC | All click lead conversion rate | Rate 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_leads | NUMERIC | All click leads | Number of active leads in the pipeline attributed to LinkedIn marketing | All Click Metrics |
| all_click_open_opportunities | NUMERIC | All click open opportunities | Number of active opportunities in the pipeline attributed to LinkedIn marketing. | All Click Metrics |
| all_click_opportunity_amount_amount | NUMERIC | All click opportunity amount amount | Amount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | All Click Metrics |
| all_click_opportunity_amount_currency_code | TEXT | All click opportunity amount currency code | Currency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | All Click Metrics |
| all_click_opportunity_win_rate | NUMERIC | All click opportunity win rate | Rate 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_spend | NUMERIC | All click return on Ad spend | Ratio 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_amount | NUMERIC | All click revenue won amount | Amount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | All Click Metrics |
| all_click_revenue_won_currency_code | TEXT | All click revenue won currency code | Currency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | All Click Metrics |
| all_impression_ad_spend_amount | NUMERIC | All impression ad spend amount | Amount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | All Impression Metrics |
| all_impression_ad_spend_currency_code | TEXT | All impression ad spend currency code | Currency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | All Impression Metrics |
| all_impression_average_days_to_close | NUMERIC | All impression average days to close | The 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_amount | NUMERIC | All impression average deal size amount | Amount 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_code | TEXT | All impression average deal size currency code | Currency 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_opportunities | NUMERIC | All impression closed won opportunities | Number of closed-won opportunities attributed to LinkedIn marketing | All Impression Metrics |
| all_impression_lead_conversion_rate | NUMERIC | All impression lead conversion rate | Rate 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_leads | NUMERIC | All impression leads | Number of active leads in the pipeline attributed to LinkedIn marketing | All Impression Metrics |
| all_impression_open_opportunities | NUMERIC | All impression open opportunities | Number of active opportunities in the pipeline attributed to LinkedIn marketing. | All Impression Metrics |
| all_impression_opportunity_amount_amount | NUMERIC | All impression opportunity amount amount | Amount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | All Impression Metrics |
| all_impression_opportunity_amount_currency_code | TEXT | All impression opportunity amount currency code | Currency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | All Impression Metrics |
| all_impression_opportunity_win_rate | NUMERIC | All impression opportunity win rate | Rate 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_spend | NUMERIC | All impression return on Ad spend | Ratio 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_amount | NUMERIC | All impression revenue won amount | Amount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | All Impression Metrics |
| all_impression_revenue_won_currency_code | TEXT | All impression revenue won currency code | Currency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | All Impression Metrics |
| daily_click_ad_spend_amount | NUMERIC | Daily click ad spend amount | Amount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | Daily Click Metrics |
| daily_click_ad_spend_currency_code | TEXT | Daily click ad spend currency code | Currency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | Daily Click Metrics |
| daily_click_average_days_to_close | NUMERIC | Daily click average days to close | The 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_amount | NUMERIC | Daily click average deal size amount | Amount 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_code | TEXT | Daily click average deal size currency code | Currency 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_opportunities | NUMERIC | Daily click closed won opportunities | Number of closed-won opportunities attributed to LinkedIn marketing | Daily Click Metrics |
| daily_click_lead_conversion_rate | NUMERIC | Daily click lead conversion rate | Rate 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_leads | NUMERIC | Daily click leads | Number of active leads in the pipeline attributed to LinkedIn marketing | Daily Click Metrics |
| daily_click_open_opportunities | NUMERIC | Daily click open opportunities | Number of active opportunities in the pipeline attributed to LinkedIn marketing. | Daily Click Metrics |
| daily_click_opportunity_amount_amount | NUMERIC | Daily click opportunity amount amount | Amount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | Daily Click Metrics |
| daily_click_opportunity_amount_currency_code | TEXT | Daily click opportunity amount currency code | Currency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | Daily Click Metrics |
| daily_click_opportunity_win_rate | NUMERIC | Daily click opportunity win rate | Rate 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_spend | NUMERIC | Daily click return on Ad spend | Ratio 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_amount | NUMERIC | Daily click revenue won amount | Amount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | Daily Click Metrics |
| daily_click_revenue_won_currency_code | TEXT | Daily click revenue won currency code | Currency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | Daily Click Metrics |
| daily_impression_ad_spend_amount | NUMERIC | Daily impression ad spend amount | Amount for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | Daily Impression Metrics |
| daily_impression_ad_spend_currency_code | TEXT | Daily impression ad spend currency code | Currency code for revenue spend on LinkedIn Ads for given entity such as business manager account (all ad accounts for it), adaccount,etc | Daily Impression Metrics |
| daily_impression_average_days_to_close | NUMERIC | Daily impression average days to close | The 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_amount | NUMERIC | Daily impression average deal size amount | Amount 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_code | TEXT | Daily impression average deal size currency code | Currency 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_opportunities | NUMERIC | Daily impression closed won opportunities | Number of closed-won opportunities attributed to LinkedIn marketing | Daily Impression Metrics |
| daily_impression_lead_conversion_rate | NUMERIC | Daily impression lead conversion rate | Rate 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_leads | NUMERIC | Daily impression leads | Number of active leads in the pipeline attributed to LinkedIn marketing | Daily Impression Metrics |
| daily_impression_open_opportunities | NUMERIC | Daily impression open opportunities | Number of active opportunities in the pipeline attributed to LinkedIn marketing. | Daily Impression Metrics |
| daily_impression_opportunity_amount_amount | NUMERIC | Daily impression opportunity amount amount | Amount of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | Daily Impression Metrics |
| daily_impression_opportunity_amount_currency_code | TEXT | Daily impression opportunity amount currency code | Currency code of total revenue of openopportunities (CRM deals in progress) attributed to LinkedIn marketing | Daily Impression Metrics |
| daily_impression_opportunity_win_rate | NUMERIC | Daily impression opportunity win rate | Rate 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_spend | NUMERIC | Daily impression return on Ad spend | Ratio 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_amount | NUMERIC | Daily impression revenue won amount | Amount of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | Daily Impression Metrics |
| daily_impression_revenue_won_currency_code | TEXT | Daily impression revenue won currency code | Currency code of sales revenue in customer's Customer Relationship Management (CRM) that can be attributed to being generated through LinkedIn ads | Daily Impression Metrics |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | Date | Dimensions |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |