Ahrefs data warehouse table groups

Search fields

Table: OVERVIEW

ahrefs_rank

Display name	Ahrefs rank
Description	The strength of your target's backlink profile compared to the other websites in our database, with rank #1 being the strongest
Field type	metric
Data type	int.number.value

all_time

Display name	Backlinks all time
Description	The total number of links from other websites pointing to your target for all time
Field type	metric
Data type	int.number.value

all_time_refdomains

Display name	Referring domains all time
Description	The total number of unique domains linking to your target for all time
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

domain_rating

Display name	Domain rating (DR)
Description	The strength of a domain's backlink profile compared to the others in our database on a 100-point scale
Field type	metric
Data type	float.number.value

live

Display name	Backlinks count
Description	The total number of links from other websites pointing to your target
Field type	metric
Data type	int.number.value

live_refdomains

Display name	Referring domains
Description	The total number of unique domains linking to your target
Field type	metric
Data type	int.number.value

org_cost

Display name	Organic cost
Description	The estimated value of your target's monthly organic search traffic
Field type	metric
Data type	float.currency.value

org_keywords

Display name	Organic keywords
Description	The total number of keywords that your target ranks for in the top 100 organic search results
Field type	metric
Data type	int.number.value

org_keywords_1_3

Display name	Organic keywords top 3
Description	The total number of keywords that your target ranks for in the top 3 organic search results
Field type	metric
Data type	int.number.value

org_traffic

Display name	Organic traffic
Description	The estimated number of monthly visitors that your target gets from organic search
Field type	metric
Data type	int.number.value

paid_cost

Display name	Paid cost
Description	The estimated cost of your target's monthly paid search traffic
Field type	metric
Data type	float.currency.value

paid_keywords

Display name	Paid keywords
Description	The total number of keywords that your target ranks for in paid search results
Field type	metric
Data type	int.number.value

paid_pages

Display name	Paid pages
Description	The total number of pages from a target ranking in paid search results
Field type	metric
Data type	int.number.value

paid_traffic

Display name	Paid traffic
Description	The estimated number of monthly visitors that your target gets from paid search
Field type	metric
Data type	int.number.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

today

Display name	Today
Description	Today's date, e.g. 2017-01-31
Field type	dimension
Data type	string.time.date

url_rating

Display name	URL rating (UR)
Description	The strength of your target page's backlink profile compared to the other websites in our database on a 100-point logarithmic scale
Field type	metric
Data type	float.number.value

Table: BACKLINKS

ahrefs_rank_source

Display name	Ahrefs rank (AR)
Description	The strength of the referring domain's backlink profile compared to the other websites in our database, with rank #1 being the strongest
Field type	metric
Data type	int.number.value

ahrefs_rank_target

Display name	Target domain rank
Description	The strength of the target domain's backlink profile compared to the other websites in our database, with rank #1 being the strongest
Field type	metric
Data type	int.number.value

alt

Display name	Alt text
Description	The alt attribute of the link
Field type	dimension
Data type	string.text.value

anchor

Display name	Anchor
Description	The clickable words in a link that point to a URL
Field type	dimension
Data type	string.text.value

broken_redirect_new_target

Display name	New destination of modified redirect
Description	The new destination of a modified redirect
Field type	dimension
Data type	string.text.url

broken_redirect_reason

Display name	Reason redirect was considered broken
Description	The reason the redirect was considered broken during the last crawl
Field type	dimension
Data type	string.text.value

broken_redirect_source

Display name	Referring domain of broken redirect
Description	The redirecting URL that was modified, causing the redirect to become broken
Field type	dimension
Data type	string.text.url

class_c

Display name	Class C
Description	The number of unique class_c subnets linking to the referring page
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

discovered_status

Display name	Discovered status
Description	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
Field type	dimension
Data type	string.text.value

domain_rating_source

Display name	Domain rating (DR)
Description	The strength of the referring domain's backlink profile compared to the others in our database on a 100-point scale
Field type	metric
Data type	float.number.value

domain_rating_target

Display name	Target domain rating
Description	The strength of the referring domain's backlink profile compared to the others in our database on a 100-point scale
Field type	metric
Data type	float.number.value

drop_reason

Display name	Drop reason
Description	The reason we removed the link from our index
Field type	dimension
Data type	string.text.value

encoding

Display name	Character encoding
Description	The character set encoding of the referring page HTML
Field type	dimension
Data type	string.text.value

