ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
LinkedIn Ads Data Dictionary
2
LinkedIn Ads APIAd Analytics
3
Default Panoply Table :linkedin_ads_ad_analytics
4
5
Field NameDescription
6
__senttimePanoply Internal Field
7
__tablenameName of the table the data comes from
8
__updatetimePanoply internal field.
9
accountidThe account ID for the Ad
10
actionclicksThe count of clicks on the action button of the Sponsored InMail. Sponsored InMail only.
11
adunitclicksThe count of clicks on the ad unit displayed alongside the Sponsored InMail. Sponsored InMail only.
12
approximateuniqueimpressionsThe approximate reach of the campaign. The number of instances where a unique user viewed an ad served to them by LinkedIn. This metric is not returned by default. It must be explicitly requested in the projection parameter to be returned.
13
cardclicksNon-demographic pivots only. The number of clicks for each card of a carousel ad. The first card click of the carousel ad results in an immediate cardClick and click, whereas scrolling to other cards and clicking will count as additional cardClick.
14
cardimpressionsNon-demographic pivots only. The number of impressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate cardImpression and impression, whereas scrolling to other cards will count as additional cardImpressions.
15
clicksThe count of chargeable clicks. Despite not charging for clicks for CPM campaigns, this field still represents those clicks for which we would otherwise charge advertisers (for example, clicks to view the landing page or company page).
16
commentlikesThe count of likes of a comment. Sponsored Updates only.
17
comments_countThe count of comments. Sponsored Updates only.
18
companypageclicksThe count of clicks to view the company page.
19
conversionvalueinlocalcurrencyNon-demographic pivots only. Value of the conversions in the account's local currency based on rules defined by the advertiser. Conversion value is set by the advertiser at a per conversion level, and aggregated across the query time range.
20
costinlocalcurrencyCost in the account's local currency based on the pivot and timeGranularity. For example, this would be spend by member company size per month if the pivot is MEMBER_COMPANY_SIZE and timeGranularity is MONTHLY.
21
costinusdCost in USD based on the pivot and timeGranularity. For example, this would be spend by campaign on a given day if the pivot is CAMPAIGN and timeGranularity is DAILY.
22
enddate
23
externalwebsiteconversionsThe count of conversions indicated by pixel loads on an external advertiser website.
24
externalwebsitepostclickconversionsThe count of post-click conversions indicated by pixel loads on an external advertiser website.
25
externalwebsitepostviewconversionsThe count of post-view conversions indicated by pixel loads on an external advertiser website.
26
followsThe count of follows. Sponsored Updates only.
27
fullscreenplaysThe count of taps on the video, going into video view mode.
28
id
29
impressionsThis is the count of "impressions" for Direct Ads and Sponsored Updates and "sends" for InMails.
30
landingpageclicksThe count of clicks which take the user to the creative landing page.
31
leadgenerationmailcontactinfosharesThe number of times users shared contact info through the One Click Lead Gen for Sponsored InMail. Sponsored InMail only.
32
leadgenerationmailinterestedclicksThe count of InMail recipients who clicked to demonstrate interest. Sponsored InMail only.
33
oneclickleadformopensThe count of times users opened the lead form for a One Click Lead Gen campaign.
34
pivot
35
pivot_value_cost_type
36
pivot_value_creative_selection
37
pivot_value_id
38
pivot_value_name
39
pivot_value_objective_name
40
pivot_value_optimization_target_type
41
pivot_value_type
42
pivotvalueThe value of the pivots for a specific record returned. For example, supplying pivots of CREATIVE and CONVERSION results in a list of records, one for each creative/conversion combination. The pivotValues contain serialized URNs for the specific creative and conversion for a record.
43
reactionsThe count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses.
44
sendsThe count of sends of Sponsored InMail. Sponsored InMail only.
45
sharesThe count of shares. Sponsored Updates only.
46
startdate
47
texturlclicksThe count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail. Sponsored InMail only.
48
totalengagementsThe count of all user interactions with the ad unit.
49
videocompletionsThe count of video ads that played 97-100% of the video. This includes watches that skipped to this point if the serving location is ON_SITE.
50
videofirstquartilecompletionsThe count of video ads that played through the first quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE.
51
videomidpointcompletionsThe count of video ads that played through the midpoint of the video. This includes watches that skipped to this point if the serving location is ON_SITE.
52
viralcardclicksNon-demographic pivots only. The number of viralClicks for each card of a carousel ad. The first viralCardClick of the carousel ad results in an immediate viralCardClick and viralClick, whereas scrolling to other cards and clicking will count as additional viralCardClick.
53
viralcardimpressionsNon-demographic pivots only. The number of viralImpressions shown for each card of a carousel ad. The first card of the carousel ad results in an immediate viralCardImpression and viralImpression, whereas scrolling to other cards will count as additional viralCardImpressions
54
viralclicksThe count of clicks on viral impressions. See viral impressions definition. Sponsored Updates only.
55
viralcommentlikesThe count of likes on comments from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
56
viralcommentsThe count of comments from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
57
viralimpressionsThe count of viral impressions for this activity. Viral impressions are those resulting from users sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions. Sponsored Updates only.
58
virallandingpageclicksThe count of clicks on viral impressions to take the user to the creative landing page. See viral impressions definition. Sponsored Updates only.
59
virallikesThe count of likes from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
60
viraloneclickleadformopensThe count of times users opened the lead form for viral impressions from a Lead Gen campaign. See viral impressions definition.
61
viralreactionsThe count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses. See viral impressions definition for details on viral engagements.
62
viralsharesThe count of shares from viral impressions for this activity. See viral impressions definition. Sponsored Updates only.
63
viraltotalengagementsThe count of all user interactions with a viral ad unit. See viral impressions definition. Sponsored Updates only.
64
viralvideocompletionsThe count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point. See viralImpressions definition.
65
viralvideofirstquartilecompletionsThe count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point. See viralImpressions definition.
66
viralvideomidpointcompletionsThe count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point. See viralImpressions definition.
67
viralvideostartsThe count of viral video ads that were started by users. See viralImpressions definition. Since viral videos are automatically played for ON_SITE, this will be the same as viralImpressions if the servingLocation is ON_SITE.
68
viralvideothirdquartilecompletionsThe count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point. See viralImpressions definition
69
viralvideoviewsA viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first. An interaction with the video (like going to full screen mode) does not count as a view. See viralImpressions definition.
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100