LinkedIn Ads

Last updated on Feb 20, 2023

For creating Pipelines using this Source, Hevo provides you 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.
Admin access to the organization’s LinkedIn page.

Note: You can create a Pipeline without Admin access too. However, you will not be able to access certain objects such as Page statistics, Follower statistics, Share statistics and Video Ads.

Configuring LinkedIn Ads as a Source

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

Click PIPELINES in the Asset Palette.
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 for your LinkedIn account which has access to at least one advertiser profile, and click Sign In.
Click Allow to authorize Hevo to access your advertiser profile to read reporting data.
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 for replicating 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 fetches all the data created since January 01, 1970, for your account.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (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, 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. See Limitations.
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 in 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	Individual ad accounts listed under an advertiser.
Account User	Details for all the ad account members, who have permissions to the ad account in LinkedIn Campaign Manager, along with details of their roles.
Campaign	Details of all campaigns such as ID, account, campaign group, name, type, and status fields.
Campaign Group	Details about the campaign group, such as status, budget, and performance schedules across multiple related campaigns.
Creative	All activity related information of all ad creatives. Note: Hevo does not store raw information of the creative such as the text or images.
Conversion	Conversion tracking Events for all LinkedIn Ad campaigns.
Ad Analytics by Campaign	Daily ad-level aggregated analytical data containing details of all views, conversions, and click-level data of various types of ad campaigns.
Ad Analytics by Creative	Daily ad creative-level aggregated analytical data containing details of all views, conversions, and click-level data of various types of ad campaigns.
Page Stats	Daily page statistics for all LinkedIn pages listed under the organisation.
Follower Stats	Daily follower statistics for all LinkedIn pages listed under the organisation.
Share Stats	Daily share statistics for all LinkedIn pages listed under the organisation. Shared statistics could be for shares done by the organisation’s page itself, or by visitors or other pages.
Video Ads	Details of video ads for all LinkedIn pages listed under the organisation.

Additional Information

Read the detailed Hevo documentation for the following related topics:

Limitations

Limitations

All available data will fetch data up to 6 months for Ad Analytics by Campaign and Ad Analytics by Creative and up to one year for Page statistics, Follower statistics and View statistics due to limits enforced by LinkedIn.

Revision History

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

Date	Release	Description of Change
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.