---
title: "LinkedIn Ads"
slug: "linkedin-ads"
description: "Get the most out of your LinkedIn Ads data with Dataddo. Connect your LinkedIn Ads account & easily extract metrics and attributes even from multiple accounts."
updated: 2025-03-09T17:06:49Z
published: 2025-03-09T17:06:49Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# LinkedIn Ads

**LinkedIn Ads** is an advertising platform that enables businesses to create and run targeted advertising campaigns on LinkedIn. It offers a range of ad formats and targeting options, allowing businesses to reach specific professional audiences based on criteria such as job title, industry, location, and more, helping them promote their products or services and generate leads within the professional networking environment.

Refer to Microsoft's official documentation to see [all available endpoints from the LinkedIn Ads API](https://learn.microsoft.com/en-us/linkedin/marketing/integrations/ads/ads-overview?view=li-lms-2025-02).

If you have multiple LinkedIn Ads accounts and would like to extract the same data from all of them, it's possible through [multi-account extraction](/docs/multi-account-extraction). Contact our Solutions team to enable this feature.

## Authorize Connection to LinkedIn Ads

To authorize this service, use **OAuth 2.0** to share specific data with Dataddo while keeping usernames, passwords, and other information private.

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select your service.
2. Follow the on-screen prompts to grant Dataddo the necessary permissions to **access and retrieve** your data.
3. **[Optional]** Once your ***authorizer*** is created, click on it to **change the label** for easier identification.

Ensure that the account you're granting access to holds at least **admin-level permissions**. If necessary, assign a team member with the required permissions with the [authorizer role](https://docs.dataddo.com/docs/user-roles#authorizer) to authenticate the service for you.

          **DATADDO TIP**

          

