LinkedIn Ads data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

accountCurrencyCode
Display name Account currency code
Description The ISO 4217 currency code of the account, such as 'USD' for United States Dollar
Field type dimension
Data type string.currency.code
accountId
Display name Account ID
Description Unique identifier for the advertising account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description A label for the account
Field type dimension
Data type string.text.value
accountTotalBudget
Display name Account total budget
Description Please note that this field will be removed on 2020-10-30
Field type dimension
Data type float.currency.value
campaignCostType
Display name Campaign cost type
Description Cost type, e.g. CPM
Field type dimension
Data type string.text.value
campaignDailyBudget
Display name Campaign daily budget
Description Maximum amount to spend per day
Field type dimension
Data type float.currency.value
campaignEndDate
Display name Campaign end date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaignGroupEndDate
Display name Campaign group end date
Description Represents the inclusive date when to stop running the associated campaigns under this campaign group
Field type dimension
Data type string.time.date
campaignGroupId
Display name Campaign group ID
Description Numerical identifier for the campaign group
Field type dimension
Data type string.text.value
campaignGroupName
Display name Campaign group name
Description The name of the campaign group
Field type dimension
Data type string.text.value
campaignGroupStartDate
Display name Campaign group start date
Description Represents the inclusive date when to start running the associated campaigns under this campaign group
Field type dimension
Data type string.time.date
campaignGroupStatus
Display name Campaign group status
Description Status of the campaign group
Field type dimension
Data type string.text.value
campaignGroupTotalBudget
Display name Campaign group total budget
Description Maximum amount to spend across all associated campaigns and creatives for duration of the campaign group
Field type dimension
Data type float.currency.value
campaignId
Display name Campaign ID
Description Numerical identifier for the campaign
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaignObjectiveType
Display name Campaign objective type
Description Objective type, if available can be used to provide better forecasts
Field type dimension
Data type string.text.value
campaignOptimizationTargetType
Display name Campaign optimization target type
Description Determines how this campaign is optimized for spending
Field type dimension
Data type string.text.value
campaignStartDate
Display name Campaign start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
campaignStatus
Display name Campaign status
Description Status of campaign
Field type dimension
Data type string.text.value
campaignTotalBudget
Display name Campaign total budget
Description Maximum amount to spend over the life of the Campaign
Field type dimension
Data type float.currency.value
campaignType
Display name Campaign type
Description Type of campaign, e.g. TEXT_AD
Field type dimension
Data type string.text.value
campaignUnitCost
Display name Campaign unit cost
Description Amount to bid per click, impression, or other event depending on the pricing model
Field type dimension
Data type float.currency.value
clicks
Display name Clicks
Description Count of chargeable clicks
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description The count of conversions indicated by pixel loads
Field type metric
Data type int.number.value
conversionValue
Display name Total conversion value
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description Count of 'impressions' for Direct Ads and Sponsored Updates and 'sends' for InMails
Field type metric
Data type int.number.value
oneClickLeadFormOpens
Display name Lead form opens
Description The count of times users opened the lead form for a One Click Lead Gen campaign
Field type metric
Data type int.number.value
oneClickLeads
Display name Leads
Description The count of leads generated through One Click Lead Gen
Field type metric
Data type int.number.value
oneClickLeadsCost
Display name Cost per lead
Description Cost per One Click Lead
Field type metric
Data type float.currency.value
spend
Display name Total spent
Description Campaign cost in the currency of the advertising account
Field type metric
Data type float.currency.value
spend_eur
Display name Total spent (EUR)
Description Campaign cost converted to euros
Field type metric
Data type float.currency.value
spend_gbp
Display name Total spent (GBP)
Description Campaign cost converted to British pounds
Field type metric
Data type float.currency.value
spend_usd
Display name Total spent (USD)
Description Campaign cost converted to US dollars
Field type metric
Data type float.currency.value
viralOneClickLeadFormOpens
Display name Viral form opens
Description The count of times users opened the lead form for viral impressions from a Lead Gen campaign
Field type metric
Data type int.number.value
viralOneClickLeads
Display name Viral leads
Description The count of leads generated through One Click Lead Gen from viral impressions for this activity
Field type metric
Data type int.number.value

