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 (Sat-Sun) | 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 ID | account_id | dim | The account ID. Example: ca-pub-088712. |
| Client ID | ad_client_id | dim | The ID of an ad client. Example: ca-feed-pub-088712. | |
| URL CHANNEL | URL channel ID | url_channel_id | dim | The ID of a URL channel. |
| URL channel name | url_channel_name | dim | The domain name. | |
| AD FORMAT | Format code | ad_format_code | dim | Ad format code indicating the way an ad is shown to the users on your site. Examples: ON_PAGE, ANCHOR, INTERSTITIAL. |
| Format name | ad_format_name | dim | Localized ad format name indicating the way an ad is shown to the users on your site. Examples: In-page, Anchor, or Vignette. | |
| AD UNIT | Unit code | ad_unit_code | dim | The code of an ad unit. This value is not necessarily unique across ad clients. Example: 837572. |
| Unit ID | ad_unit_id | dim | The unique ID of an ad unit. Example: ca-pub-088712:837572. | |
| Unit name | ad_unit_name | dim | The name of an ad unit. | |
| Unit size code | ad_unit_size_code | dim | The size code of an ad unit. Examples: 720x42 or mobile_single. | |
| Unit size name | ad_unit_size_name | dim | The size name of an ad unit. Examples: 720x42 or Single (Mobile). | |
| BID | Bid type | bid_type_code | dim | The type of a bid. Examples: cpc, cpm. |
| Bid name | bid_type_name | dim | A bid type name. Examples: CPC bids, CPM bids. | |
| NETWORK | Network ID | buyer_network_id | dim | The ID of an ad network that sends ads to your site. |
| Network name | buyer_network_name | dim | The name of an ad network that sends ads to your site. Example: Google Adwords. | |
| DOMAIN | Domain name | domain_name | dim | A domain name. |
| COUNTRY | Country code | country_code | dim | The CLDR Region Code. Examples: US, FR. |
| Country name | country_name | dim | Region name. Examples: United States, France. | |
| CUSTOM CHANNEL | Channel code | cstm_channel_code | dim | The code of a custom channel. |
| Channel ID | cstm_channel_id | dim | The ID of a custom channel. | |
| Channel name | cstm_channel_name | dim | The name of a custom channel. | |
| PLATFORM AND PRODUCT | Platform type code | platform_type_code | dim | The code of a platform type. Examples: HighEndMobile, Desktop. |
| Platform type name | platform_type_name | dim | The name of a platform type. Examples: High-end mobile devices, Desktop. | |
| Product code | product_code | dim | The code of a product. Examples: AFC, AFS. | |
| Product name | product_name | dim | The name of a product. Examples: AdSense for Content, AdSense for Search. | |
| TARGET | Targeting type code | targeting_type_code | dim | A targeting type code. Examples: Keyword, UserInterest, RunOfNetwork. |
| Targeting type name | targeting_type_name | dim | A targeting type name. Examples: Contextual, Personalized, Run of Network. | |
| CLICKS AND EARNINGS | Ad clicks | ad_clicks | met | The number of times a user clicked on a standard content ad. |
| CPC | cost_per_click | met | The amount you earn each time a user clicks on your ad. | |
| CPC (EUR) | cost_per_click_eur | met | The amount you earn each time a user clicks on your ad in EUR. | |
| CPC (USD) | cost_per_click_usd | met | The amount you earn each time a user clicks on your ad in USD. | |
| CPC (GBP) | cost_per_click_gbp | met | The amount you earn each time a user clicks on your ad in GBP. | |
| Estimated earnings | earnings | met | The estimated earnings of the publisher. | |
| Estimated earnings (EUR) | earnings_eur | met | The estimated earnings of the publisher in EUR. | |
| Estimated earnings (USD) | earnings_usd | met | The estimated earnings of the publisher in USD. | |
| Estimated earnings (GBP) | earnings_gbp | met | The estimated earnings of the publisher in GBP. | |
| AD REQUESTS | Ad requests | ad_requests | met | The number of ad units that requested ads (for content ads) or search queries (for search ads). |
| Ad requests coverage | ad_requests_coverage | met | The ratio of requested ad units or queries to the number returned to the site. Not calculated | |
| Ad requests CTR (%) | ad_requests_ctr | met | The percentage of ad requests that resulted in a click. Calculated by: (Ad clicks / Ad requests) * 100 | |
| Ad requests RPM | ad_requests_rpm | met | The revenue per thousand ad requests. Calculated by: (Estimated earnings / Ad requests) * 1000 | |
| Matched ad request | matched_ad_request | met | The number of ad units (for content ads) or search queries (for search ads) that showed ads. | |
| Matched ad request CTR (%) | matched_ad_request_ctr | met | The percentage of matched queries that resulted in a click. Calculated by: (Ad clicks / Matched ad requests) * 100 | |
| Matched ad request RPM | matched_ad_request_rpm | met | The revenue per thousand matched queries. Calculated by: (Estimated earnings / Matched ad requests) * 1000 | |
| IMPRESSIONS | Ad impressions | individual_ad_impressions | met | The number of times an individual ad is displayed on your website. Different ad formats will display varying numbers of ads. |
| Ad impressions CTR (%) | individual_ad_impressions_ctr | met | The percentage of individual ad impressions that resulted in a click. Calculated by: (Ad clicks / Ad impressions) * 100 | |
| Ad impressions RPM | individual_ad_impressions_rpm | met | The revenue per thousand individual ad impressions. Calculated by: (Estimated earnings / Ad impressions) * 1000 | |
| PAGE VIEWS | Page views | page_views | met | The number of page views. |
| Page views CTR (%) | page_views_ctr | met | The percentage of individual page views that resulted in a click. Calculated by: (Ad clicks / Page views) * 100 | |
| Page views RPM | page_views_rpm | met | The revenue per thousand page views. Calculated by: (Estimated earnings / Page views) * 1000 |