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