On This Page
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.
or 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.
Adminaccess to the organization’s LinkedIn page.
Note: You can create a Pipeline without
Adminaccess too. However, you will not be able to access certain objects such as
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 past data must be ingested.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.
Historical Data: Hevo ingests the historical data for
statsobjects 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
statsare loaded from scratch on every run.
Data Refresh: Data for the last 30 days is refreshed on a rolling basis for
ad_analyticsobjects. Data for
statsobjects 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:
The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:
|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 datawill fetch data up to 6 months for
Ad Analytics by Campaignand
Ad Analytics by Creativeand up to one year for
View statisticsdue to limits enforced by LinkedIn.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Jul-26-2021||NA||Added a note in the Overview section about Hevo providing a fully-mananged Google BigQuery Destination for Pipelines created with this Source.|