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 |
| Month | Yearmonth | dim | Month, e.g. 6 | |
| Week (Sun-Sat) | yearweek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Week (Mon-Sun) | yearweekiso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Week (Mon-Sun, dates) | yearweekiso_daterange | dim | ||
| Day of week (numeric) | Dayofweek | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (name) | DayofweekName | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Date | Date | dim | Date, e.g. 2017-01-31 | |
| Hour | Hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| ADVERTISER | Advertiser | Advertiser_Name | dim | The name of the advertiser account |
| Advertiser ID | Advertiser_ID | dim | The ID of the advertiser account | |
| Advertiser timezone | Advertiser_Timezone | dim | The advertiser account timezone, e.g., America/New_York | |
| Advertiser Currency | Advertiser_Currency | dim | Advertiser currency, e.g., USD | |
| Advertiser tracking URL | Advertiser_Tracking_URL | dim | Represents the optional template at the Advertiser level to specify additional tracking parameters or redirects | |
| CAMPAIGN | Campaign | Campaign_Name | dim | The name of the campaign |
| Campaign ID | Campaign_ID | dim | The ID of the campaign | |
| Campaign start date | Campaign_Start_Date | dim | The start date of the campaign | |
| Campaign end date | Campaign_End_Date | dim | The end date of the campaign | |
| Campaign status | Campaign_Status | dim | The status of the campaign (ACTIVE, PAUSED) | |
| Campaign objective | Campaign_Objective | dim | The objective of the campaign as defined in the campaign settings | |
| Campaign tracking URL | Campaign_Tracking_URL | dim | Represents the optional template at the Campaign level to specify additional tracking parameters or redirects | |
| Budget | Budget | dim | The lifetime budget at the campaign level | |
| Budget type | Budget_Type | dim | The type of budget | |
| AUDIENCE | Audience ID | Audience_ID | dim | |
| Audience Type | Audience_Type | dim | ||
| AD GROUP | Ad group name | Ad_Group_Name | dim | The name of the ad group |
| Ad group ID | Ad_Group_ID | dim | The ID of the ad group | |
| Ad group status | Ad_Group_Status | dim | The status of the ad group (ACTIVE, PAUSED) | |
| Ad group tracking URL | Ad_Group_Tracking_URL | dim | Represents the optional template at the Ad Group level to specify additional additional tracking parameters or redirects | |
| AD | Ad title | Ad_Title | dim | The title of the ad that is shown to the user. Max length is 50 characters |
| Ad ID | Ad_ID | dim | The ID of the ad | |
| Ad description | Ad_Description | dim | The description of the ad that is shown to the user. This field supports keyword insertion. Max length is 150 characters | |
| Ad sponsored by | Ad_SponsoredBy | dim | The string shown against the sponsored by label in the ad | |
| Ad landing URL | Ad_Landing_URL | dim | The URL where the user was redirected to upon clicking the ad | |
| Ad display URL | Ad_Display_URL | dim | The user-friendly URL that is displayed to the user | |
| Ad final URL | Ad_Final_URL | dim | Represents the final URL for the Ad that a user ultimately sees in the browser bar after clicking an ad | |
| Ad mobile final URL | Ad_Mobile_Final_URL | dim | Represents the final mobile URL for the Ad after all cross domain redirects | |
| Ad image URL | Ad_Image_URL | dim | The URL of the (uploaded thumbnail) image | |
| Ad tracking URL | Ad_Tracking_URL | dim | Represents the optional template at the Ad level to specify additional tracking parameters or redirects | |
| KEYWORD | Keyword value | Keyword | dim | The keyword text |
| Keyword ID | Keyword_ID | dim | The id of the keyword | |
| Keyword match type | Keyword_Match_Type | dim | The keyword match type | |
| Keyword status | Keyword_Status | dim | The keyword status | |
| Keyword param 1 | Keyword_Param_1 | dim | The param1 value for the keyword | |
| Keyword landing URL | Keyword_Landing_URL | dim | The keyword landing URL | |
| Keyword final URL | Keyword_Final_URL | dim | Represents the final URL for the Keyword that a user ultimately sees in the browser bar after clicking an ad | |
| Keyword mobile final URL | Keyword_Mobile_Final_URL | dim | Represents the final mobile URL for the Keyword after all cross domain redirects | |
| Keyword tracking URL | Keyword_Tracking_URL | dim | Represents the optional template at the Keyword level to specify additional tracking parameters or redirects | |
| AD EXTENSION | Ad extension ID | Ad_Extn_ID | dim | The ID of the ad extension |
| Ad extension type | Ad_Extn_Type | dim | The type of the ad extension | |
| Ad extension parent type | Ad_Extn_Parent_Type | dim | The parent type of the ad extension | |
| Ad extension title | Ad_Extn_Title | dim | The title of the ad extension. Populated only for sitelinks | |
| Ad extension phone number | Ad_Extn_Phone_Number | dim | The phone number associated with the ad extension. Applies to call extensions | |
| USERS | Age | Age | dim | Age group of the user: 18-24, 25-34, 35-44, 45-54, 55-64 |
| Gender | Gender | dim | The gender of the user: F, M, or U | |
| Device | Device | dim | The device type of the user: SmartPhone, Tablet or Desktop | |
| Source | Source | dim | Source=1 represents native traffic. Source=2 represents search traffic | |
| GEO | Country | Country | dim | Name of the user's country |
| Country code | CountryCode | dim | Two-letter code of the user's country | |
| City | City | dim | Name of the user's city | |
| State | State | dim | Name of the user's state | |
| ZIP | Zip | dim | Zip code of the user | |
| PRODUCT | Product Type | Product_Type | dim | Product type |
| Product Group ID | Product_Group_ID | dim | ID of the product group | |
| PRODUCT CATEGORIES | Category ID | Category_ID | dim | ID of the product category |
| Parent category ID | Parent_Category_ID | dim | ID of the parent product category | |
| Category Name | Category_Name | dim | The name associated with the Category ID | |
| Category path | Category_Path | dim | The full category path | |
| ADDITIONAL DIMENSIONS | Max bid | Max_Bid | dim | The maximum bid value |
| Destination URL | Destination_URL | dim | The actual served URL post macro-expansion | |
| Delivered match type | Delivered_Match_Type | dim | Match type set the keyword delivered on | |
| Search term | Search_Term | dim | The phrase canon user search query | |
| Pricing type | Pricing_Type | dim | The pricing type | |
| Price type | Price_Type | dim | The price type | |
| Brand | Brand | dim | Brand of the offer, same value as the 'brand' field in the product feed | |
| Item ID | Item_ID | dim | ||
| Is adjustment | Is_Adjustment | dim | For adjustment rows, all fact values other than Spend are always blank. Pricing Type and Source values are also blank | |
| Adjustment type | Adjustment_Type | dim | If you request a report at Campaign ID granularity, then you will get only campaign adjustment rows (plus unadjusted rows). If you request a report at Advertiser ID granularity, then you will potentially get both account adjustments (Adjustment Type = 'Account') and rolled up campaign adjustment (Adjustment Type = 'Campaign'), as well as unadjusted rows (Adjustment Type = 'None') | |
| Conversion device | Conversion_Device | dim | SmartPhone, Tablet or Desktop. This is the device the conversion event occurred on, and it can be different from the device associated with the impression or click. Device on other reports is the device associated with the impression, click events | |
| Rule ID | Rule_ID | dim | The id associated with the conversion rule | |
| Rule Name | Rule_Name | dim | The name associated with the conversion | |
| METRICS | Impressions | Impressions | met | The number of impressions |
| Clicks | Clicks | met | The number of clicks | |
| Spend | Spend | met | Campaign cost in the currency of the advertising account | |
| Spend (EUR) | Spend_eur | met | Campaign cost converted to euros | |
| Spend (USD) | Spend_usd | met | Campaign cost converted to US dollars | |
| Average position | Average_Position | met | Impression weighted average position | |
| CPC | Average_CPC | met | The average CPC bid value | |
| eCPM | Average_CPM | met | The average CPM bid value | |
| CTR (%) | CTR_perc | met | The click-through rate | |
| CONVERSION METRICS | Post click conversions | Post_Click_Conversions | met | The total number of post click conversions |
| Post click conversion value | Post_Click_Conversion_Value | met | The conversion value attributed to post click conversions | |
| Post impression conversions | Post_Impression_Conversions | met | The total number of post view conversions | |
| Post impression conversion value | Post_Impression_Conversion_Value | met | The conversion value attributed to post view conversions | |
| Post view conversions | Post_View_Conversions | met | The total number of post view conversions | |
| Post view conversion value | Post_View_Conversion_Value | met | The value associated with the conversion event | |
| Conversions | Conversions | met | The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view | |
| Conversion value | Conversion_Value | met | The actual value associated with the conversion event | |
| Total conversions | Total_Conversions | met | The total number of conversions, includes both post click and post view conversions. For app install campaigns the default conversion windows are 7 days post-click and 1 day post view. For website conversions the default windows are 30 days post-click and 2 days post-view | |
| ADJUSTMENT METRICS | Adjusted impressions | Adjusted_Impressions | met | The number of impressions |
| Adjusted clicks | Adjusted_Clicks | met | The number of clicks | |
| Adjusted conversions | Adjusted_Conversions | met | The total number of conversions includes both post click and post view conversions | |
| Adjusted spend | Adjusted_Spend | met | The spend amount | |
| Adjusted average position | Adjusted_Average_Position | met | Impression weighted average position | |
| Adjusted CPC | Adjusted_Average_CPC | met | The average CPC value | |
| Adjusted eCPM | Adjusted_Average_CPM | met | The average cost per impression | |
| Adjusted CTR (%) | Adjusted_CTR_perc | met | The adjusted click-through rate | |
| AD EXTENSION METRICS | Ad Extn impressions | Ad_Extn_Impressions | met | Total impressions for which an ad extension was displayed |
| Ad Extn clicks | Ad_Extn_Clicks | met | Total clicks on an ad extension link (rather than on the ad landing URL) | |
| Ad extn conversions | Ad_Extn_Conversions | met | Total conversions which were attributed back to an ad extension link click | |
| Ad extn spend | Ad_Extn_Spend | met | The spend resulting from clicking on an ad extension link | |
| VIDEO METRICS | Video starts | Video_Starts | met | The number of video starts |
| Video views | Video_Views | met | The number of video views | |
| Video 25% complete | Video_25_Complete | met | Number of times the video played to 25% of its length | |
| Video 50% complete | Video_50_Complete | met | Number of times the video played to 50% of its length | |
| Video 75% complete | Video_75_Complete | met | Number of times the video played to 75% of its length | |
| Video 100% complete | Video_Complete | met | Number of times the video played to 100% of its length | |
| Cost per video view | Cost_Per_Video_View | met | Average cost per video view | |
| Video closed | Video_Closed | met | The number of times the video was closed | |
| Video skipped | Video_Skipped | met | The number of times the video was skipped | |
| Video after 30 seconds view | Video_after_30_seconds_view | met | The number of times the video played longer than 30 seconds |