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) | isoweek | dim | ||
| Day of week | dayofweek | dim | ||
| Date | date | dim | ||
| ACCOUNT | Account ID | account_id | dim | |
| PAGES & QUERIES | Page URL | page_url | dim | |
| Query string | query_string | dim | ||
| FEEDS | Feed URL | feed_url | dim | |
| Feed type | feed_type | dim | Unknown, Empty, Xml, XmlIndex, Txt, Atom, Rss, Html, XmlBaidu, Shop | |
| Feed status | feed_status | dim | Current feed status | |
| Is compressed | feed_compressed | dim | Is the feed compressed or not | |
| Submitted date | feed_submitted_date | dim | ||
| Last crawled date | feed_crawled_date | dim | ||
| CRAWL ISSUES | Issue URL | issue_url | dim | |
| Issue type | issue_type | dim | ||
| Last HTTP code | issue_http_code | dim | ||
| QUERY PARAMETERS | Parameter name | parameter_name | dim | |
| Is enabled | parameter_enabled | dim | Whether the parameter is enabled or not | |
| Source ID | parameter_source | dim | Source identifier | |
| FETCHED URLS | Fetched URL | fetched_url | dim | |
| Fetching completed | fetched_completed | dim | Flag indicates that the URL fetching was completed | |
| Fetching expired | fetched_expired | dim | Whether fetching was canceled and there is no data | |
| BLOCKED URLS | Blocked URL | blocked_url | dim | URL which needed to be blocked |
| Entity type | blocked_entity_type | dim | Page or directory | |
| Request type | blocked_request_type | dim | Cache only or a full block | |
| DISAVOWED LINKS | Disavowed URL | disavow_link | dim | The link you have disavowed |
| Entity type ID | disavow_entity_id | dim | Page (0), Directory (1) or Domain (2) | |
| DEPRECATED | Account (deprecated) | account | dim | Please note that this field will be removed on 2021-01-21 |
| PAGES & QUERIES | Impressions | impressions | met | |
| Clicks | clicks | met | ||
| Avg impression position | avg_impression_position | met | ||
| Avg click position | avg_click_position | met | ||
| CRAWLS | Crawled pages | crawls_pages | met | Number of crawled pages |
| Pages in index | in_index | met | Total number of pages stored in index | |
| Inbound links | in_links | met | Total number of inbound links referred to the site | |
| Crawl errors | crawls_errors | met | Number of crawl errors | |
| Code 2xx | crawls_2xx | met | Number of pages with HTTP status code 200-299 | |
| Code 301 | crawls_301 | met | Number of pages with "Moved Permanently" HTTP error code | |
| Code 302 | crawls_302 | met | Number of pages with "Moved Temporarily" HTTP error code | |
| Code 4xx | crawls_4xx | met | Number of pages with HTTP status code 400-499 | |
| Code 5xx | crawls_5xx | met | Number of pages with HTTP status code 500-599 | |
| All other codes | crawls_other | met | Number of pages with other HTTP status codes | |
| Blocked by robots.txt | crawls_blocked_robots_txt | met | Number of pages blocked by robots.txt | |
| Contains malware | crawls_contains_malware | met | Number of pages infected with malware | |
| FEEDS | File size | feed_filesize | met | File size in bytes |
| URL count | feed_url_count | met | Number of valid, extracted URLs or number of sitemaps in an index file | |
| BLOCKED URLS | Days to expire | days_to_expire | met | How many days till the expiration of a blocked URL |
| CRAWL ISSUES | Inbound links | issue_in_links | met | Number of inbound links |