Edit on GitHub
LinkedIn Ad Analytics link
LinkedIn Ad Analytics offers you information about the performance of your LinkedIn Ads.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | ||
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | check | All tables except report tables |
API configurable | check | API configuration |
Priority-first sync | check | Reporting tables |
Fivetran data models | check | Get the models: source / transform; Get the ad reporting model; Supports Quickstart data models |
Private networking |
Setup guidelink
Follow our step-by-step LinkedIn Ad Analytics setup guide to connect LinkedIn Ad Analytics with your destination using Fivetran connectors.
Schema informationlink
This schema applies to all LinkedIn Ad Analytics connectors.
To zoom, open the ERD in a new window.
Sync noteslink
The CREATIVE_HISTORY
table stores data from various ad formats.
- The Follower, Job, Spotlight, and Text Ad creative types have corresponding names stored in dedicated fields:
- Follower corresponds to the
follower_headline
field. - Job corresponds to the
jobs_headline
field. - Spotlight corresponds to the
spotlight_headline
field. - Text Ad corresponds to the
text_ad_headline
field.
- Follower corresponds to the
- If the reference field contains a URN (Uniform Resource Name), the corresponding names are stored differently depending on the content type.
- Shares and UGC posts: Names are stored in the
Content
table'sarticle_title
andmedia_title
fields for articles and media posts, respectively. - In-mail content: The name is stored in the
in_mail_content_history
table'sname
field.
- Shares and UGC posts: Names are stored in the