LinkedIn Ads predefined reports
The LinkedIn Ads data source in Data Integration includes predefined reports. Each report contains a short description of the data, a list of customizable fields (if any), and the schema mapping.
These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.
Source-Level selections
LinkedIn Ad's one source-level selection is Accounts filter. Choosing distinct values filters down each report within the river for the selected accounts' data.
Accounts
The accounts report pulls a list of accounts and their attributes. You can customize the report by selecting an "Accounts Status" in the report-level selection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
id  | Integer | Dimension |
| changeauditstamps | Record | Dimension |
| currency | String | Dimension |
| name | String | Dimension |
| notifiedoncampaignoptimization | Boolean | Dimension |
| notifiedoncreativeapproval | Boolean | Dimension |
| notifiedoncreativerejection | Boolean | Dimension |
| notifiedonendofcampaign | Boolean | Dimension |
| reference | String | Dimension |
| servingstatuses | String | Dimension |
| status | String | Dimension |
| test | Boolean | Dimension |
| type | String | Dimension |
| version | Record | Dimension |
Campaigns
The campaigns report pulls a list of campaigns and their attributes like the ad schedule and budget. You can customize the report by selecting a "Campaigns Status" in the report-level selection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| account | String | Dimension |
| audienceexpansionenabled | Boolean | Dimension |
| campaigngroup | String | Dimension |
| changeauditstamps | Record | Dimension |
| costtype | String | Dimension |
| creativeselection | String | Dimension |
| dailybudget | Record | Dimension |
| format | String | Dimension |
| associatedentity | String | Dimension |
| locale | Record | Dimension |
| name | String | Dimension |
| objectivetype | String | Dimension |
| offsitedeliveryenabled | Boolean | Dimension |
| offsitepreferences | Record | Dimension |
| optimizationtargettype | String | Dimension |
| runschedule | Record | Dimension |
| servingstatuses | String | Dimension |
| status | String | Dimension |
| storydeliveryenabled | Boolean | Dimension |
| targetingcriteria | Record | Dimension |
| test | Boolean | Dimension |
| totalbudget | Record | Dimension |
| type | String | Dimension |
| unitcost | Record | Dimension |
| version | Record | Dimension |
Campaign groups
The campaign groups report pulls data at the Campaign group level to provide advertisers a way to view status, budget, and performance across multiple related campaigns. You can customize the report by selecting a "Campaigns Status" in the report-level selection.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | Integer | Dimension |
| account | String | Dimension |
| allowedcampaigntypes | String | Dimension |
| backfilled | Boolean | Dimension |
| changeauditstamps | Record | Dimension |
| name | String | Dimension |
| runschedule | Record | Dimension |
| servingstatuses | String | Dimension |
| status | String | Dimension |
| test | Boolean | Dimension |
| totalbudget | Record | Dimension |
Creatives shares
The creatives shares report pulls all the information for visually rendering an ad and its attributes. You can customize the report using the "Campaign or Creatives" filter to cut down the output.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | String | Dimension |
| activity | String | Dimension |
| content_contententities_entity | String | Dimension |
| content_contententities_entitylocation | String | Dimension |
| content_contententities_title | String | Dimension |
| content_description | String | Dimension |
| content_sharemediacategory | String | Dimension |
| content_title | String | Dimension |
| created | Record | Dimension |
| edited | Boolean | Dimension |
| content_contententities_description | String | Dimension |
| lastmodified | Record | Dimension |
| owner | String | Dimension |
| text | Record | Dimension |
Ad statistics
The Ad statistics report provides key insights on performance such as clicks, impressions, and ad spend, and demographics information pivoted by account and campaign. The user can customize the report by using the Campaign or Creatives filter to cut down the output. They can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| pivotValue | String | Dimension |
| start_date | String | Dimension |
| actionClicks | Integer | Metric |
| cardClicks | Integer | Metric |
| cardImpressions | Integer | Metric |
| clicks | Integer | Metric |
| commentLikes | Integer | Metric |
| comments | Integer | Metric |
| companyPageClicks | Integer | Metric |
| conversionValueInLocalCurrency | String | Dimension |
| costInLocalCurrency | String | Dimension |
| costInUsd | String | Dimension |
| end_date | String | Dimension |
| externalWebsiteConversions | Integer | Metric |
| externalWebsitePostClickConversions | Integer | Metric |
| externalWebsitePostViewConversions | Integer | Metric |
| follows | Integer | Metric |
| fullScreenPlays | Integer | Metric |
| impressions | Integer | Metric |
| landingPageClicks | Integer | Metric |
| leadGenerationMailContactInfoShares | Integer | Metric |
| leadGenerationMailInterestedClicks | Integer | Metric |
| likes | Integer | Metric |
| oneClickLeadFormOpens | Integer | Metric |
| oneClickLeads | Integer | Metric |
| opens | Integer | Metric |
| otherEngagements | Integer | Metric |
| approximateUniqueImpressions | Integer | Metric |
| pivotValues | String | Dimension |
| reactions | Integer | Metric |
| sends | Integer | Metric |
| shares | Integer | Metric |
| adUnitClicks | Integer | Metric |
| textUrlClicks | Integer | Metric |
| totalEngagements | Integer | Metric |
| videoCompletions | Integer | Metric |
| videoFirstQuartileCompletions | Integer | Metric |
| videoMidpointCompletions | Integer | Metric |
| videoStarts | Integer | Metric |
| videoThirdQuartileCompletions | Integer | Metric |
| videoViews | Integer | Metric |
| viralCardClicks | Integer | Metric |
| viralCardImpressions | Integer | Metric |
| viralClicks | Integer | Metric |
| viralCommentLikes | Integer | Metric |
| viralComments | Integer | Metric |
| viralCompanyPageClicks | Integer | Metric |
| viralExternalWebsiteConversions | Integer | Metric |
| viralExternalWebsitePostClickConversions | Integer | Metric |
| viralExternalWebsitePostViewConversions | Integer | Metric |
| viralFollows | Integer | Metric |
| viralFullScreenPlays | Integer | Metric |
| viralImpressions | Integer | Metric |
| viralLandingPageClicks | Integer | Metric |
| viralLikes | Integer | Metric |
| viralOneClickLeadFormOpens | Integer | Metric |
| viralOneClickLeads | Integer | Metric |
| viralOtherEngagements | Integer | Metric |
| viralReactions | Integer | Metric |
| viralShares | Integer | Metric |
| viralTotalEngagements | Integer | Metric |
| viralVideoCompletions | Integer | Metric |
| viralVideoFirstQuartileCompletions | Integer | Metric |
| viralVideoMidpointCompletions | Integer | Metric |
| viralVideoStarts | Integer | Metric |
| viralVideoThirdQuartileCompletions | Integer | Metric |
| viralVideoViews | Integer | Metric |
Ad analytics
The Ad analytics report provides key insights on performance such as clicks, impressions, and ad spend, and demographics information. The user can customize the report by using the Campaign or Creatives filter to cut down the output. They can also customize the type of incremental load associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| pivotValue | String | Dimension |
| start_date | String | Dimension |
| actionClicks | Integer | Metric |
| cardClicks | Integer | Metric |
| cardImpressions | Integer | Metric |
| clicks | Integer | Metric |
| commentLikes | Integer | Metric |
| comments | Integer | Metric |
| companyPageClicks | Integer | Metric |
| conversionValueInLocalCurrency | String | Dimension |
| costInLocalCurrency | String | Dimension |
| costInUsd | String | Dimension |
| end_date | String | Dimension |
| externalWebsiteConversions | Integer | Metric |
| externalWebsitePostClickConversions | Integer | Metric |
| externalWebsitePostViewConversions | Integer | Metric |
| follows | Integer | Metric |
| fullScreenPlays | Integer | Metric |
| impressions | Integer | Metric |
| landingPageClicks | Integer | Metric |
| leadGenerationMailContactInfoShares | Integer | Metric |
| leadGenerationMailInterestedClicks | Integer | Metric |
| likes | Integer | Metric |
| oneClickLeadFormOpens | Integer | Metric |
| oneClickLeads | Integer | Metric |
| opens | Integer | Metric |
| otherEngagements | Integer | Metric |
| approximateUniqueImpressions | Integer | Metric |
| pivotValues | String | Dimension |
| reactions | Integer | Metric |
| sends | Integer | Metric |
| shares | Integer | Metric |
| adUnitClicks | Integer | Metric |
| textUrlClicks | Integer | Metric |
| totalEngagements | Integer | Metric |
| videoCompletions | Integer | Metric |
| videoFirstQuartileCompletions | Integer | Metric |
| videoMidpointCompletions | Integer | Metric |
| videoStarts | Integer | Metric |
| videoThirdQuartileCompletions | Integer | Metric |
| videoViews | Integer | Metric |
| viralCardClicks | Integer | Metric |
| viralCardImpressions | Integer | Metric |
| viralClicks | Integer | Metric |
| viralCommentLikes | Integer | Metric |
| viralComments | Integer | Metric |
| viralCompanyPageClicks | Integer | Metric |
| viralExternalWebsiteConversions | Integer | Metric |
| viralExternalWebsitePostClickConversions | Integer | Metric |
| viralExternalWebsitePostViewConversions | Integer | Metric |
| viralFollows | Integer | Metric |
| viralFullScreenPlays | Integer | Metric |
| viralImpressions | Integer | Metric |
| viralLandingPageClicks | Integer | Metric |
| viralLikes | Integer | Metric |
| viralOneClickLeadFormOpens | Integer | Metric |
| viralOneClickLeads | Integer | Metric |
| viralOtherEngagements | Integer | Metric |
| viralReactions | Integer | Metric |
| viralShares | Integer | Metric |
| viralTotalEngagements | Integer | Metric |
| viralVideoCompletions | Integer | Metric |
| viralVideoFirstQuartileCompletions | Integer | Metric |
| viralVideoMidpointCompletions | Integer | Metric |
| viralVideoStarts | Integer | Metric |
| viralVideoThirdQuartileCompletions | Integer | Metric |
| viralVideoViews | Integer | Metric |
