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 of week (Sun-Sat) | yearOfWeek | dim | ||
Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
Year & month | yearMonth | dim | ||
Month | month | dim | ||
Year & week (Sun-Sat) | yearWeek | dim | ||
Year & week (Mon-Sun) | yearWeekIso | dim | ||
Week (Sun-Sat) | week | dim | ||
Week (Mon-Sun) | weekIso | dim | ||
Day of month | dayOfMonth | dim | ||
Day of week (Sun-Sat) | dayOfWeekName | dim | ||
Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
Date | date | dim | ||
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 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 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 | |
DEPRECATED | Unit code | ad_unit_code | dim | The code of an ad unit. This value is not necessarily unique across ad clients. Example: 837572. Please note that this field will be removed on 2021-08-01 |
Channel code | cstm_channel_code | dim | The code of a custom channel. Please note that this field will be removed on 2021-08-01 | |
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 | |
Ad requests CTR (%) | ad_requests_ctr | met | The ratio of ad requests that resulted in a click | |
Ad requests RPM | ad_requests_rpm | met | The revenue per thousand ad requests | |
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 ratio of matched queries that resulted in a click | |
Matched ad request RPM | matched_ad_request_rpm | met | The revenue per thousand matched queries | |
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 ratio of individual ad impressions that resulted in a click | |
Ad impressions RPM | individual_ad_impressions_rpm | met | The revenue per thousand individual ad impressions | |
PAGE VIEWS | Page views | page_views | met | The number of page views |
Page views CTR (%) | page_views_ctr | met | The ratio of individual page views that resulted in a click | |
Page views RPM | page_views_rpm | met | The revenue per thousand page views |