LinkedIn Ads

LinkedIn Ads enable you to display sponsored content in the LinkedIn feed of professionals you want to reach, by way of single image ads, video ads, and carousel ads. With LinkedIn Ads, you can target your most valuable audiences using accurate, profile-based first-party data.

You can use Hevo Pipelines to replicate your LinkedIn reports to the desired Destination database or data warehouses for scalable analysis.

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.


  • 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:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select LinkedIn Ads.

  4. In the Configure your LinkedIn Ads Account page, click ADD LINKEDIN ADS ACCOUNT.

    Add LinkedIn Ads Account

  5. Provide credentials for your LinkedIn account which has access to at least one advertiser profile, and click Sign In.

    Log in to Linked In account

  6. Click Allow to authorize Hevo to access your advertiser profile to read reporting data.

    Allow Hevo access

  7. In the Configure your LinkedIn Ads Source page, specify the following:

    LinkedIn Source

    • 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 past data must be ingested.

  8. Click TEST & CONTINUE.

  9. 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.


  • 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
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.
Last updated on 11 Aug 2022

Tell us what went wrong