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) | year_of_week | dim | ||
| Year of week (Mon-Sun) | year_of_week_iso | dim | ||
| Year & month | year_month | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | year_week | dim | ||
| Year & week (Mon-Sun) | year_week_iso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | week_iso | dim | ||
| Day of month | day_of_month | dim | ||
| Day of week (Sun-Sat) | day_of_week_name | dim | ||
| Day of week (Mon-Sun) | day_of_week_name_iso | dim | ||
| Date | date | dim | ||
| Datetime | atom | dim | ||
| All | Alt text | alt | dim | The alt attribute of the link. |
| Anchor | anchor | dim | The clickable words in a link that point to a URL. | |
| Best position has video | best_position_has_video | dim | The top position has a video. | |
| Best position set | best_position_set | dim | The ranking group of the top position. | |
| URL | best_position_url | dim | The ranking URL in organic search results. | |
| New destination of modified redirect | broken_redirect_new_target | dim | The new destination of a modified redirect. | |
| Reason redirect was considered broken | broken_redirect_reason | dim | The reason the redirect was considered broken during the last crawl. | |
| Referring domain of broken redirect | broken_redirect_source | dim | The redirecting URL that was modified, causing the redirect to become broken. | |
| Country | country | dim | Country of the request. | |
| Date | date_from | dim | ||
| Discovered status | discovered_status | dim | The reason the link was discovered during the last crawl: the page was crawled for the first time, the link was added to the page, or the link re-appeared after being removed. | |
| Domain | domain | dim | A referring domain that has at least one link to your target. | |
| Drop reason | drop_reason | dim | The reason we removed the link from our index. | |
| Character encoding | encoding | dim | The character set encoding of the referring page HTML. | |
| First seen page URL | first_seen | dim | The date the referring page URL was first discovered. | |
| First seen | first_seen_link | dim | The date we first found a backlink to your target on a given referring page. | |
| From date | from_date | dim | From date. | |
| Referring page http code | http_code | dim | The return code from HTTP protocol returned during the referring page crawl. | |
| HTTP crawl status | http_crawl | dim | The link was discovered without executing javascript and rendering the page. | |
| Referring domain IP address | ip_source | dim | The referring domain IP address. | |
| Alternate link | is_alternate | dim | The link with the rel=“alternate” attribute. | |
| Is best position set top 11 50 | is_best_position_set_top_11_50 | dim | The ranking group of the top position is 11-50. | |
| Is best position set top 3 | is_best_position_set_top_3 | dim | The ranking group of the top position is Top 3. | |
| Canonical link | is_canonical | dim | The link with the rel=“canonical” attribute. | |
| Content | is_content | dim | The link was found in the biggest piece of content on the page. | |
| Dofollow link | is_dofollow | dim | The link has no special nofollow attribute. | |
| Form link | is_form | dim | The link was found in a form HTML tag. | |
| Framed link | is_frame | dim | The link was found in an iframe HTML tag. | |
| Image link | is_image | dim | The link is a regular link that has an image inside their href attribute. | |
| Lost link | is_lost | dim | The link currently does not exist anymore. | |
| New link | is_new | dim | The link was discovered on the last crawl. | |
| Nofollow | is_nofollow | dim | The link or the referring page has the nofollow attribute set. | |
| Redirect | is_redirect | dim | The link pointing to your target via a redirect. | |
| Lost redirect | is_redirect_lost | dim | The redirected link currently does not exist anymore. | |
| Root domain | is_root_domain | dim | The domain name is a root domain name. | |
| Root domain referring link | is_root_source | dim | The referring domain name is a root domain name. | |
| Root domain target link | is_root_target | dim | The target domain name is a root domain name. | |
| RSS link | is_rss | dim | The link was found in an RSS feed. | |
| Sponsored | is_sponsored | dim | The link has the Sponsored attribute set in the referring page HTML. | |
| Text link | is_text | dim | The link is a standard href hyperlink. | |
| UGC | is_ugc | dim | The link has the User Generated Content attribute set in the referring page HTML. | |
| Rendered | js_crawl | dim | The link was discovered after executing javascript and rendering the page. | |
| Keyword | keyword | dim | The keyword your target ranks for. | |
| Language (SERP) | language | dim | The SERP language. | |
| Languages | languages | dim | The languages listed in the referring page metadata or detected by the crawler to appear in the HTML. | |
| Lost | last_seen | dim | The date we discovered that the link was lost. | |
| Updated | last_update | dim | The date when we last checked search engine results for a keyword. | |
| Last seen | last_visited | dim | The date we last verified a live link to your target page. | |
| Last visited target | last_visited_target | dim | The date we last re-crawled the target page to verify that it is broken. | |
| Limit | limit | dim | ||
| Type | link_type | dim | The kind of the backlink. | |
| Lookback window | lookback | dim | ||
| Lost status | lost_reason | dim | The reason the link was lost during the last crawl. | |
| Mode | mode | dim | ||
| Referring domain name | name_source | dim | The complete referring domain name, including subdomains. | |
| Target domain name | name_target | dim | The complete target domain name, including subdomains. | |
| Noindex status | noindex | dim | The referring page has the noindex meta attribute. | |
| Parent topic | parent_topic | dim | Parent Topic determines if you can rank for your target keyword while targeting a more general topic on your page instead. To identify the Parent Topic, we take the #1 ranking page for your keyword and find the keyword responsible for sending the most traffic to that page. | |
| Referring domain port | port_source | dim | The network port of the referring page URL. | |
| Target domain port | port_target | dim | The network port of the target page URL. | |
| Platform | powered_by | dim | Web technologies used to build and serve the referring page content. | |
| Protocol | protocol | dim | ||
| Raw URL | raw_url | dim | The ranking page URL in encoded format. | |
| Raw URL prev | raw_url_prev | dim | The ranking page URL on the comparison date in encoded format. | |
| Redirect code | redirect_code | dim | The HTTP status code of a referring page pointing to your target via a redirect. | |
| Redirect kind | redirect_kind | dim | The HTTP status codes returned by the target redirecting URL or redirect chain. | |
| Referring domain root | root_name_source | dim | The root domain name of the referring domain, not including subdomains. | |
| Target domain root | root_name_target | dim | The root domain name of the target domain, not including subdomains. | |
| SERP feature items | serp_features | dim | The SERP features that appear in search results for a keyword. | |
| SERP last update | serp_last_update | dim | The date when we last checked search engine results for a keyword. | |
| Left context | snippet_left | dim | The snippet of text appearing just before the link. | |
| Right context | snippet_right | dim | The snippet of text appearing just after the link. | |
| Referring page author | source_page_author | dim | The author of the referring page. | |
| Target URL (input) | target_url | dim | Target URL. | |
| Referring page | title | dim | The html title of the referring page. | |
| TLD class of referring domain | tld_class_source | dim | The top level domain class of the referring domain. | |
| TLD class of target domain | tld_class_target | dim | The top level domain class of the target domain. | |
| Top keywords | top_keyword | dim | The keyword that brings the most organic traffic to a page. | |
| Top keyword best position kind | top_keyword_best_position_kind | dim | The kind of the top position: organic, paid or a SERP feature. | |
| Top keyword best position kind prev | top_keyword_best_position_kind_prev | dim | The kind of the top position on the comparison date. | |
| Top keyword best position title | top_keyword_best_position_title | dim | The title displayed for the page in its top keyword's SERP. | |
| Top keyword best position title prev | top_keyword_best_position_title_prev | dim | The title displayed for the page in its top keyword's SERP on the comparison date. | |
| Top keyword country | top_keyword_country | dim | The country in which a page ranks for its top keyword. | |
| Top keyword country prev | top_keyword_country_prev | dim | The country in which a page ranks for its top keyword on the comparison date. | |
| Top keyword prev | top_keyword_prev | dim | The keyword that brings the most organic traffic to a page on the comparison date. | |
| URL | url | dim | The ranking page URL. | |
| Referring page URL | url_from | dim | The URL of the page containing a link to your target. | |
| Plain referring URL | url_from_plain | dim | The referring page URL optimized for use as a filter. | |
| URL prev | url_prev | dim | The ranking page URL on the comparison date. | |
| Redirect URL(s) | url_redirect | dim | The target redirecting URL or redirect chain. | |
| Target URL | url_to | dim | The URL the backlink points to. | |
| Plain target URL | url_to_plain | dim | The target page URL optimized for use as a filter. | |
| Ads count | ads_count | met | The number of unique ads with a page. | |
| Ads count diff | ads_count_diff | met | The change in ads between your selected dates. | |
| Ahrefs rank | ahrefs_rank | met | The strength of your target's backlink profile compared to the other websites in our database, with rank #1 being the strongest. | |
| Ahrefs rank (AR) | ahrefs_rank_source | met | The strength of the referring domain's backlink profile compared to the other websites in our database, with rank #1 being the strongest. | |
| Target domain rank | ahrefs_rank_target | met | The strength of the target domain's backlink profile compared to the other websites in our database, with rank #1 being the strongest. | |
| Backlinks all time | all_time | met | The total number of links from other websites pointing to your target for all time. | |
| Referring domains all time | all_time_refdomains | met | The total number of unique domains linking to your target for all time. | |
| Position | best_position | met | The top position your target ranks for in the organic search results for a keyword. | |
| Class C | class_c | met | The number of unique class_c subnets linking to the referring page. | |
| CPC | cpc | met | Cost Per Click shows the average price that advertisers pay for each ad click in paid search results for a keyword, in cents. | |
| Dofollow linked domains | dofollow_linked_domains | met | The number of unique root domains with dofollow links linked from the referring domain. | |
| Dofollow links | dofollow_links | met | The number of links from the referring domain to your target that don't have the “nofollow” attribute. | |
| Dofollow ref. domains | dofollow_refdomains | met | The number of unique domains with dofollow links to the referring domain. | |
| Domain rating (DR) | domain_rating | met | The strength of a domain's backlink profile compared to the others in our database on a 100-point scale. | |
| Domain rating (DR) | domain_rating_source | met | The strength of the referring domain's backlink profile compared to the others in our database on a 100-point scale. | |
| Target domain rating | domain_rating_target | met | The strength of the referring domain's backlink profile compared to the others in our database on a 100-point scale. | |
| Keyword difficulty (KD) | keyword_difficulty | met | An estimation of how hard it is to rank in the top 10 organic search results for a keyword on a 100-point scale. | |
| Link group count | link_group_count | met | The number of backlinks that were grouped together based on the aggregation parameter. This field cannot be used with aggregation 'all'. | |
| Linked domains in referring domain | linked_domains_source_domain | met | The number of unique root domains linked from the referring domain. | |
| Linked domains | linked_domains_source_page | met | The number of unique root domains linked from the referring page. | |
| Linked domains in target domain | linked_domains_target_domain | met | The number of unique root domains linked from the target domain. | |
| External links | links_external | met | The number of external links from the referring page. | |
| Internal links | links_internal | met | The number of internal links from the referring page. | |
| Links to target | links_to_target | met | The number of backlinks from the referring domain to your target. | |
| Backlinks count | live | met | The total number of links from other websites pointing to your target. | |
| Referring domains | live_refdomains | met | The total number of unique domains linking to your target. | |
| Lost links | lost_links | met | The number of backlinks lost from the referring domain for the selected time period. | |
| New links | new_links | met | The number of new backlinks found from the referring domain for the selected time period. | |
| Organic cost | org_cost | met | The estimated value of your target's monthly organic search traffic. | |
| Organic keywords | org_keywords | met | The total number of keywords that your target ranks for in the top 100 organic search results. | |
| Organic keywords top 3 | org_keywords_1_3 | met | The total number of keywords that your target ranks for in the top 3 organic search results. | |
| Organic traffic | org_traffic | met | The estimated number of monthly visitors that your target gets from organic search. | |
| Page size | page_size | met | The size in bytes of the referring page content. | |
| Paid cost | paid_cost | met | The estimated cost of your target's monthly paid search traffic. | |
| Paid keywords | paid_keywords | met | The total number of keywords that your target ranks for in paid search results. | |
| Paid pages | paid_pages | met | The total number of pages from a target ranking in paid search results. | |
| Paid traffic | paid_traffic | met | The estimated number of monthly visitors that your target gets from paid search. | |
| Keywords | positions | met | The number of keywords that the referring page ranks for in the top 100 positions. | |
| Ahrefs 0 pages | range0_pages | met | The total number of pages with 0 traffic. | |
| Ahrefs 100 pages | range100_pages | met | The total number of pages with 1-100 traffic. | |
| Ahrefs 100 traffic | range100_traffic | met | The total traffic from pages with 1-100 traffic. | |
| Ahrefs 10000 pages | range10k_pages | met | The total number of pages with 5K-10K traffic. | |
| Ahrefs 10000+ pages | range10k_plus_pages | met | The total number of pages with 10K+ traffic. | |
| Ahrefs 10000+ traffic | range10k_plus_traffic | met | The total traffic from pages with 10K+ traffic. | |
| Ahrefs 10000 traffic | range10k_traffic | met | The total traffic from pages with 5K-10K traffic. | |
| Ahrefs 1000 pages | range1k_pages | met | The total number of pages with 101-1K traffic. | |
| Ahrefs 1000 traffic | range1k_traffic | met | The total traffic from pages with 101-1K traffic. | |
| Ahrefs 5000 pages | range5k_pages | met | The total number of pages with 1K-5K traffic. | |
| Ahrefs 5000 traffic | range5k_traffic | met | The total traffic from pages with 1K-5K traffic. | |
| Refdomains | refdomains | met | The total number of unique domains linking to your target. | |
| Referring domains | refdomains_source | met | The number of unique referring domains linking to the referring page. | |
| Number of referring domains | refdomains_source_domain | met | The number of unique referring domains linking to the referring domain. | |
| Number of referencing domains | refdomains_target_domain | met | The number of unique referring domains linking to the target domain. | |
| SERP features (SF) | serp_features_count | met | The number of SERP features that appear in search results for a keyword. | |
| SERP target main positions count | serp_target_main_positions_count | met | The number of target URLs ranking for a keyword excluding positions in Sitelinks, Top stories, Image packs, and Tweets. | |
| SERP target positions count | serp_target_positions_count | met | The number of target URLs ranking for a keyword. | |
| Paid traffic | sum_paid_traffic | met | An estimation of the number of monthly visits that your target gets from paid search for a keyword. | |
| Organic traffic | sum_traffic | met | An estimation of the number of monthly visitors that your target gets from organic search for a keyword. | |
| Page traffic | traffic | met | The referring page's estimated monthly organic traffic from search. | |
| Domain traffic | traffic_domain | met | The referring domain's estimated monthly organic traffic from search. | |
| URL rating (UR) | url_rating | met | The strength of your target page's backlink profile compared to the other websites in our database on a 100-point logarithmic scale. | |
| URL rating (UR) | url_rating_source | met | The strength of the referring page's backlink profile compared to the others in our database on a 100-point scale. | |
| Volume | volume | met | An estimation of the number of searches for a keyword over the latest month. | |
| Words | words | met | The number of words in a keyword. | |
| Keywords | keywords | met | The total number of keywords that your target ranks for in the top 100 organic search results. | |
| Keywords diff | keywords_diff | met | The change in keywords between your selected dates. | |
| Keywords diff percent | keywords_diff_percent | met | The change in keywords between your selected dates, in percents. | |
| Keywords merged | keywords_merged | met | The total number of keywords optimized for sorting. | |
| Keywords prev | keywords_prev | met | The keyword your target ranks for on the comparison date. | |
| Pages | pages | met | The total number of pages from a target ranking in the top 100 organic search results. | |
| Organic traffic | sum_traffic | met | An estimation of the monthly organic search traffic that a page gets from all the keywords that it ranks for. | |
| Traffic merged | sum_traffic_merged | met | The traffic field optimized for sorting. | |
| Traffic prev | sum_traffic_prev | met | The traffic on the comparison date. | |
| Top keyword best position | top_keyword_best_position | met | The ranking position that a page holds for its top keyword. | |
| Top keyword best position diff | top_keyword_best_position_diff | met | The change in the top position between your selected dates. | |
| Top keyword best position prev | top_keyword_best_position_prev | met | The top position on the comparison date. | |
| Top keyword volume | top_keyword_volume | met | An estimation of the average monthly number of searches for the top keyword over the latest month or over the latest known 12 months of data depending on the "volume_mode" parameter. | |
| Top keyword volume prev | top_keyword_volume_prev | met | The search volume on the comparison date. | |
| Traffic diff | traffic_diff | met | The change in traffic between your selected dates. | |
| Traffic diff percent | traffic_diff_percent | met | The change in traffic between your selected dates, in percents. | |
| Value | value | met | The estimated value of a page's monthly organic search traffic, in cents. | |
| Value diff | value_diff | met | The change in traffic value between your selected dates. | |
| Value diff percent | value_diff_percent | met | The change in traffic value between your selected dates, in percents. | |
| Value merged | value_merged | met | The traffic value field optimized for sorting. | |
| Value prev | value_prev | met | The traffic value on the comparison date. | |
| Referring pages | refpages | met | The number of pages containing a link with a given anchor to your target. | |
| Organic keywords top 11+ | top11_plus | met | The total number of keywords that your target ranks for in the top 11+ organic search results. | |
| Top domain rating (DR) | top_domain_rating | met | The highest Domain Rating (DR) counted out of all referring domains. DR shows the strength of a website’s backlink profile compared to the others in our database on a 100-point scale. | |
| Organic keywords top 4-10 | top4_10 | met | The total number of keywords that your target ranks for in the top 4-10 organic search results. | |
| Difficulty | difficulty | met | An estimation of how hard it is to rank in the top 10 organic search results for a keyword on a 100-point scale. | |
| Global volume | global_volume | met | How many times per month, on average, people search for the target keyword across all countries in our database. | |
| CPS | cps | met | Clicks Per Search (or CPS) is the ratio of Clicks to Keyword Search volume. It shows how many different search results get clicked, on average, when people search for the target keyword in a given country. | |
| Searches pct clicks paid only | searches_pct_clicks_paid_only | met | The average monthly percentage of people who clicked only on paid results while searching for the target keyword. | |
| Clicks | clicks | met | The average monthly number of clicks on the search results that people make while searching for the target keyword. | |
| Searches pct clicks organic only | searches_pct_clicks_organic_only | met | The average monthly percentage of people who clicked only on organic results while searching for the target keyword. | |
| Traffic potential | traffic_potential | met | The sum of organic traffic that the #1 ranking page for your target keyword receives from all the keywords that it ranks for. | |
| Searches pct clicks organic and paid | searches_pct_clicks_organic_and_paid | met | The average monthly percentage of people who clicked on both organic and paid results while searching for the target keyword. | |
| Parent volume | parent_volume | met | The search volume of the parent topic. |