Integration of LinkedIn Ads with BigQuery

Learn how to connect LinkedIn Ads to Google BigQuery using WitCloud and automatically fetch account, campaign and creative performance, cost and conversion data.

Updated

Introduction

This module integrates with the LinkedIn Marketing API, enabling you to collect account, campaign and creative performance data (impressions, clicks, engagements, cost and conversions) and store it in Google Cloud BigQuery. Having it in BigQuery lets you join LinkedIn Ads data with your other advertising and web analytics data.

Configuration guide

Follow the steps below to connect LinkedIn Ads with BigQuery. Once the setup is complete, your data will be automatically transferred to your BigQuery project.

Authorize with a LinkedIn account that has access to the LinkedIn Ads accounts you want to export. Only the ad accounts that account can reach are offered in the account list.

Module setup

Go to the Integrations section in the menu > Click Add integration.

Integrations list with the Add integration button

Select LinkedIn Ads from the list of available integrations.

Integration catalog filtered to LinkedIn Ads

Enter the Collect name, e.g., "LinkedIn Ads PL".

Collect name field filled in with the example name LinkedIn Ads PL

Authorization

If you have already authorized LinkedIn, simply pick that authorization from the Select Linkedin authorization drop-down and skip this step.

Click Authorize.

Authorize button next to the Select Linkedin authorization field

A LinkedIn window opens. Sign in, review the permissions WitCloud asks for and allow them. WitCloud asks for read access to your LinkedIn advertising accounts and their reporting, and to your basic LinkedIn profile, which gives the authorization its name in the drop-down. When the window closes, the new authorization is selected for you.

Accounts

Open the Select accounts drop-down and choose the LinkedIn Ads accounts to export.

Select accounts drop-down open with example LinkedIn Ads accounts

You can select several accounts.

Select accounts field with two example LinkedIn Ads accounts selected

Each selected account becomes its own data collect named "<Collect name> - <account name>", with its own set of tables in BigQuery. All of them use the settings you enter below.

Advanced settings

Click Show advanced settings to choose the Tables to collect. All three tables are selected by default and at least one must stay selected. Remove the ones you do not need: they will not be filled with data, which makes the collection faster.

Advanced settings open with the Tables to collect field

Table to collectWhat it holds
account_performanceDaily performance of the whole ad account
campaign_performanceDaily performance per campaign
creative_performanceDaily performance per creative (ad)

Click Next to continue.

Historical data and scheduling

In the Historical Data field enter the number of days of history to fetch (required, at most 365).

Historical Data field filled in with 365 days

A data synchronization schedule will be created automatically. More information on this topic can be found here.

Click Create to complete the configuration.

Data collection settings with the Create button

Done! Your LinkedIn Ads data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your ad campaigns.

Data schema

Expand the tables below to view the full data schema collected from LinkedIn Ads. Every row is one day (time_granularity is DAILY).

Data schema for linkedin_account_performance
Field NameModeType
dateNULLABLEDATE
time_granularityNULLABLESTRING
currencyNULLABLESTRING
account_idNULLABLESTRING
account_nameNULLABLESTRING
impressionsNULLABLEINTEGER
clicksNULLABLEINTEGER
landingPageClicksNULLABLEINTEGER
totalEngagementsNULLABLEINTEGER
likesNULLABLEINTEGER
sharesNULLABLEINTEGER
commentsNULLABLEINTEGER
videoViewsNULLABLEINTEGER
opensNULLABLEINTEGER
sendsNULLABLEINTEGER
followsNULLABLEINTEGER
costInLocalCurrencyNULLABLEFLOAT
costInUsdNULLABLEFLOAT
externalWebsiteConversionsNULLABLEINTEGER
conversionValueInLocalCurrencyNULLABLEFLOAT
Data schema for linkedin_campaign_performance
Field NameModeType
dateNULLABLEDATE
time_granularityNULLABLESTRING
currencyNULLABLESTRING
account_idNULLABLESTRING
account_nameNULLABLESTRING
campaign_idNULLABLESTRING
campaign_nameNULLABLESTRING
impressionsNULLABLEINTEGER
clicksNULLABLEINTEGER
landingPageClicksNULLABLEINTEGER
totalEngagementsNULLABLEINTEGER
likesNULLABLEINTEGER
sharesNULLABLEINTEGER
commentsNULLABLEINTEGER
videoViewsNULLABLEINTEGER
opensNULLABLEINTEGER
sendsNULLABLEINTEGER
followsNULLABLEINTEGER
costInLocalCurrencyNULLABLEFLOAT
costInUsdNULLABLEFLOAT
externalWebsiteConversionsNULLABLEINTEGER
conversionValueInLocalCurrencyNULLABLEFLOAT
Data schema for linkedin_creative_performance
Field NameModeType
dateNULLABLEDATE
time_granularityNULLABLESTRING
currencyNULLABLESTRING
account_idNULLABLESTRING
account_nameNULLABLESTRING
creative_idNULLABLESTRING
creative_nameNULLABLESTRING
impressionsNULLABLEINTEGER
clicksNULLABLEINTEGER
landingPageClicksNULLABLEINTEGER
totalEngagementsNULLABLEINTEGER
likesNULLABLEINTEGER
sharesNULLABLEINTEGER
commentsNULLABLEINTEGER
videoViewsNULLABLEINTEGER
opensNULLABLEINTEGER
sendsNULLABLEINTEGER
followsNULLABLEINTEGER
costInLocalCurrencyNULLABLEFLOAT
costInUsdNULLABLEFLOAT
externalWebsiteConversionsNULLABLEINTEGER
conversionValueInLocalCurrencyNULLABLEFLOAT