first_seen

Display name	First seen page URL
Description	The date the referring page URL was first discovered
Field type	dimension
Data type	string.time.datetime

first_seen_link

Display name	First seen
Description	The date we first found a backlink to your target on a given referring page
Field type	dimension
Data type	string.time.datetime

http_code

Display name	Referring page http code
Description	The return code from HTTP protocol returned during the referring page crawl
Field type	dimension
Data type	string.text.value

http_crawl

Display name	HTTP crawl status
Description	The link was discovered without executing javascript and rendering the page
Field type	dimension
Data type	bool

ip_source

Display name	Referring domain IP address
Description	The referring domain IP address
Field type	dimension
Data type	string.text.value

is_alternate

Display name	Alternate link
Description	The link with the rel=“alternate” attribute
Field type	dimension
Data type	bool

is_canonical

Display name	Canonical link
Description	The link with the rel=“canonical” attribute
Field type	dimension
Data type	bool

is_content

Display name	Content
Description	The link was found in the biggest piece of content on the page
Field type	dimension
Data type	bool

is_dofollow

Display name	Dofollow link
Description	The link has no special nofollow attribute
Field type	dimension
Data type	bool

is_form

Display name	Form link
Description	The link was found in a form HTML tag
Field type	dimension
Data type	bool

is_frame

Display name	Framed link
Description	The link was found in an iframe HTML tag
Field type	dimension
Data type	bool

is_image

Display name	Image link
Description	The link is a regular link that has an image inside their href attribute
Field type	dimension
Data type	bool

is_lost

Display name	Lost link
Description	The link currently does not exist anymore
Field type	dimension
Data type	bool

is_new

Display name	New link
Description	The link was discovered on the last crawl
Field type	dimension
Data type	bool

is_nofollow

Display name	Nofollow
Description	The link or the referring page has the nofollow attribute set
Field type	dimension
Data type	bool

is_redirect

Display name	Redirect
Description	The link pointing to your target via a redirect
Field type	dimension
Data type	bool

is_redirect_lost

Display name	Lost redirect
Description	The redirected link currently does not exist anymore
Field type	dimension
Data type	bool

is_root_source

Display name	Root domain referring link
Description	The referring domain name is a root domain name
Field type	dimension
Data type	bool

is_root_target

Display name	Root domain target link
Description	The target domain name is a root domain name
Field type	dimension
Data type	bool

is_rss

Display name	RSS link
Description	The link was found in an RSS feed
Field type	dimension
Data type	bool

is_sponsored

Display name	Sponsored
Description	The link has the Sponsored attribute set in the referring page HTML
Field type	dimension
Data type	bool

is_text

Display name	Text link
Description	The link is a standard href hyperlink
Field type	dimension
Data type	bool

is_ugc

Display name	UGC
Description	The link has the User Generated Content attribute set in the referring page HTML
Field type	dimension
Data type	bool

js_crawl

Display name	Rendered
Description	The link was discovered after executing javascript and rendering the page
Field type	dimension
Data type	bool

languages

Display name	Languages
Description	The languages listed in the referring page metadata or detected by the crawler to appear in the HTML
Field type	dimension
Data type	string.text.value

last_seen

Display name	Lost
Description	The date we discovered that the link was lost
Field type	dimension
Data type	string.time.datetime

last_visited

Display name	Last seen
Description	The date we last verified a live link to your target page
Field type	dimension
Data type	string.time.datetime

limit

Display name	Limit
Field type	dimension
Data type	string.text.value

link_group_count

Display name	Link group count
Description	The number of backlinks that were grouped together based on the aggregation parameter. This field cannot be used with aggregation 'all'
Field type	metric
Data type	int.number.value

link_type

Display name	Type
Description	The kind of the backlink
Field type	dimension
Data type	string.text.value

linked_domains_source_domain

Display name	Linked domains in referring domain
Description	The number of unique root domains linked from the referring domain
Field type	metric
Data type	int.number.value

linked_domains_source_page

Display name	Linked domains
Description	The number of unique root domains linked from the referring page
Field type	metric
Data type	int.number.value

linked_domains_target_domain

Display name	Linked domains in target domain
Description	The number of unique root domains linked from the target domain
Field type	metric
Data type	int.number.value

links_external

Display name	External links
Description	The number of external links from the referring page
Field type	metric
Data type	int.number.value

links_internal