Table: AD

accountCurrencyCode
Display name Account currency code
Description The ISO 4217 currency code of the account, such as 'USD' for United States Dollar
Field type dimension
Data type string.currency.code
accountId
Display name Account ID
Description Unique identifier for the advertising account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description A label for the account
Field type dimension
Data type string.text.value
campaignGroupEndDate
Display name Campaign group end date
Description Represents the inclusive date when to stop running the associated campaigns under this campaign group
Field type dimension
Data type string.time.date
campaignGroupId
Display name Campaign group ID
Description Numerical identifier for the campaign group
Field type dimension
Data type string.text.value
campaignGroupName
Display name Campaign group name
Description The name of the campaign group
Field type dimension
Data type string.text.value
campaignId
Display name Campaign ID
Description Numerical identifier for the campaign
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description Count of chargeable clicks
Field type metric
Data type int.number.value
comments
Display name Comments
Description The count of comments. Sponsored Updates only
Field type metric
Data type int.number.value
companyPageClicks
Display name Company page clicks
Description The count of clicks to view the company page
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description The count of conversions indicated by pixel loads
Field type metric
Data type int.number.value
conversionValue
Display name Total conversion value
Field type metric
Data type float.currency.value
creativeDscName
Display name Creative Direct Sponsored Content name
Description Indicate whether the creative is a direct sponsored content or not
Field type dimension
Data type string.text.value
creativeId
Display name Creative ID
Description Unique numerical identifier for the ad creative
Field type dimension
Data type string.text.value
creativeReferenceId
Display name Creative reference ID
Field type dimension
Data type string.text.value
creativeReferenceType
Display name Creative reference type
Field type dimension
Data type string.text.value
creativeStatus
Display name Creative status
Description Status of the creative
Field type dimension
Data type string.text.value
creativeText
Display name Creative text
Description Body text of the creative
Field type dimension
Data type string.text.value
creativeTitle
Display name Creative title
Description Title of the creative
Field type dimension
Data type string.text.value
creativeType
Display name Creative type
Description Type of the creative, e.g. TEXT_AD
Field type dimension
Data type string.text.value
creativeUrl
Display name Creative destination URL
Description Destination URL of the creative
Field type dimension
Data type string.text.url
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
follows
Display name Follows
Description The count of follows. Sponsored Updates only
Field type metric
Data type int.number.value
impressions
Display name Impressions
Description Count of 'impressions' for Direct Ads and Sponsored Updates and 'sends' for InMails
Field type metric
Data type int.number.value
landingPageClicks
Display name Landing page clicks
Description The count of clicks which take the user to the creative landing page
Field type metric
Data type int.number.value
likes
Display name Likes
Description The count of likes. Sponsored Updates only
Field type metric
Data type int.number.value
oneClickLeadFormOpens
Display name Lead form opens
Description The count of times users opened the lead form for a One Click Lead Gen campaign
Field type metric
Data type int.number.value
oneClickLeads
Display name Leads
Description The count of leads generated through One Click Lead Gen
Field type metric
Data type int.number.value
oneClickLeadsCost
Display name Cost per lead
Description Cost per One Click Lead
Field type metric
Data type float.currency.value
otherEngagements
Display name Other engagements
Description The count of user interactions with the ad unit that do not fit into any other more specific category
Field type metric
Data type int.number.value
postClickConversions
Display name Post-click conversions
Description The count of post-click conversions indicated by pixel loads
Field type metric
Data type int.number.value
shares
Display name Shares
Description The count of shares. Sponsored Updates only
Field type metric
Data type int.number.value
spend
Display name Total spent
Description Campaign cost in the currency of the advertising account
Field type metric
Data type float.currency.value
spend_eur
Display name Total spent (EUR)
Description Campaign cost converted to euros
Field type metric
Data type float.currency.value
spend_gbp
Display name Total spent (GBP)
Description Campaign cost converted to British pounds
Field type metric
Data type float.currency.value
spend_usd
Display name Total spent (USD)
Description Campaign cost converted to US dollars
Field type metric
Data type float.currency.value
totalEngagements
Display name Total engagements
Field type metric
Data type int.number.value
utm_campaign
Display name Campaign (utm)
Description Value of the utm_campaign parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_content
Display name Content (utm)
Description Value of the utm_content parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_medium
Display name Medium (utm)
Description Value of the utm_medium parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_source
Display name Source (utm)
Description Value of the utm_source parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
utm_term
Display name Term (utm)
Description Value of the utm_term parameter extracted from the ad destination URL
Field type dimension
Data type string.text.value
videoCompletions
Display name Video completions
Description The 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
Field type metric
Data type int.number.value
videoFirstQuartileCompletions
Display name Video views at 25%
Description The 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
Field type metric
Data type int.number.value
videoMidpointCompletions
Display name Video views at 50%
Description The count of video ads that played through the midpoint of the video. This includes watches that skippped to this point if the serving location is ON_SITE
Field type metric
Data type int.number.value
videoThirdQuartileCompletions
Display name Video views at 75%
Description The count of video ads that played through the third quartile of the video. This includes watches that skipped to this point if the serving location is ON_SITE
Field type metric
Data type int.number.value
videoViews
Display name Video views
Description A 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 fullscreen mode) does not count as a view
Field type metric
Data type int.number.value
viewThroughConversions
Display name View-through conversions
Description The count of view conversions indicated by pixel loads
Field type metric
Data type int.number.value
viralClicks
Display name Viral clicks
Description The count of clicks on viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralComments
Display name Viral comments
Description The count of comments from viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralCompanyPageClicks
Display name Viral company page clicks
Description The count of clicks to view the company page from viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralFollows
Display name Viral follows
Description The count of follows from viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralImpressions
Display name Viral impressions
Description Viral impressions are those resulting from a user sharing a sponsored update to their own network of connections. Viral impressions are not counted as regular impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralLandingPageClicks
Display name Viral landing page clicks
Description The count of viral impressions to take the user to the creative landing page. Sponsored Updates only
Field type metric
Data type int.number.value
viralLikes
Display name Viral likes
Description The count of likes from viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralOneClickLeadFormOpens
Display name Viral form opens
Description The count of times users opened the lead form for viral impressions from a Lead Gen campaign
Field type metric
Data type int.number.value
viralOneClickLeads
Display name Viral leads
Description The count of leads generated through One Click Lead Gen from viral impressions for this activity
Field type metric
Data type int.number.value
viralOtherEngagements
Display name Viral other engagements
Field type metric
Data type int.number.value
viralShares
Display name Viral shares
Description The count of shares from viral impressions. Sponsored Updates only
Field type metric
Data type int.number.value
viralTotalEngagements
Display name Viral total engagements
Field type metric
Data type int.number.value

