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 & month | Yearmonth | dim | Year and month, e.g. 2017|06 | |
| Year & week (Sun-Sat) | yearweek | dim | Year and week for US weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearweekiso | dim | Year and week for ISO weeks, e.g. 2017|08 | |
| Month | Month | dim | Month, e.g. 6 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekiso | dim | ISO week number, e.g. 51 | |
| Week (Mon-Sun, dates) | yearweekiso_daterange | dim | ||
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (numeric) | dayOfWeekNumeric | dim | Day of week for ISO weeks, e.g. "1" for Monday and "7" for Sunday | |
| Day of week (name) | dayOfWeekName | dim | Day of week for ISO weeks with names, e.g. "1 - Monday" or "7 - Sunday" | |
| Date | Date | dim | Date, e.g. 2017-01-31 | |
| ACCOUNT | Account | account | dim | Engine account name |
| Account ID | accountId | dim | DS engine account ID | |
| Engine ID | accountEngineId | dim | ID of the account in the external engine account | |
| Account type | accountType | dim | Engine account type: Google AdWords, Microsoft Advertising, Yahoo Japan Listing Ads, Yahoo Search Marketing, Yahoo Native Ads, Baidu, or Comparison Shopping | |
| Agency | agency | dim | Agency name | |
| Agency ID | agencyId | dim | DS agency ID | |
| Advertiser | advertiser | dim | Advertiser name | |
| Advertiser ID | advertiserId | dim | DS advertiser ID | |
| Currency | accountCurrencyCode | dim | Currency code of the engine account in ISO 4217 format | |
| Time zone | accountTimeZone | dim | Time zone of the engine account in IANA Time Zone Database format, such as America/New_York | |
| Status | status | dim | The status of the account: Active, Paused, or Removed | |
| Site link display text | siteLinkDisplayText | dim | ||
| Site link Description 1 | sitelinkDescription1 | dim | ||
| Site link Description 2 | sitelinkDescription2 | dim | ||
| Site link landing page URL | sitelinkLandingPageUrl | dim | ||
| Site link click server URL | sitelinkClickserverUrl | dim | ||
| Location business name | locationBusinessName | dim | ||
| ID-MAP | Agency ID (Old) | oldAgencyId | dim | Agency ID (Old) |
| Manager account ID (New) | newManagerAccountId | dim | Manager account ID (New) | |
| Advertiser ID (Old) | oldAdvertiserId | dim | Advertiser ID (Old) | |
| Sub Manager Account ID (New) | newSubManagerAccountId | dim | Sub Manager Account ID (New) | |
| Engine ID (Old) | oldEngineId | dim | Engine ID (Old) | |
| Client Account ID (New) | newClientAccountId | dim | Client Account ID (New) | |
| Campaign ID (Old) | oldCampaignId | dim | Campaign ID (Old) | |
| SA360 Campaign ID (New) | newCampaignId | dim | SA360 Campaign ID (New) | |
| Campaign target ID (Old) | oldCampaignTargetId | dim | Campaign target ID (Old) | |
| SA360 Campaign criterion ID (New) | newCampaignCriterionId | dim | SA360 Campaign criterion ID (New) | |
| Adgroup ID (Old) | oldAdGroupId | dim | Adgroup ID (Old) | |
| SA360 Adgroup ID (New) | newAdGroupId | dim | SA360 Adgroup ID (New) | |
| Ad ID (Old) | oldAdId | dim | Ad ID (Old) | |
| SA360 Ad ID (New) | newAdId | dim | SA360 Ad ID (New) | |
| Entity type | entityType | dim | Entity type | |
| CAMPAIGN | Campaign | campaign | dim | Campaign name |
| Campaign ID | campaignId | dim | DS campaign ID | |
| Campaign Status | campaignStatus | dim | The status of the campaign: Active, Paused, or Removed | |
| Campaign type | campaignType | dim | Indicates the type of campaign: Manual, Inventory, Inventory - PLA, Shopping, Comparison shopping, Mobile app install, or Universal app | |
| Engine ID | campaignEngineId | dim | ID of the campaign in the external engine account | |
| Daily budget | dailyBudget | dim | Daily budget of the campaign | |
| Monthly budget | monthlyBudget | dim | Monthly budget of the campaign | |
| Delivery method | deliveryMethod | dim | Budget delivery method of the campaign: Standard or Accelerated | |
| Ad rotation | adRotation | dim | Ad serving rotation used by the ad group: Optimize or Rotate indefinitely | |
| Labels | campaignLabels | dim | Names of labels directly assigned to this campaign; inherited labels are not included | |
| Start date | campaignStartDate | dim | Start date of the campaign | |
| End date | campaignEndDate | dim | End date of the campaign | |
| AD GROUP | Ad group | adGroup | dim | Ad group name |
| Ad group ID | adGroupId | dim | DS ad group ID | |
| Ad group status | adGroupStatus | dim | The status of the ad group: Active, Paused, or Removed | |
| Ad group labels | adGroupLabels | dim | Names of labels directly assigned to this ad group; inherited labels are not included | |
| Engine ID | adGroupEngineId | dim | ID of the ad group in the external engine account | |
| Start date | adGroupStartDate | dim | Start date of the ad group | |
| End date | adGroupEndDate | dim | End date of the ad group | |
| Search max CPC | adGroupSearchMaxCpc | dim | Default bid for search keywords in this ad group | |
| Broad max CPC | adGroupBroadMaxCpc | dim | Default bid for broad match search keywords in this ad group (Microsoft Advertising only) | |
| Exact max CPC | adGroupExactMaxCpc | dim | Default bid for exact match keywords in this ad group (Microsoft Advertising only) | |
| Phrase max CPC | adGroupPhraseMaxCpc | dim | Default bid for phrasematch search keywords in this ad group (Microsoft Advertising only) | |
| Content max CPC | adGroupContentMaxCpc | dim | Default bid for content keywords in this ad group | |
| Mobile bid adjustment | adGroupMobileBidAdjustment | dim | The percentage by which bids are adjusted for mobile. For example, 0.2 means 20% increase, so mobile bids are 1.2 times the default bid. The range of valid values differs based on the external engine | |
| AD | Ad | ad | dim | Ad name |
| Ad ID | adId | dim | DS ad ID. A value of 0 indicates that the ad is unattributed | |
| Ad status | adStatus | dim | The status of the ad: Active, Paused, or Removed. Note that campaigns, ad groups, keywords, and ads each have their own status. See status | |
| Ad engine ID | adEngineId | dim | ID of the ad in the external engine account | |
| Ad engine status | adEngineStatus | dim | Additional status of the ad in the external engine account. Possible statuses (depending on the type of external account) include active, eligible, creative deleted, creative approved family safe, etc | |
| Ad headline | adHeadline | dim | Ad headline | |
| Ad headline 2 | adHeadline2 | dim | Ad headline 2; not available for some engines | |
| Ad labels | adLabels | dim | Names of labels directly assigned to this ad; inherited labels are not included | |
| Ad description 1 | adDescription1 | dim | Ad description line 1 | |
| Ad description 2 | adDescription2 | dim | Ad description line 2; not available for some engines | |
| Ad path field 1 | adPathField1 | dim | Ad path field 1. Path fields 1 and 2 are combined with ad display URL to form the URL that is shown on an ad | |
| Ad path field 2 | adPathField2 | dim | Ad path field 2. Path fields 1 and 2 are combined with ad display URL to form the URL that is shown on an ad | |
| Ad display URL | adDisplayUrl | dim | Ad display URL | |
| Ad landing page | adLandingPage | dim | Ad landing page. See Landing page and clickserver URLs | |
| Ad type | adType | dim | The type of ad: Text, Product, Dynamic search, Mobile app install, Call-Only, Expanded text, or Expanded dynamic search | |
| Ad promotion line | adPromotionLine | dim | Ad promotion line. A short promotional message for a product ad | |
| KEYWORD | Keyword | keywordText | dim | Keyword text |
| Keyword ID | keywordId | dim | DS keyword ID. A value of 0 indicates that the keyword is unattributed | |
| Keyword status | keywordStatus | dim | The status of the keyword: Active, Paused, or Removed. Note that campaigns, ad groups, keywords, and ads each have their own status. See status | |
| Keyword engine ID | keywordEngineId | dim | ID of the keyword in the external engine account | |
| Keyword engine status | keywordEngineStatus | dim | Additional status of the keyword in the external engine account. Possible statuses (depending on the type of external account) include criterion rarely served, criterion below first page bid, criterion low quality score, review, campaign paused, etc | |
| Match type | keywordMatchType | dim | Keyword match type: Broad, Exact, Phrase, or Content | |
| Max CPC | keywordMaxCpc | dim | Overrides the ad group's max CPC and sets a maximum amount you are willing to pay if someone clicks an ad for this specific keyword. If this field is empty, the keyword will use the ad group's max CPC | |
| Max CPC (effective) | effectiveKeywordMaxCpc | dim | The max CPC (maximum cost-per-click) that is in effect for this keyword. This will be either the same value as the ad group's max CPC or, if the keyword is overriding the ad group's setting, the keyword's own max CPC | |
| Max bid | keywordMaxBid | dim | If this keyword is managed by a DS bid strategy, the bid strategy will never raise bids above this limit | |
| Min bid | keywordMinBid | dim | If this keyword is managed by a DS bid strategy, the bid strategy will never lower bids below this limit | |
| Labels | keywordLabels | dim | Names of labels directly assigned to this keyword; inherited labels are not included | |
| Landing page | keywordLandingPage | dim | The final URL that a user would visit after clicking on your ad. See Landing page and clickserver URLs | |
| Is display? | isDisplayKeyword | dim | Indicates whether this is a placeholder keyword that is used for display and placement reporting | |
| Click server URL | keywordClickserverUrl | dim | The URL that DS uses to track activity. A user who clicks an ad would visit the clickserver URL first, and then be redirected to the final landing page | |
| SEARCH | Search query | searchQuery | dim | |
| Click type | serpType | dim | The type of search result that Google users clicked | |
| FLOODLIGHT | Floodlight activity | floodlightActivity | dim | Floodlight activity name |
| Floodlight activity ID | floodlightActivityId | dim | DS Floodlight activity ID | |
| Floodlight activity tag | floodlightActivityTag | dim | Floodlight activity tag | |
| Floodlight group | floodlightGroup | dim | Floodlight group name | |
| Type of conversions generated by Floodlight activities | floodlightGroupConversionType | dim | The type of conversions generated by Floodlight activities in this group: Action or Transaction | |
| Floodlight group ID | floodlightGroupId | dim | DS Floodlight group ID | |
| Floodlight group tag | floodlightGroupTag | dim | Floodlight group tag | |
| TARGETING | Country | countryTargets | dim | Country targets included in the campaign |
| Province | provinceTargets | dim | Province targets included in the campaign | |
| Metro | metroTargets | dim | Metro targets included in the campaign | |
| City | cityTargets | dim | City targets included in the campaign | |
| Device | deviceSegment | dim | Segments the report by device; each row and its aggregate metrics are split into multiple rows, up to one for each device segment | |
| Device targets | deviceTargetsApi | dim | Device targets at the campaign level; a combination of Desktop, Mobile, Tablet, or Other | |
| Effective device targets | effectiveDeviceTargets | dim | Effective device targets at the campaign level; a combination of Desktop, Mobile, Tablet, or Other | |
| Language | languageTargets | dim | Language targets at the campaign level | |
| Location target | locationTargetName | dim | The name of the location target | |
| Location target bid modifier | locationTargetBidModifier | dim | The bid adjustment associated with the location target | |
| Campaign target ID | campaignTargetId | dim | The ID DS generated for a campaign target | |
| Ad group target ID | adGroupTargetId | dim | The ID DS generated for an ad group target | |
| Dynamic ad target conditions | dynamicSearchAdsTargetConditions | dim | The criteria the dynamic ad target uses to select pages under the site domain | |
| Dynamic ad target CPC bid | dynamicSearchAdsTargetCpcBid | dim | The dynamic ad target's max CPC (maximum cost per click) setting | |
| Dynamic ad target destination URL | dynamicSearchAdsTargetLandingPageUrl | dim | The dynamic ad target's destination URL | |
| Dynamic ad target coverage | dynamicSearchAdsTargetCoverage | dim | The percentage of pages on the advertiser's site that the dynamic ad target matches | |
| Age target range | ageTargetAgeRange | dim | The age range of age target | |
| Age target bid modifier | ageTargetBidModifier | dim | The bid adjustment associated with the age target | |
| Gender target type | genderTargetGenderType | dim | The gender type of gender target: Male, Female, Unknown | |
| Gender target bid modifier | genderTargetBidModifier | dim | The bid adjustment associated with the gender target | |
| REMARKETING | Engine remarketing list | engineRemarketingList | dim | The name of the remarketing list associated with the target |
| Engine remarketing list bid modifier | engineRemarketingListBidModifier | dim | The bid adjustment associated with the target | |
| CONVERSION | Conversion ID | conversionId | dim | ID that Search Ads 360 generates for each conversion |
| Advertiser conversion ID | advertiserConversionId | dim | For offline conversions, this is an ID provided by advertisers. If an advertiser doesn't specify such an ID, Search Ads 360 generates one. For online conversions, this is equal to the conversionId column or the floodlightOrderId column depending on the advertiser's Floodlight instructions | |
| Conversion status | conversionStatus | dim | The status of the conversion: Active or Removed | |
| Conversion type | conversionType | dim | The type of the conversion: Action or Transaction | |
| Conversion date | conversionDate | dim | The date, in the Campaign manager network time zone, when the conversion occurred | |
| Conversion attribution type | conversionAttributionType | dim | What the conversion is attributed to: Visit or Keyword+Ad | |
| Conversion visit ID | conversionVisitId | dim | The DS visit ID that the conversion is attributed to | |
| Conversion visit date | conversionVisitTimestamp | dim | The UTC date of the visit that the conversion is attributed to | |
| Conversion visit external click ID | conversionVisitExternalClickId | dim | A unique string, for the visit that the conversion is attributed to, that is passed to the landing page as the gclid URL parameter. Only enabled for advertisers with conversion API integration or Google Analytics integration | |
| Conversion search term | conversionSearchTerm | dim | The search term that led to the conversion | |
| Inventory account ID | inventoryAccountId | dim | The DS inventory account ID containing the product associated with the conversion. DS generates this ID when you link an inventory account in DS | |
| Product ID | productId | dim | The ID of the product associated with this conversion | |
| Product group ID | productGroupId | dim | The product group ID associated with this conversion. Only conversions from shopping campaigns have product group IDs | |
| Product target ID | productTargetId | dim | DS product target ID | |
| Product country | productCountry | dim | The country (ISO 3166 format) registered for the inventory feed that contains the product associated with this conversion | |
| Product language | productLanguage | dim | The language (ISO 639-1) of the product associated this conversion | |
| Product store ID | productStoreId | dim | The store in the Local Inventory Ad associated with the conversion | |
| Product channel | productChannel | dim | The sales channel of the product associated with the conversion: Online or Local | |
| Floodlight order ID | floodlightOrderId | dim | The Floodlight order ID provided by the advertiser for the conversion | |
| Floodlight event request string | floodlightEventRequestString | dim | The Floodlight request string of the conversion | |
| Floodlight referrer | floodlightReferrer | dim | The Floodlight referrer website of the conversion | |
| Feed ID | feedId | dim | The ID of the feed table associated with this conversion | |
| Feed item ID | feedItemId | dim | The ID of the feed item row associated with this conversion | |
| Feed type | feedType | dim | The type of feed associated with this conversion | |
| ENGINE STATS | Impressions | impr | met | The total number of impressions |
| Average position | avgPos | met | Average position | |
| Clicks | clicks | met | Aggregate clicks | |
| CTR (%) | ctr_perc | met | Average click-through rate | |
| Cost | cost | met | Aggregate cost paid to engine account(s) | |
| CPC | avgCpc | met | Average cost per click | |
| CPM | avgCpm | met | Average cost per thousand impressions | |
| DS Visits | visits | met | The total number of DS visits | |
| IMPRESSION SHARE | Display impression share | displayImpressionShare | met | AdWords only. The impressions you have received on the Display Network divided by the estimated number of impressions you were eligible to receive |
| Display lost impression share (budget) | displayBudgetLostImpressionShare | met | AdWords only. The percentage of time that your ads weren't shown on the Display Network due to insufficient budget | |
| Display lost impression share (rank) | displayRankLostImpressionShare | met | AdWords only. The percentage of time that your ads weren\u2019t shown on the Display Network due to poor Ad Rank | |
| Search impression share | searchImpressionShare | met | AdWords and Microsoft Advertising only. The impressions you have received on the Search Network divided by the estimated number of impressions you were eligible to receive | |
| Search lost impression share (budget) | searchBudgetLostImpressionShare | met | AdWords and Microsoft Advertising only. The percentage of time that your ads weren't shown on the Search Network due to insufficient budget | |
| Search lost impression share (rank) | searchRankLostImpressionShare | met | AdWords and Microsoft Advertising only. The percentage of time that your ads weren\u2019t shown on the Search Network due to poor Ad Rank | |
| ADWORDS | Conversions | adWordsConversionValue | met | Aggregate value of AdWords conversions |
| One-per-click conversions. | adWordsConversions | met | The data that the advertiser has set up to be reported in the AdWords Conversions column | |
| Many-per-click conversions. | adWordsConversionsManyPerClick | met | ||
| View-through conversions. | adWordsViewThroughConversions | met | The total number of AdWords view-through conversions | |
| DFA | Actions | dfaActions | met | The total number of DFA actions |
| Revenue | dfaRevenue | met | Aggregate revenue generated by DFA transactions | |
| Transactions | dfaTransactions | met | The total number of DFA transactions | |
| Weighted actions | dfaWeightedActions | met | Weighted sum of DFA actions | |
| SEARCH | Paid impressions | paidImpressions | met | The number of times an ad has appeared on a search results page or on a website in the Google Network after someone entered the search query |
| Paid clicks | paidClicks | met | The number of times someone clicked an ad after entering the search query | |
| Organic clicks | organicClicks | met | The number of clicks on unpaid search results for your site after someone entered the search query | |
| Paid and organic clicks | paidAndOrganicClicks | met | The number of clicks on either one of your ads ad or an unpaid search result for your site after someone entered the search query | |
| Organic queries | organicQueries | met | The total number of times users have entered the search query and saw at least one organic search result from your site | |
| Paid and organic queries | paidAndOrganicQueries | met | The total number of times users have entered the search query and saw at least one of your ads or at least one organic search result from your site | |
| Paid CTR | paidCtr | met | The click-through rate for an ad, which is how often people who see your ad end up clicking it after entering the search query | |
| Organic CTR | organicCtr | met | The rate at which people who see unpaid search results for your site end up clicking an unpaid result and landing on your site | |
| Paid average position | paidAvgPos | met | The average position in which the ad appears after someone entered the search query | |
| Paid CPC | paidCostPerClick | met | The average cost per click for an ad. This is the average amount you pay each time someone clicks your ad | |
| CONVERSION | Conversion revenue | conversionRevenue | met | The total dollar amount from the conversion |
| Conversion quantity | conversionQuantity | met | The quantity of items recorded by the conversion, as determined by the qty parameter. The advertiser is responsible for dynamically populating the parameter (such as number of items sold in the conversion), otherwise it defaults to 1 | |
| Floodlight original revenue | floodlightOriginalRevenue | met | The original, unchanged revenue associated with the Floodlight event (in the currency of the current report), before Floodlight currency instruction modifications | |
| IBM DIGITAL ANALYTICS | Product views | ibmAnalyticsProductViews | met | |
| Shopping cart additions | ibmAnalyticsCartAdditions | met | ||
| Purchases | ibmAnalyticsPurchases | met | ||
| Conversions | ibmAnalyticsConversions | met | ||
| Orders | ibmAnalyticsOrders | met | ||
| Cart revenue | ibmAnalyticsCartRevenue | met | ||
| Purchased revenue | ibmAnalyticsPurchasedRevenue | met | ||
| Order revenue | ibmAnalyticsOrderRevenue | met | ||
| Items in cart | ibmAnalyticsItemsInCart | met | ||
| Purchased items | ibmAnalyticsPurchasedItems | met | ||
| Adandonments | ibmAnalyticsAbandonments | met | ||
| Abandoned items | ibmAnalyticsAbandonedItems | met | ||
| Abandoned item revenue | ibmAnalyticsAbandonedItemRevenue | met |