Display name	Internal links
Description	The number of internal links from the referring page
Field type	metric
Data type	int.number.value

lookback

Display name	Lookback window
Field type	dimension
Data type	string.text.value

lost_reason

Display name	Lost status
Description	The reason the link was lost during the last crawl
Field type	dimension
Data type	string.text.value

mode

Display name	Mode
Field type	dimension
Data type	string.text.value

name_source

Display name	Referring domain name
Description	The complete referring domain name, including subdomains
Field type	dimension
Data type	string.text.value

name_target

Display name	Target domain name
Description	The complete target domain name, including subdomains
Field type	dimension
Data type	string.text.value

noindex

Display name	Noindex status
Description	The referring page has the noindex meta attribute
Field type	dimension
Data type	bool

page_size

Display name	Page size
Description	The size in bytes of the referring page content
Field type	metric
Data type	int.number.value

port_source

Display name	Referring domain port
Description	The network port of the referring page URL
Field type	dimension
Data type	string.text.value

port_target

Display name	Target domain port
Description	The network port of the target page URL
Field type	dimension
Data type	string.text.value

positions

Display name	Keywords
Description	The number of keywords that the referring page ranks for in the top 100 positions
Field type	metric
Data type	int.number.value

powered_by

Display name	Platform
Description	Web technologies used to build and serve the referring page content
Field type	dimension
Data type	string.text.value

protocol

Display name	Protocol
Field type	dimension
Data type	string.text.value

redirect_code

Display name	Redirect code
Description	The HTTP status code of a referring page pointing to your target via a redirect
Field type	dimension
Data type	string.text.value

redirect_kind

Display name	Redirect kind
Description	The HTTP status codes returned by the target redirecting URL or redirect chain
Field type	dimension
Data type	string.text.value

refdomains_source

Display name	Referring domains
Description	The number of unique referring domains linking to the referring page
Field type	metric
Data type	int.number.value

refdomains_source_domain

Display name	Number of referring domains
Description	The number of unique referring domains linking to the referring domain
Field type	metric
Data type	int.number.value

refdomains_target_domain

Display name	Number of referencing domains
Description	The number of unique referring domains linking to the target domain
Field type	metric
Data type	int.number.value

root_name_source

Display name	Referring domain root
Description	The root domain name of the referring domain, not including subdomains
Field type	dimension
Data type	string.text.value

root_name_target

Display name	Target domain root
Description	The root domain name of the target domain, not including subdomains
Field type	dimension
Data type	string.text.value

snippet_left

Display name	Left context
Description	The snippet of text appearing just before the link
Field type	dimension
Data type	string.text.value

snippet_right

Display name	Right context
Description	The snippet of text appearing just after the link
Field type	dimension
Data type	string.text.value

source_page_author

Display name	Referring page author
Description	The author of the referring page
Field type	dimension
Data type	string.text.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

title

Display name	Referring page
Description	The html title of the referring page
Field type	dimension
Data type	string.text.value

tld_class_source

Display name	TLD class of referring domain
Description	The top level domain class of the referring domain
Field type	dimension
Data type	string.text.value

tld_class_target

Display name	TLD class of target domain
Description	The top level domain class of the target domain
Field type	dimension
Data type	string.text.value

traffic

Display name	Page traffic
Description	The referring page's estimated monthly organic traffic from search
Field type	metric
Data type	int.number.value

traffic_domain

Display name	Domain traffic
Description	The referring domain's estimated monthly organic traffic from search
Field type	metric
Data type	int.number.value

url_from

Display name	Referring page URL
Description	The URL of the page containing a link to your target
Field type	dimension
Data type	string.text.url

url_from_plain

Display name	Plain referring URL
Description	The referring page URL optimized for use as a filter
Field type	dimension
Data type	string.text.url

url_rating_source

Display name	URL rating (UR)
Description	The strength of the referring page's backlink profile compared to the others in our database on a 100-point scale
Field type	metric
Data type	float.number.value

url_redirect

Display name	Redirect URL(s)
Description	The target redirecting URL or redirect chain
Field type	dimension
Data type	string.text.url

url_to

Display name	Target URL
Description	The URL the backlink points to
Field type	dimension
Data type	string.text.url

url_to_plain

Display name	Plain target URL
Description	The target page URL optimized for use as a filter
Field type	dimension
Data type	string.text.url

Table: REF_DOMAIN

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

dofollow_linked_domains

