Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| ACCOUNT | Account name | accountName | dim | A label for the account |
| Account ID | accountId | dim | Unique identifier for the advertising account | |
| Account currency code | accountCurrencyCode | dim | The ISO 4217 currency code of the account, such as 'USD' for United States Dollar | |
| AD FORM RESPONSES | Ad form response ID | adFormResponseId | dim | ID of ad form response |
| Ad form response test lead | adFormResponseTestLead | dim | Test lead of ad form response | |
| Ad form response submission time | adFormResponseSubmittedAt | dim | Submission time of ad form response | |
| Ad form response lead type | adFormResponseLeadType | dim | Lead type of ad form response | |
| Ad form response answer | adFormResponseAnswerText | dim | Answer of a question field from ad form | |
| Ad form consent answer | adFormConsentAnswer | dim | Answer of a consent from ad form | |
| AD FORM | Ad form name | adformName | dim | Name of ad form |
| Ad form ID | adformId | dim | ID of ad form | |
| Ad form status | adformStatus | dim | Status of ad form | |
| Ad form description | adformDescription | dim | Description of ad form | |
| Ad form headline | adformHeadline | dim | Headline text of ad form | |
| Ad form landing page | adformLandingPage | dim | Landing page URL of ad form | |
| Ad form legal disclaimer | adformLegalDisclaimer | dim | Legal disclaimer text of ad form | |
| Ad form privacy policy | adformPrivacyPolicy | dim | Privacy policy URL of ad form | |
| Ad form version tag | adformVersionTag | dim | Version tag of ad form | |
| Ad form question name | adformQuestionName | dim | Name of a question field from ad form | |
| Ad form question ID | adformQuestionId | dim | ID of a question from ad form | |
| Ad form question field | adformQuestionField | dim | Field ID of a question from ad form | |
| Ad form question placeholder | adformQuestionPlaceholder | dim | Placeholder text of a question field from ad form | |
| Ad form question text | adformQuestionText | dim | Question text of a question from ad form | |
| Ad form consent text | adFormConsentText | dim | Question text of a question from ad form | |
| Ad form hidden field name | adFormHiddenFieldName | dim | Name of a hidden field from ad form | |
| Ad form hidden field value | adFormHiddenFieldValue | dim | Value of a hidden field from ad form | |
| CAMPAIGN GROUP | Campaign group name | campaignGroupName | dim | The name of the campaign group |
| Campaign group ID | campaignGroupId | dim | Numerical identifier for the campaign group | |
| Campaign group status | campaignGroupStatus | dim | Status of the campaign group | |
| Campaign group total budget | campaignGroupTotalBudget | dim | Maximum amount to spend across all associated campaigns and creatives for duration of the campaign group | |
| Campaign group start date | campaignGroupStartDate | dim | Represents the inclusive date when to start running the associated campaigns under this campaign group | |
| Campaign group end date | campaignGroupEndDate | dim | Represents the inclusive date when to stop running the associated campaigns under this campaign group | |
| CAMPAIGN | Campaign name | campaignName | dim | The name of the campaign |
| Campaign ID | campaignId | dim | Numerical identifier for the campaign | |
| Campaign created date | campaignCreated | dim | Creation date of the campaign | |
| Campaign status | campaignStatus | dim | Status of campaign | |
| Campaign type | campaignType | dim | Type of campaign, e.g. TEXT_AD | |
| Campaign objective type | campaignObjectiveType | dim | Objective type, if available can be used to provide better forecasts | |
| Campaign optimization target type | campaignOptimizationTargetType | dim | Determines how this campaign is optimized for spending | |
| Campaign cost type | campaignCostType | dim | Cost type, e.g. CPM | |
| Campaign daily budget | campaignDailyBudget | dim | Maximum amount to spend per day | |
| Campaign total budget | campaignTotalBudget | dim | Maximum amount to spend over the life of the Campaign | |
| Campaign unit cost | campaignUnitCost | dim | Amount to bid per click, impression, or other event depending on the pricing model | |
| Campaign start date | campaignStartDate | dim | Start date of the campaign | |
| Campaign end date | campaignEndDate | dim | End date of the campaign | |
| CREATIVE | Creative ID | creativeId | dim | Unique numerical identifier for the ad creative |
| Creative status | creativeStatus | dim | Status of the creative | |
| Creative type | creativeType | dim | Type of the creative, e.g. TEXT_AD | |
| Creative Direct Sponsored Content name | creativeDscName | dim | Indicate whether the creative is a direct sponsored content or not | |
| Creative title | creativeTitle | dim | Title of the creative | |
| Creative text | creativeText | dim | Body text of the creative | |
| Creative destination URL | creativeUrl | dim | Destination URL of the creative | |
| Creative thumbnail URL | creativeThumbnailUrl | dim | Thumbnail URL of the creative | |
| Creative thumbnail | creativeThumbnailImage | dim | Thumbnail of the creative | |
| Creative reference type | creativeReferenceType | dim | ||
| Creative reference ID | creativeReferenceId | dim | ||
| Carousel card index | creativeCardIndex | dim | Creative ad carousel card position | |
| CONVERSION | Conversion ID | conversionId | dim | Conversion ID |
| Conversion name | conversionName | dim | A short name for this rule, which will be shown in the UI and in reports | |
| Conversion type | conversionType | dim | The type of the rule | |
| Conversion enabled | conversionEnabled | dim | Is the conversion enabled | |
| Conversion value | conversionValueAmount | dim | The monetary value for this conversion | |
| Conversion currency | conversionValueCurrency | dim | Identifying code for currency type | |
| Insight tag domain ID | insightTagsDomainId | dim | Association between the website domain(s) and an advertiser account | |
| Insight tag domain | insightTagsDomainName | dim | The domain name for the insight tag | |
| DEMOGRAPHICS | Member company size | memberCompanySize | dim | Approximate company size of LinkedIn members engaged with campaigns |
| Member industry | memberIndustry | dim | Industry of LinkedIn members engaged with campaigns | |
| Member seniority | memberSeniority | dim | Seniority of LinkedIn members engaged with campaigns | |
| Member job title | memberJobTitle | dim | Job titles of LinkedIn members engaged with campaigns | |
| Member job function | memberJobFunction | dim | Job funnctions of of LinkedIn members engaged with campaigns | |
| Member country | memberCountry | dim | Countries of LinkedIn members engaged with campaigns | |
| Member country code | memberCountryCode | dim | Country codes of LinkedIn members engaged with campaigns | |
| Member region | memberRegion | dim | Geographic regions of LinkedIn members engaged with campaigns | |
| Member company name | memberCompanyName | dim | Company names of of LinkedIn members engaged with campaigns | |
| SERVING LOCATION | Serving location | servingLocation | dim | Breaks down the data based on if it was shown On LinkedIn or in the Audience Network |
| DEPRECATED | Creative ad preview URL | creativeAdPreviewUrl | dim | A URL that renders a preview of what a share would look like as a Sponsored Content Ad Creative. This only supports sponsored status updates and sponsored carousel updates. Please note that this field will be removed on 2023-02-21 |
| Account total budget | accountTotalBudget | dim | Please note that this field will be removed on 2020-10-30 | |
| PERFORMANCE | Reach | approximateUniqueImpressions | met | The approximate reach of the campaign |
| Impressions | impressions | met | Count of 'impressions' for Direct Ads and Sponsored Updates and 'sends' for InMails | |
| Clicks | clicks | met | Count of chargeable clicks | |
| CTR (%) | ctr_perc | met | Click-through rate | |
| Company page clicks | companyPageClicks | met | The count of clicks to view the company page | |
| Landing page clicks | landingPageClicks | met | The count of clicks which take the user to the creative landing page | |
| Other engagements | otherEngagements | met | The count of user interactions with the ad unit that do not fit into any other more specific category | |
| Total social actions | totalSocialActions | met | Likes, comments, shares, follows and other engagements | |
| Total engagements | totalEngagements | met | ||
| Engagement rate | engagementRate | met | Total engagements divided by impressions | |
| CPC | cpc | met | Cost per click | |
| CPM | cpm | met | Cost per 1000 impressions | |
| Total spent | spend | met | Campaign cost in the currency of the advertising account | |
| Total spent (EUR) | spend_eur | met | Campaign cost converted to euros | |
| Total spent (GBP) | spend_gbp | met | Campaign cost converted to British pounds | |
| Total spent (USD) | spend_usd | met | Campaign cost converted to US dollars | |
| SOCIAL ACTIONS | Likes | likes | met | The count of likes. Sponsored Updates only |
| Comments | comments | met | The count of comments. Sponsored Updates only | |
| Shares | shares | met | The count of shares. Sponsored Updates only | |
| Reactions | reactions | met | The count of positive reactions on Sponsored Updates which can capture, like, interest, praise, and other responses | |
| Follows | follows | met | The count of follows. Sponsored Updates only | |
| Viral clicks | viralClicks | met | The count of clicks on viral impressions. Sponsored Updates only | |
| Viral impressions | viralImpressions | met | 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 | |
| Viral likes | viralLikes | met | The count of likes from viral impressions. Sponsored Updates only | |
| Viral comments | viralComments | met | The count of comments from viral impressions. Sponsored Updates only | |
| Viral shares | viralShares | met | The count of shares from viral impressions. Sponsored Updates only | |
| Viral follows | viralFollows | met | The count of follows from viral impressions. Sponsored Updates only | |
| Viral company page clicks | viralCompanyPageClicks | met | The count of clicks to view the company page from viral impressions. Sponsored Updates only | |
| Viral landing page clicks | viralLandingPageClicks | met | The count of viral impressions to take the user to the creative landing page. Sponsored Updates only | |
| Viral other engagements | viralOtherEngagements | met | ||
| Viral total engagements | viralTotalEngagements | met | ||
| Viral external website conversions | viralExternalWebsiteConversions | met | The count of conversions indicated by pixel loads on an external advertiser website driven by a viral event | |
| Viral external website post click conversion | viralExternalWebsitePostClickConversions | met | The count of post-click conversions indicated by pixel loads on an external advertiser website driven by a viral click | |
| Viral external website post view conversions | viralExternalWebsitePostViewConversions | met | The count of post-view conversions indicated by pixel loads on an external advertiser website driven by a viral impression | |
| Viral full screen plays | viralFullScreenPlays | met | The count of taps on the video, going into video view mode | |
| Viral reactions | viralReactions | met | The count of positive reactions on viral Sponsored Updates which can capture like, interest, praise, and other responses | |
| SPONSORED INMAIL | Opens | opens | met | The count of opens of Sponsored InMail |
| Sends | sends | met | The count of sends in Sponsored InMail | |
| Text URL clicks | textUrlClicks | met | The count of clicks on any links (anchor tags) that were included in the body of the Sponsored InMail | |
| Action clicks | actionClicks | met | The count of clicks on the action button of the Sponsored InMail | |
| Ad unit clicks | adUnitClicks | met | The count of clicks on the ad unit displayed alongside the Sponsored InMail | |
| Lead generation mail contact info shares | leadGenerationMailContactInfoShares | met | The number of times a user shared contact info through the One Click Leadgen for Sponsored InMail | |
| Lead generation mail interested clicks | leadGenerationMailInterestedClicks | met | The count of InMail recipients showing interest | |
| ONE CLICK LEAD GEN CAMPAIGNS | Leads | oneClickLeads | met | The count of leads generated through One Click Lead Gen |
| Lead form opens | oneClickLeadFormOpens | met | The count of times users opened the lead form for a One Click Lead Gen campaign | |
| Viral leads | viralOneClickLeads | met | The count of leads generated through One Click Lead Gen from viral impressions for this activity | |
| Viral form opens | viralOneClickLeadFormOpens | met | The count of times users opened the lead form for viral impressions from a Lead Gen campaign | |
| Cost per lead | oneClickLeadsCost | met | Cost per One Click Lead | |
| Lead form completion rate (%) | leadFormCompletionRate_perc | met | The lead form completion rate is the number of leads divided by the number of lead form opens | |
| CONVERSIONS | Conversions | conversions | met | The count of conversions indicated by pixel loads |
| Post-click conversions | postClickConversions | met | The count of post-click conversions indicated by pixel loads | |
| View-through conversions | viewThroughConversions | met | The count of view conversions indicated by pixel loads | |
| Conversion rate (%) | conversionRate_perc | met | ||
| Cost per conversion | conversionCost | met | ||
| Total conversion value | conversionValue | met | ||
| Return on ad spend | returnOnSpend | met | ||
| VIDEO | Video views at 25% | videoFirstQuartileCompletions | met | 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 |
| Video views at 50% | videoMidpointCompletions | met | 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 | |
| Video views at 75% | videoThirdQuartileCompletions | met | 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 | |
| Video views | videoViews | met | 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 | |
| Video completions | videoCompletions | met | 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 | |
| Viral video starts | viralVideoStarts | met | The count of viral video ads that were started by users | |
| Viral video completions | viralVideoCompletions | met | The count of viral video ads that played 97-100% of the video. This includes watches that skipped to this point | |
| Viral video views at 25% | viralVideoFirstQuartileCompletions | met | The count of viral video ads that played through the first quartile of the video. This includes watches that skipped to this point | |
| Viral video views at 50% | viralVideoMidpointCompletions | met | The count of viral video ads that played through the midpoint of the video. This includes watches that skipped to this point | |
| Viral video views at 75% | viralVideoThirdQuartileCompletions | met | The count of viral video ads that played through the third quartile of the video. This includes watches that skipped to this point | |
| Full screen plays | fullScreenPlays | met | Number of times members click on the full screen button or on the video(mobile only) to go into full screen mode | |
| Video starts | videoStarts | met | The count of video ads that were started by users | |
| Viral video views | viralVideoViews | met | A viral video ad playing for at least 2 continuous seconds 50% in-view, or a click on the CTA, whichever comes first | |
| DOWNLOADS | Download clicks | downloadClicks | met | The number of times users have indicated the intent to download the media in an ad by clicking the download icon. This metric is only available for ad formats supporting media downloads |
| Viral download clicks | viralDownloadClicks | met | The number of times users have indicated the intent to download the media in a viral ad by clicking the download icon. Only available for ads supporting media downloads | |
| Document first quartile completions | documentFirstQuartileCompletions | met | The number of times users reached the first quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions | |
| Document midpoint completions | documentMidpointCompletions | met | The number of times users reached the second quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions | |
| Document third quartile completions | documentThirdQuartileCompletions | met | The number of times users reached the third quartile of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions | |
| Document completions | documentCompletions | met | The number of times users reached 100% of the document’s length, including those that skipped to this point. This metric is only available for document ads and not all dimensions | |
| Viral document first quartile completions | viralDocumentFirstQuartileCompletions | met | The number of times users reached the first quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads | |
| Viral document midpoint completions | viralDocumentMidpointCompletions | met | The number of times users reached the second quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads | |
| Viral document third quartile completions | viralDocumentThirdQuartileCompletions | met | The number of times users reached the third quartile of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads | |
| Viral document completions | viralDocumentCompletions | met | The number of times users reached 100% of the document’s length on a viral post, including those that skipped to this point. This metric is only available for document ads | |
| DEPRECATED | Reach 7 day | approximateReach7Day | met | The average of unique member accounts with at least one impression over the last 7 days. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 7 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 |
| Frequency 7 day | approximateFrequency7Day | met | The average of impressions shown to each member account that received at least one impression over the last 7 days. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 7 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Frequency 1 day | approximateFrequencyDaily | met | The average of impressions shown to each member account that received at least one impression. If the date range has more than one day, these metrics are the average for each day in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Cost per reach 1 day | approximateCostPerReachDaily | met | The average of spend (in the ad account currency) on your ads, divided by member accounts reached, multiplied by 1000. If the date range has more than one day, these metrics are the average for each day in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Frequency 30 day | approximateFrequency30Day | met | The average of impressions shown to each member account that received at least one impression over the last 30 days. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 30 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Cost per reach 7 day | approximateCostPerReach7Day | met | The last 7 days of average of spend (in the ad account currency) on your ads, divided by member accounts reached, multiplied by 1000. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 7 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Cost per reach 30 day | approximateCostPerReach30Day | met | The last 30 days of average of spend (in the ad account currency) on your ads, divided by member accounts reached, multiplied by 1000. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 30 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Reach 1 day | approximateReachDaily | met | The daily reach or unique member accounts with at least one impression. If the date range has more than one day, these metrics are the average for each day in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 | |
| Reach 30 day | approximateReach30Day | met | The average of unique member accounts with at least one impression over the last 30 days. If the date range has more than one day, these metrics are the average of multiple reach metrics for each previous 30 day interval in the date range. Only compatible with Campaign level data. Please note that this field will be removed on 2022-10-31 |