LinkedIn Ads

Last updated on Sep 22, 2023

For creating Pipelines using this Source, Hevo provides you with a fully managed BigQuery data warehouse as a possible Destination. This option remains available till the time you set up your first BigQuery Destination, irrespective of any other Destinations that you may have. With the managed warehouse, you are only charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month, and payment is recovered as per the payment instrument you have set up. You can now create your Pipeline and directly start analyzing your Source data. Read Hevo Managed Google BigQuery.

Setup

Data Sync

Prerequisites

An active LinkedIn account with access to at least one advertiser profile.
You have Admin access to the company’s LinkedIn page.

Note: You can create a Pipeline without Admin access too. However, it will not be able to access data from a few objects such as Page Stats, Follower Stats, Share Stats, and Video Ads.
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.

Configuring LinkedIn Ads as a Source

Perform the following steps to configure LinkedIn Ads as the Source in your Pipeline:

Click PIPELINES in the Navigation Bar.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select LinkedIn Ads.
In the Configure your LinkedIn Ads Account page, click ADD LINKEDIN ADS ACCOUNT.
Provide credentials of your LinkedIn account that has access to at least one advertiser profile and click Sign In.
Click Allow, authorizing Hevo to access your advertiser profile.
In the Configure your LinkedIn Ads Source page, specify the following:
- Pipeline Name: A unique name for the Pipeline.
- Select Accounts: Select the advertiser profiles from which you want to replicate the reports’ data.
- Historical Sync Duration: The duration for which the existing data in the Source must be ingested. Default duration: 6 Months.
  
  Note: If you select All Available Data, Hevo ingests all the data available in your LinkedIn Ads account since January 01, 1970. Refer to the section, Limitations, to know about the objects from which Hevo fetches data for a limited period.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
1 Hr	1 Hr	48 Hrs	1-48

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

Historical Data: Hevo ingests the historical data for Ad Analytics and Stats objects on the basis of the historical sync duration selected at the time of creating the Pipeline. Refer to the section, Limitations, to know about the objects from which Hevo fetches data for a limited period.
Incremental Data: Once the historical data ingestion is complete, every subsequent run of the Pipeline fetches the entire data for the objects you select. All objects apart from Ad Analytics and Stats are loaded from scratch on every run.
Data Refresh: Data for the last 30 days is refreshed on a rolling basis for Ad Analytics objects. Data for Stats objects is refreshed for the past two days to include attributed data for the past days.

Schema and Primary Keys

Hevo uses the following schema to upload the records to the Destination database:

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Account	Contains details of the advertising campaigns created and managed for your company.
Account User	Contains details of the account members who have access to the ad account in LinkedIn Campaign Manager, along with their roles.
Campaigns	Contains details of the criteria used to achieve an advertising objective.
Campaign Group	Contains details of the campaigns associated with the LinkedIn Ads account, along with their budget, criteria, and other settings.
Creatives	Contains details of the content, such as images, text, and videos, required for displaying an ad on the LinkedIn platform. Note: - Hevo does not store the original content details, such as the raw text or images, associated with the ad. - For Pipelines created from June 19, 2023 onwards, Hevo uses the versioned Creatives API instead of the unversioned adCreativesV2 API to ingest data from this object.
Conversions	Contains details of the performance of the ongoing ad campaigns within your LinkedIn Ads account, along with their corresponding conversion metrics.
Ad Analytics by Campaign	Contains details of the analytics, such as views, conversions, and clicks for ad campaigns, aggregated on a daily basis.
Ad Analytics by Creative	Contains details of the analytics, such as views, conversions, and clicks for ad creatives, aggregated on a daily basis.
Page Stats	Contains details of the view and click statistics related to your company’s LinkedIn page(s).
Follower Stats	Contains details of the statistics associated to the followers on your company’s LinkedIn page(s).
Share Stats	Contains details of the statistics associated to sharing on your company’s LinkedIn page(s). It might include shares made by other pages, visitors, or the company itself.
Video Ads	Contains details of the ads listed on your company’s LinkedIn page(s) in the video format.

Additional Information

Read the detailed Hevo documentation for the following related topics:

Limitations

Limitations

LinkedIn restricts the amount of data that can be fetched from certain objects. As a result, with the All Available Data option, Hevo ingests historical data for a limited period from them. The following table lists the time and the affected objects:

Time	Objects
Up to six months	- Ad Analytics by Campaign - Ad Analytics by Creative
Up to one year	- Page Stats - Follower Stats - View Stats

Revision History

Refer to the following table for the list of key updates made to this page:

Date	Release	Description of Change
Sep-22-2023	NA	Removed the banner from the top of the page about migration to versioned APIs.
Jul-25-2023	NA	Updated section, Data Model for better clarity.
Jun-19-2023	2.14	- Added a banner at the top of the page to mention about migration to versioned APIs. - Updated section, Data Model to add information about versioned APIs.
Feb-20-2023	NA	Updated section, Configuring LinkedIn Ads as a Source to update the information about historical sync duration.
Jul-11-2022	NA	Updated the ERD table in the Schema and Primary Keys section.
Oct-25-2021	NA	Added the Pipeline frequency information in the Data Replication section.
Jul-26-2021	NA	Added a note in the Overview section about Hevo providing a fully-managed Google BigQuery Destination for Pipelines created with this Source.