Display name	Dofollow linked domains
Description	The number of unique root domains with dofollow links linked from the referring domain
Field type	metric
Data type	int.number.value

dofollow_links

Display name	Dofollow links
Description	The number of links from the referring domain to your target that don't have the “nofollow” attribute
Field type	metric
Data type	int.number.value

dofollow_refdomains

Display name	Dofollow ref. domains
Description	The number of unique domains with dofollow links to the referring domain
Field type	metric
Data type	int.number.value

domain

Display name	Domain
Description	A referring domain that has at least one link to your target
Field type	dimension
Data type	string.text.url

domain_rating

Display name	Domain rating (DR)
Description	The strength of a domain's backlink profile compared to the others in our database on a 100-point scale
Field type	metric
Data type	float.number.value

first_seen

Display name	First seen page URL
Description	The date the referring page URL was first discovered
Field type	dimension
Data type	string.time.datetime

ip_source

Display name	Referring domain IP address
Description	The referring domain IP address
Field type	dimension
Data type	string.text.value

is_root_domain

Display name	Root domain
Description	The domain name is a root domain name
Field type	dimension
Data type	bool

last_seen

Display name	Lost
Description	The date we discovered that the link was lost
Field type	dimension
Data type	string.time.datetime

limit

Display name	Limit
Field type	dimension
Data type	string.text.value

links_to_target

Display name	Links to target
Description	The number of backlinks from the referring domain to your target
Field type	metric
Data type	int.number.value

lost_links

Display name	Lost links
Description	The number of backlinks lost from the referring domain for the selected time period
Field type	metric
Data type	int.number.value

mode

Display name	Mode
Field type	dimension
Data type	string.text.value

new_links

Display name	New links
Description	The number of new backlinks found from the referring domain for the selected time period
Field type	metric
Data type	int.number.value

protocol

Display name	Protocol
Field type	dimension
Data type	string.text.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

traffic_domain

Display name	Domain traffic
Description	The referring domain's estimated monthly organic traffic from search
Field type	metric
Data type	int.number.value

Table: ORGANIC_KEYWORD

best_position

Display name	Position
Description	The top position your target ranks for in the organic search results for a keyword
Field type	metric
Data type	int.number.value

best_position_has_video

Display name	Best position has video
Description	The top position has a video
Field type	dimension
Data type	bool

best_position_set

Display name	Best position set
Description	The ranking group of the top position
Field type	dimension
Data type	string.text.value

best_position_url

Display name	URL
Description	The ranking URL in organic search results
Field type	dimension
Data type	string.text.url

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

is_best_position_set_top_11_50

Display name	Is best position set top 11 50
Description	The ranking group of the top position is 11-50
Field type	dimension
Data type	bool

is_best_position_set_top_3

Display name	Is best position set top 3
Description	The ranking group of the top position is Top 3
Field type	dimension
Data type	bool

keyword

Display name	Keyword
Description	The keyword your target ranks for
Field type	dimension
Data type	string.text.value

keyword_difficulty

Display name	Keyword difficulty (KD)
Description	An estimation of how hard it is to rank in the top 10 organic search results for a keyword on a 100-point scale
Field type	metric
Data type	int.number.value

language

Display name	Language (SERP)
Description	The SERP language
Field type	dimension
Data type	string.text.value

last_update

Display name	Updated
Description	The date when we last checked search engine results for a keyword
Field type	dimension
Data type	string.time.datetime

limit

Display name	Limit
Field type	dimension
Data type	string.text.value

mode

Display name	Mode
Field type	dimension
Data type	string.text.value

protocol

Display name	Protocol
Field type	dimension
Data type	string.text.value

serp_features

Display name	SERP feature items
Description	The SERP features that appear in search results for a keyword
Field type	dimension
Data type	string.text.value

serp_features_count

Display name	SERP features (SF)
Description	The number of SERP features that appear in search results for a keyword
Field type	metric
Data type	int.number.value

serp_target_main_positions_count

Display name	SERP target main positions count
Description	The number of target URLs ranking for a keyword excluding positions in Sitelinks, Top stories, Image packs, and Tweets
Field type	metric
Data type	int.number.value

serp_target_positions_count

Display name	SERP target positions count
Description	The number of target URLs ranking for a keyword
Field type	metric
Data type	int.number.value

sum_paid_traffic

Display name	Paid traffic
Description	An estimation of the number of monthly visits that your target gets from paid search for a keyword
Field type	metric
Data type	int.number.value

