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.

Prerequisites

  • An active LinkedIn account with access to at least one advertiser profile.

  • Account Manager access to the user being used to authorise the application.

    Note: You can create a Pipeline without Account Manager access too, however, you will not be able to access certain objects such as Accounts, Page statistics, View statistics, and Share statistics.

Configuring LinkedIn Ads as a Source

Perform the following steps to configure LinkedIn Ads as a Source in Hevo:

1. Enable Hevo to access your LinkedIn Ads data

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipeline 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

2. Set up LinkedIn Ads in Hevo

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

    LinkedIn Source

    1. Pipeline Name: A unique name for the Pipeline.

    2. Select Accounts: Select the advertiser profiles for replicating the reports data.
    3. Historical Sync Duration: The duration for which the past data must be ingested.

      Note: You can fetch data for ad_analytics_by_campaign or ad_analytics_by_creative reports for more than six months by changing the position of these objects to any past date up till 1 year from the current date, in the Pipeline Overview page.

  2. Click TEST & CONTINUE.
  3. Proceed to configuring the data ingestion and setting up the Destination.

Data Replication

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

    Note: You can fetch data for ad_analytics_by_campaign or ad_analytics_by_creative reports for more than six months by changing the position of these objects to any past date up till 1 year from the current date, in the Pipeline Overview page.

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

LinkedIn Ads ERD

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

Limitations

None.

Last updated on 16 Nov 2020