LinkedIn Ads

LinkedIn Ads

This document provides instructions for collecting LinkedIn Ads data into Panoply. The following items will be covered:

Collecting

Users must have an Enterprise or Business Ads Account in Campaign Manager and have an authenticated user who is an administrator of the account. The data Panoply has available after the user is logged in will be the same data the user has access to in LinkedIn Ads. For more information, see Create and Manage Accounts

To avoid problems that can arise, it is recommended that you only have one instance of the LinkedIn Ads data source per logged in user.

To configure this data source and collect LinkedIn Ads data:

  1. From the Data Sources menu, click Add Data Source.
  2. Search for LinkedIn Ads, then select it to continue to the next step.
  3. On the General tab:
    • Click the Login button to and follow the Linkedin authorization flow.
    • Enter your user name and password to allow Panoply to access your LinkedIn Ads data.
    • Select the Account to extract data from. If you do not see data available, double check that you are signed into the correct account.
  4. (Optional) Set the [Advanced Settings](/docs/collect-data/advanced-options/). We do not recommend changing advanced settings unless you are an experienced Panoply user.
    • Pivot: For Ad Analytics only, the Pivot group defines the way the data is grouped. Default is Campaign. For a list of available pivots, see the Data Dictionary below.
    • Historical Range: On the first collection of the Ad Analytics endpoint only, you can select the historical range of the data to collect.
    • Post-Click Attribution: This conversion window is the timeframe within which conversions will be attributed to a LinkedIn ad. LinkedIn advertisers can customize their conversion windows based on their reporting preferences. LinkedIn records conversions within the selected conversion window of a member clicking on a LinkedIn Ad.
    • View-Through Attribution: This conversion window is the timeframe within which conversions will be attributed to a LinkedIn ad. LinkedIn advertisers can customize their conversion windows based on their reporting preferences. LinkedIn records conversions within the selected conversion window of a member seeing a LinkedIn Ad.
    • Destination: The Destination determines the name of the tables that will be created. The default preix for this data source is linkedin_ads. To use a different prefix for the destination table names, enter it in this field.
      • The Ad Analytics endpoint combines the prefix with the name of the pivot to create the table name, with the syntax linkedin_ads_ad_analytics_<pivot> where pivot is a dynamic field representing the name of the collected pivot.
      • All other endpoints combine the prefix with the name of the endpoint to create the table name, with the syntax linkedin_ads_<endpoint> where endpoint is a dynamic field representing the name of the collected endpoint.
  5. Click Save Changes and then click Collect.
    • The data source appears grayed out while the collection runs.
    • You may add additional data sources while this collection runs.
    • You can monitor this collection from the Jobs page or the Data Sources page.
    • After a successful collection, navigate to the Tables page to review the data results.

Data Dictionary

  • Primary Key: The default primary key for the LinkedIn Ads Ad Analytics endpoint is <accountId>_<pivot>_<pivotValue>_<startDate>_<endDate> For other endpoints the primary key is <lastModified>_<id>.

  • Incremental Key: By default, Panoply collects all of your LinkedIn Ads data on the first run. On subsequent collections, Panoply collects from the date of the last successful collection, minus 30 calendar days.

Metadata Panoply includes these metadata columns in each table:

  • __tablename: Name of the Data Available (i.e., endpoint) where the data originated in LinkedIn.
  • __senttime: Formatted as a datetime, such as 2020-04-26T01:26:14.695Z
  • __updatetime: Formatted as a datetime, such as 2020-04-26T01:26:14.695Z

Ad Analytics

For the Ad Analytics endpoint, Panoply creates one table for each of the selected reporting pivots. This is because the data in Panoply is built by accessing the https://api.linkedin.com/v2/adAnalyticsV2 LinkedIn Ads Reporting API endpoint with the pivot={PIVOT-NAME} query parameter (and other parameters) for the selected pivot. The timeGranularity used is DAILY. For more information on the paramters available for the Ad Analytics endpoint, see Ads Reporting

The availble pivot values are:

  • Account: Group results by account.
  • Campaign: (default): Group results by campaign.
  • Company: Group results by advertiser’s company.
  • Creative: Group results by creative.
  • Member_Company: Group results by member company.
  • Member_Company_Size: Group results by member company size.
  • Member_Country_V2: Group results by member country.
  • Member_Region_V2: Group results by member region.
  • Share: Group results by sponsored share.

An empty response is returned if there is no activity to report or if you do not have read access to the requested advertising data.

Some metrics are not available with demographics pivots. To protect LinkedIn member privacy, demographic metrics are approximate. To learn more about this approximation, see Accuracy

LinkedIn has restrictions on data retention. For the timeGranularity=Daily, that restriction is the last six months for demographic data and ten months for non-demographic data. For more information, see retention.

When selecting the Ad Analytics endpoint, you must also aelect the Reporting Pivot, which is used to group the report data.

For more information about the LinkedIn Ads Reporting API, consult the LinkedIn Ads Reporting API documentation.

Ad Accounts

LinkedIn allows advertisers to create multiple Ad Accounts. This table includes the columns available in the Ad Accounts Endpoint. For more information, see LinkedIn Ad Accounts Documentation.

Campaign Groups

Campaign groups provide advertisers a way to manage status, budget, and performance across multiple related campaigns. For more informations, see Linkedin Create and Manage Campaign Groups Documentation.

Campaigns

Campaigns define the schedule and budget of an ad. For more information, see Linkedin Create and Manage Campaigns Documentation.

Creatives

An ad creative conceptually contains all the data for visually rendering the ad. For more information, see Linkedin Create and Manage Creatives Documentation.

Conversions

Conversion tracking gives advertisers confidence that an ad product delivers a measurable return on investment. For more information, see Linkedin Conversion Tracking Documentation.

Getting started is easy! Get all your data in one place in minutes.
Try Free