Dataddo LinkedIn Ads connector enables simple API data extraction without writing a single line of code.
When authorizing access, make sure that the user has correct permissions. To access the account analytics data, the user has to have assigned ADMINISTRATOR permission. However, the best practice is to create a dedicated system user. Please check the following official documentation for further details: https://docs.microsoft.com/en-us/linkedin/marketing/getting-started
Dataddo can extract all the metrics provided via an official API. The full list is available here: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting?tabs=http#metrics-available
LinkedIn Ads API has a hard limit for the total number of rows that can be extracted. Dataddo supports automatic pagination, so the data extraction is in fact distributed into multiple rows. The exact limitation is available here: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting?tabs=http#data-throttling
Dataddo LinkedIn Ads connector supports automatic extraction from all the available LinkedIn Ads accounts. This feature is particularly useful when you have (e.g. being an online agency) multiple accounts and need to automatically extract the same metrics and dimensions across them.
Creating a LinkedIn Ads Data Source
To create a LinkedIn Ads data source, navigate to Sources at the top left of the Dataddo app.
Then click on New Sources from the top right corner.
From the list of connectors, choose the LinkedIn Ads connector.
You will be redirected to the LinkedIn Ads connector. First of all, you will need to give Dataddo authorization to connect with your LinkedIn Ads account. Once you click on Authorize, you will be redirected to your account to log in.
Having a problem with the authorization process?
After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more LinkedIn Ads accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu. Once you select the account you will also have to select the Ads account.
Next, you can name your data source, and select the Pivot, an element that groups the labels. (Choosing a different Pivot will change your available labels.) After that, select your desired Time Breakdown, Metrics, and Labels
The Pivots are closely described here: https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting?tabs=http#analytics-finder
NOTE: You can only select 15 metrics and 10 labels per source
Missing metric or label?
On the snapshotting page, you will set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.
- Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
- Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
- If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.
Now you are all set and ready. Click on See Preview to review all the selections you've made before saving the Data Source using the button in the top right corner Save source.
Your new source is now created. You can click on Add source to a flow to bind the source with a flow. To create a flow, please follow our Creating a data flow guide.