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 | |
| Query | Start date | system_metadata.query_date_range_start | dim | The start date of the requested query |
| End date | system_metadata.query_date_range_end | dim | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | dim | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | dim | All filters used in the query | |
| Start | system_metadata.query_date_start | dim | When the query was started | |
| End | system_metadata.query_date_end | dim | When the query completed | |
| Duration | system_metadata.query_duration | dim | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | dim | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | dim | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | dim | The Supermetrics users that created the data source login connections |