 4 Minutes to read

Print

DarkLight

PDF
LinkedIn Ads Predefined Reports
 4 Minutes to read

Print

DarkLight

PDF
Predefined Reports
The LinkedIn Ads datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.
SourceLevel Selections
LinkedIn Ad's one sourcelevel selection is an Accounts filter. Choosing distinct values will filter down each report within the river to only the selected accounts' data.
Accounts
The Accounts report pulls a list of accounts and their attributes. The user can customize the report by selecting an Accounts Status in the reportlevel 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. The user can customize the report by selecting a Campaigns Status in the reportlevel 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 see status, budget, and performance across multiple related campaigns. The user can customize the report by selecting a Campaigns Status in the reportlevel 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. The user can customize the report by 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 
pivot  String  Dimension 
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 
pivot  String  Dimension 
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 