The best practice is to create a [**dedicated system user**](https://docs.microsoft.com/en-us/linkedin/marketing/getting-started).

For more information, see our article on [***authorizers***](https://docs.dataddo.com/docs/authorized-services).

## How to Create a LinkedIn Ads Data Source

1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button.
2. Select the connector from the list and name your ***data source***.
3. On the **Dataset** step, select your **dataset**.
          **DATADDO TIP**

          

If you're unsure which dataset to select, use the search bar to look for datasets with the desired attributes or metrics.
4. On the **Account** step select your ***authorizer*** from the drop-down menu.
          **Didn't find your authorizer?**

          

Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).
5. On the **Attributes and Metrics** step, select the **metrics and attributes** you want to extract.  

![Create a source using a custom-schema connector.](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Create%20Source%20-%20Custom-Schema%20Connector.png)
6. On the **Metadata** step, select which [**metadata fields**](/docs/metadata-inclusion) such as extraction time to add to your data.
7. On the **Snapshot** step:
  1. Configure your [**sync frequency**](/docs/extraction#extraction-frequency) or click **Show advanced settings** to set the exact synchronization time.
          **DATADDO TIP**

          

If you need to **load historical data**, refer to the [**Data Backfilling**](https://docs.dataddo.com/docs/data-backfilling) article.
  2. [Optional] Enable the **Allow Empty Data Extractions** toggle to allow the extraction when no data is available.
8. In the top-right corner, click **Test Data** button to preview extracted data. You can **adjust the date range** for a specific time frame.
9. Click on **Save** and **congratulations, your new data source is ready!**

---

## Limitations

### Number of Metrics and Labels

When creating your LinkedIn Ads ***data source***, you can select up to **15** metrics and **10** labels.

          **DATADDO TIP**

          

**Data labels** depend on the **Pivot** you select: Account, Campaign, Campaign Group, Creative, Conversion, or Share.

### Number of Rows

Under normal circumstances, the LinkedIn Ads API sets a hard limit on the total number of rows that can be extracted per call.

To overcome this limitation, Dataddo supports automatic pagination to make multiple calls and retrieve all your data.

For the exact limitations, please refer to [Microsoft's official documentation](https://docs.microsoft.com/en-us/linkedin/marketing/integrations/ads-reporting/ads-reporting?tabs=http#data-throttling).

### Yearly Reauthorization Requirement

The LinkedIn API requires [reauthorization](/docs/authorized-services#how-to-reauthorize-your-account) **every year**.

---

## Troubleshooting

### Data Preview Unavailable

No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are:

- **Date range**: Try a smaller date range. You can load the rest of your data afterward using [manual data load](https://docs.dataddo.com/docs/data-backfilling).
- **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions.
- **Invalid metrics, attributes, or breakdowns**: You may not have any data for the selected metrics, attributes, or breakdowns.
- **Incompatible combination of metrics, attributes, or breakdowns**: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same ***data source***.

  

### Metric and Ad Recall Data Don't Match

The **Reach** and **Recall** metrics cannot be summed to get the totals for longer time periods. As these metrics measure the **daily unique users** who view your ad (= reach) or will remember the ad (=ad recall), it is **not possible to get data for a specific time period and/or aggregate the data**.

To avoid this, you can

1. Get **daily** breakdowns: The daily values will match, but not when summed up over a longer time period.
2. Extract data **weekly or monthly**: These weekly/monthly values will match.

Simply create a **new source** and a **new flow** with the particular breakdown (for example, a source and a flow with daily breakdowns/synchronizations).

          
          

Read more about the metrics, and why the data may not be matching [here](https://blog.dataddo.com/why-the-numbers-in-your-bi-tool-dont-always-match-your-source-data?_gl=1*ipsbl8*_ga*MjAwMjE2NTU4NC4xNjUxNzM0NTI4*_ga_NQ4TN4KP4V*MTY1MTc2NzQwMC40LjEuMTY1MTc2Nzg4OS4z).

### Extra Empty Columns Named CREATIVE TEXT and CREATIVE TITLE

Your Ad Creatives are most likely of the **Sponsored Status Update** type which does not have this kind of information available.

          To see how you can get your **Sponsored Status Update** ad data, please see [this section](/docs/linkedin-ads#retrieve-information-on-shares-from-sponsored-status-update-creatives).

          

There are two kinds of Ad Creatives on LinkedIn: **Text Ad** and **Sponsored Status Update** with slightly different schemas. Only **Text Ad** contains populated `TEXT` and `TITLE` fields. ![Linkedin Ads - empty columns Creative text and title.png](https://cdn.document360.io/084ed225-3f99-4644-a2da-39ca0cd5ef45/Images/Documentation/Linkedin%20Ads%20-%20empty%20columns%20%28Creative%20text%20and%20title%29%20%281%29.png)

For more information on the **Ad Creative** fields, refer to [Microsoft’s official documentation](https://learn.microsoft.com/en-us/linkedin/shared/references/v2/ads/adcreatives?context=linkedin%2Fmarketing%2Fcontext).

### Retrieve Information on Shares from Sponsored Status Update Creatives

1. [Create a second source](https://app.dataddo.com/sources/new) using the **LinkedIn** connector (**not** LinkedIn Ads).
2. Select the **Shares and UGC Posts Details** dataset. This dataset contains basic data about your shares such as text and description.
3. Select the **Creative share ID** field.
4. [Blend](https://docs.dataddo.com/docs/data-blending) your LinkedIn and LinkedIn Ads ***data sources*** using **share ID** as the join key.

### Missing approximateUniqueImpressions Data

If your `approximateUniqueImpressions` values become 0, set your date range as **less than or equal to 92 days**.

If you select a bigger date range, this metric will become unavailable and 0 will be displayed instead.

## Related Articles

Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage.

**Sending Data to Dashboarding Apps**

- [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
- [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**

- [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**

- [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
- [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
- [Data Duplication](https://docs.dataddo.com/docs/data-duplication)

Multi-account extraction (MAE) enables simultaneous data extraction from multiple e.g. Facebook accounts within a single source setup. This ensures consistent configuration of your data sources across all accounts.

Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.

A source is a collection of data from an authorized service that's been connected via a Dataddo connector. Data within the source is automatically refreshed based on the source's configuration.

Pagination divides large datasets into smaller 'pages' to manage and assemble complete data. This is useful when an API endpoint has a restriction on the number of records extractable in a single call.
