Linkedin Ads connector enables our customers to extract data from Linkedin Ads Campaign Manager into any reporting tool of their choice including Power BI, Tableau, Looker Studio and many more.
The data can be extracted from multiple Linkedin Ads accounts.
It extracts the most essential data from Linkedin Ads API, however, customisations are possible.
If you can not find some data that you need, feel free to contact us. We are open to customizing our code for individual customers.
The data comes in the following format: Linkedin Ads Connector.xlsx
We charge a one-off set up fee for our connector and no subscription.
Below is the documentation for the tables inside the Linkedin ads connector:
This table returns the daily metric values for every campaign id.
| Value | Description |
| campaign_id | Campaign ID |
| shares | Number of shares |
| externalWebsiteConversions | Number of website conversions |
| landingPageClicks | Number of landing page clicks |
| costInLocalCurrency | Cost in local currency |
| impressions | Number of impressions |
| likes | Number of likes |
| comments | Number of comments |
| follows | Number of follows |
| reactions | Number of reactions |
| leadGenerationMailContactInfoShares | Number of mail contact info shares |
| leadGenerationMailInterestedClicks | Number of interested clicks |
| oneClickLeads | Number of one click leads |
| oneClickLeadFormOpens | Number of lead form opens |
| costInUsd | Cost in USD |
| date | Date |
This table returns more information about every campaign. It can be joined to All analytics using campaign ID.
| Value | Description |
| id | Campaign ID |
| name | Campaign Name |
| account | Linkedin Campaign Manager account IDs |
| status | Complete/draft/active/etc |
| storyDeliveryEnabled | True/False |
| pacingStrategy | Budget pacing strategy. This could be lifetime, daily, etc |
| type | Campaign type |
| optimizationTargetType | The targeted metric to optimize for the linkedin algorithm. This could be CPM, number of leads, number of clicks, etc |
| costType | Cost type |
| creativeSelection | Optimised/not optimized |
| offsiteDeliveryEnabled | True/False |
| audienceExpansionEnabled | True/False |
| campaign_format | Single video, carousel, standard update, etc |
| objectiveType | Video View, Lead Gen, Brand Awareness, Engagement |
| associatedEntity | organization id running linkedin ads |
| campaignGroup | Campaign Group ID |
| totalBudget_currencyCode | Currency code for the ads. Blank if the pacing strategy is daily. |
| totalBudged_amount | Total Budgeted amount in the selected currency. Blank if the pacing strategy is daily |
| dailyBudget_currencyCode | Currency code for the ads. Blank if the pacing strategy is lifetime. |
| dailyBudget_amount | Total Budgeted amount in the selected currency. Blank if the pacing strategy is lifetime |
| locale_country | Locale Country |
| locale_language | Locale Language code |
| runSchedule_start | Date/time for the start of ads |
| runSchedule_end | Date/time for the end of ads |
| servingStatuses | Serving status of the account. If an account is eligible for serving, then this array will have a single element: RUNNABLE Otherwise, this array will contain one or more reasons why the account is not servable |
| versionTag | Each entity has a version tag associated with it. The version tag is initiated to 1 when the entity is created. Each single update to the entity increases its version tag by 1. |
| unitCost_currencyCode | Currency for bids per result of your campaigns |
| unitCost_amount | amount to be bid per result such as a lead, follower, etc |
This table contains the list of all the tag ids and websites where your linkedin insights tags are installed. These tags are needed for linkedin conversion tracking on your websites.
If you want to check which website have the tag and which ones are missing it, you will be able to see this inside of this table.
| Value | Description |
| insightTag | Insight tag ID |
| domainName | Domain Name where the tag is installed |
| blocked | True/False |
| created | Date/time created |
| lastCallbackAt | Date/time of last callback |