Table: INMAIL

accountId
Display name Account ID
Description Unique identifier for the advertising account
Field type dimension
Data type string.text.value
accountName
Display name Account name
Description A label for the account
Field type dimension
Data type string.text.value
actionClicks
Display name Action clicks
Description The count of clicks on the action button of the Sponsored InMail
Field type metric
Data type int.number.value
adUnitClicks
Display name Ad unit clicks
Description The count of clicks on the ad unit displayed alongside the Sponsored InMail
Field type metric
Data type int.number.value
campaignId
Display name Campaign ID
Description Numerical identifier for the campaign
Field type dimension
Data type string.text.value
campaignName
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
leadGenerationMailContactInfoShares
Display name Lead generation mail contact info shares
Description The number of times a user shared contact info through the One Click Leadgen for Sponsored InMail
Field type metric
Data type int.number.value
leadGenerationMailInterestedClicks
Display name Lead generation mail interested clicks
Description The count of InMail recipients showing interest
Field type metric
Data type int.number.value
opens
Display name Opens
Description The count of opens of Sponsored InMail
Field type metric
Data type int.number.value
sends
Display name Sends
Description The count of sends in Sponsored InMail
Field type metric
Data type int.number.value
textUrlClicks
Display name Text URL clicks
Description The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail
Field type metric
Data type int.number.value