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 (Sun-Sat) | 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 | |
| SEARCH | Search term | search_term | dim | |
| Country | country_name | dim | ||
| INTEREST | Interest | interest | met | Numbers represent search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth |
| 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 (Sun-Sat) | 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 | |
| Hour | hour | dim | Hour in a 24-hour clock, e.g. 18 | |
| SEARCH | Search term | search_term | dim | |
| Country | country_name | dim | ||
| INTEREST | Interest | interest | met | Numbers represent search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth |
| SEARCH | Search term | search_term | dim | |
| GEO | Country label | country_label | dim | Name of the country |
| Country code | country_code | dim | Code of the country | |
| Region label | region_label | dim | Name of the region | |
| Region code | region_code | dim | Code of the region | |
| DMA label | dma_label | dim | Name of the DMA | |
| DMA code | dma_code | dim | Code of the DMA | |
| City label | city_label | dim | Name of the city | |
| City code | city_code | dim | Code of the city | |
| DEPRECATED | Geo code | geo_code | dim | Code of the country/region/city. Please note that this field will be removed on 2021-09-14 |
| Geo label | geo_label | dim | Name of the country/region/city. Please note that this field will be removed on 2021-09-14 | |
| INTEREST | Interest | interest | met | Numbers represent search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth |
| SEARCH | Search term | search_term | dim | |
| Country | country_name | dim | ||
| RELATED QUERY | Related query | related_query | dim | Other search queries that are related to the one you input |
| INTEREST | Interest | interest | met | Numbers represent search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth |
| SEARCH | Search term | search_term | dim | |
| Country | country_name | dim | ||
| TOPIC | Topic title | topic_title | dim | Title of the topic related to the search query you input |
| Topic type | topic_type | dim | Type of the topic related to the search query you input | |
| Topic code | topic_code | dim | You can use these topic codes to fetch interest by topic with the Interest over time, Interest by hour or Interest by region query types | |
| INTEREST | Interest | interest | met | Numbers represent search interest relative to the highest point for the given region and time. A value of 100 is the peak popularity for the term. A value of 50 means that the term is half as popular. A score of 0 means there was not enough data for this term. When fetching rising related queries, this metric will return percentage growth |
| SEARCH | Search term | search_term | dim | |
| TOPIC | Topic title | topic_title | dim | Title of the topic related to the search query you input |
| Topic type | topic_type | dim | Type of the topic related to the search query you input | |
| Topic code | topic_code | dim | You can use these topic codes to fetch interest by topic with the Interest over time, Interest by hour or Interest by region query types | |
| 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 (Sun-Sat) | 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 | |
| SEARCH | Search term | search_term | dim | |
| TRENDING SEARCHES | Search volume | search_volume | dim | Approximate search volume for the search term |
| Related queries | related_queries | dim | A list of search queries related to the trending search term | |
| Related news 1 title | related_news_1_title | dim | Title of the 1st related news article | |
| Related news 1 source | related_news_1_source | dim | Source of the 1st related news article | |
| Related news 1 URL | related_news_1_url | dim | Link to the 1st related news article | |
| Related news 1 image URL | related_news_1_image_url | dim | Image URL of the 1st related news article | |
| Related news 2 title | related_news_2_title | dim | Title of the 2nd related news article | |
| Related news 2 source | related_news_2_source | dim | Source of the 2nd related news article | |
| Related news 2 URL | related_news_2_url | dim | Link to the 2nd related news article | |
| Related news 2 image URL | related_news_2_image_url | dim | Image URL of the 2nd related news article | |
| Related news 3 title | related_news_3_title | dim | Title of the 3rd related news article | |
| Related news 3 source | related_news_3_source | dim | Source of the 3rd related news article | |
| Related news 3 URL | related_news_3_url | dim | Link to the 3rd related news article | |
| Related news 3 image URL | related_news_3_image_url | dim | Image URL of the 3rd related news article | |
| Related news 4 title | related_news_4_title | dim | Title of the 4th related news article | |
| Related news 4 source | related_news_4_source | dim | Source of the 4th related news article | |
| Related news 4 URL | related_news_4_url | dim | Link to the 4th related news article | |
| Related news 4 image URL | related_news_4_image_url | dim | Image URL of the 4th related news article |