sum_traffic

Display name	Organic traffic
Description	An estimation of the number of monthly visitors that your target gets from organic search for a keyword
Field type	metric
Data type	int.number.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

volume

Display name	Volume
Description	An estimation of the number of searches for a keyword over the latest month
Field type	metric
Data type	int.number.value

words

Display name	Words
Description	The number of words in a keyword
Field type	metric
Data type	int.number.value

Table: TOP_PAGE

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

keywords

Display name	Keywords
Description	The total number of keywords that your target ranks for in the top 100 organic search results
Field type	metric
Data type	int.number.value

limit

Display name	Limit
Field type	dimension
Data type	string.text.value

mode

Display name	Mode
Field type	dimension
Data type	string.text.value

protocol

Display name	Protocol
Field type	dimension
Data type	string.text.value

raw_url

Display name	Raw URL
Description	The ranking page URL in encoded format
Field type	dimension
Data type	string.text.url

sum_traffic

Display name	Organic traffic
Description	An estimation of the number of monthly visitors that your target gets from organic search for a keyword
Field type	metric
Data type	int.number.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

top_keyword

Display name	Top keywords
Description	The keyword that brings the most organic traffic to a page
Field type	dimension
Data type	string.text.value

top_keyword_best_position

Display name	Top keyword best position
Description	The ranking position that a page holds for its top keyword
Field type	metric
Data type	int.number.value

top_keyword_best_position_kind

Display name	Top keyword best position kind
Description	The kind of the top position: organic, paid or a SERP feature
Field type	dimension
Data type	string.text.value

top_keyword_best_position_title

Display name	Top keyword best position title
Description	The title displayed for the page in its top keyword's SERP
Field type	dimension
Data type	string.text.value

top_keyword_country

Display name	Top keyword country
Description	The country in which a page ranks for its top keyword
Field type	dimension
Data type	string.geo.country

top_keyword_volume

Display name	Top keyword volume
Description	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
Field type	metric
Data type	int.number.value

url

Display name	URL
Description	The ranking page URL
Field type	dimension
Data type	string.text.url

value

Display name	Value
Description	The estimated value of a page's monthly organic search traffic, in cents
Field type	metric
Data type	int.currency.value

Table: PAID_PAGE

ads_count

Display name	Ads count
Description	The number of unique ads with a page
Field type	metric
Data type	int.number.value

dataSourceName

Display name	Data source
Description	The name of the source for this data, as listed on supermetrics.com/docs
Field type	dimension
Data type	string.text.value

keywords

Display name	Keywords
Description	The total number of keywords that your target ranks for in the top 100 organic search results
Field type	metric
Data type	int.number.value

limit

Display name	Limit
Field type	dimension
Data type	string.text.value

mode

Display name	Mode
Field type	dimension
Data type	string.text.value

protocol

Display name	Protocol
Field type	dimension
Data type	string.text.value

raw_url

Display name	Raw URL
Description	The ranking page URL in encoded format
Field type	dimension
Data type	string.text.url

sum_traffic

Display name	Organic traffic
Description	An estimation of the number of monthly visitors that your target gets from organic search for a keyword
Field type	metric
Data type	int.number.value

target_url

Display name	Target URL (input)
Description	Target URL
Field type	dimension
Data type	string.text.url

top_keyword

Display name	Top keywords
Description	The keyword that brings the most organic traffic to a page
Field type	dimension
Data type	string.text.value

top_keyword_best_position

Display name	Top keyword best position
Description	The ranking position that a page holds for its top keyword
Field type	metric
Data type	int.number.value

top_keyword_best_position_kind

Display name	Top keyword best position kind
Description	The kind of the top position: organic, paid or a SERP feature
Field type	dimension
Data type	string.text.value

top_keyword_best_position_title

Display name	Top keyword best position title
Description	The title displayed for the page in its top keyword's SERP
Field type	dimension
Data type	string.text.value

top_keyword_country

Display name	Top keyword country
Description	The country in which a page ranks for its top keyword
Field type	dimension
Data type	string.geo.country

top_keyword_volume

Display name	Top keyword volume
Description	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
Field type	metric
Data type	int.number.value

url

Display name	URL
Description	The ranking page URL
Field type	dimension
Data type	string.text.url

value

Display name	Value
Description	The estimated value of a page's monthly organic search traffic, in cents
Field type	metric
Data type	int.currency.value