Semrush Analytics data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: DOMAIN_OVERVIEW_HISTORY

Ac
Display name Adwords cost
Description Estimated budget spent buying keywords in Google AdWords for ads that appear in paid search results (monthly estimation)
Field type metric
Data type int.number.value
Ad
Display name Adwords keywords
Description Keywords a website is buying in Google AdWords for ads that appear in paid search results
Field type metric
Data type int.number.value
At
Display name Adwords traffic
Description Traffic brought to the website via paid search results
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
date
Display name Date
Description Actual date
Field type dimension
Data type string.time.date
Dn
Display name Domain
Description A website`s position for a particular keyword in Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Oc
Display name Organic cost
Description Estimated price of organic keywords in Google AdWords
Field type metric
Data type int.number.value
Or
Display name Organic keywords
Description Keywords that bring users to a website via Google`s top 20 organic search results
Field type metric
Data type int.number.value
Ot
Display name Organic traffic
Description Traffic brought to a website via Google`s top 20 organic search results
Field type metric
Data type int.number.value
Rk
Display name Rank
Description The Semrush rating of the website`s popularity based on organic traffic coming from Google`s top 20 organic search results
Field type dimension
Data type int.number.value

Table: DOMAIN_VS_DOMAIN

Co
Display name Competition
Description Competitive density of advertisers using the given term for their ads. One (1) means the highest competition
Field type metric
Data type float.number.value
Cp
Display name CPC
Description Average price in US dollars advertisers pay for a user`s click on an ad containing a particular keyword (Google AdWords)
Field type metric
Data type float.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
Nq
Display name Search volume
Description The average number of times users have searched for a given keyword per month. We calculate this value over the last 12 months
Field type metric
Data type int.number.value
Nr
Display name Number of results
Description The total number of organic results returned for a given keyword at the last date of collection
Field type metric
Data type int.number.value
P0
Display name Domain1 pos
Description A position of the first queried domain for a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
P1
Display name Domain2 pos
Description A position of the second queried domain for a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
P2
Display name Domain3 pos
Description A position of the third queried domain for a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
P3
Display name Domain4 pos
Description A position of the fourth queried domain for a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
P4
Display name Domain5 pos
Description A position of the fifth queried domain for a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
Ph
Display name Keyword
Description Keyword bringing users to the website via Google`s top 20 organic search results
Field type dimension
Data type string.text.value

Table: DOMAIN_ORGANIC_SEARCH_KEYWORD

Co
Display name Competition
Description Competitive density of advertisers using the given term for their ads. One (1) means the highest competition
Field type metric
Data type float.number.value
Cp
Display name CPC
Description Average price in US dollars advertisers pay for a user`s click on an ad containing a particular keyword (Google AdWords)
Field type metric
Data type float.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
Dn
Display name Domain
Description A website`s position for a particular keyword in Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Nq
Display name Search volume
Description The average number of times users have searched for a given keyword per month. We calculate this value over the last 12 months
Field type metric
Data type int.number.value
Nr
Display name Number of results
Description The total number of organic results returned for a given keyword at the last date of collection
Field type metric
Data type int.number.value
Pd
Display name Position difference
Description The difference between the previous position a domain was earning with a particular keyword and its current position
Field type metric
Data type int.number.value
Ph
Display name Keyword
Description Keyword bringing users to the website via Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Po
Display name Position
Description Position a URL gets with a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
Pp
Display name Previous position
Description A position a domain gets with a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
Tc
Display name Traffic cost (%)
Description The total amount spent on keywords in Google AdWords for which the domain is ranking in search results
Field type metric
Data type float.number.percentage
Td
Display name Trends
Description The interest of searchers in a particular keyword during the last 12 months. This metric is based on changes in the number of queries per month
Field type dimension
Data type string.text.value
Tr
Display name Traffic (%)
Description The share of traffic driven to the website with a particular keyword for a specified period
Field type metric
Data type float.number.percentage
Ur
Display name URL
Description The URL of the target page (Backlinks)
Field type dimension
Data type string.text.url

Table: DOMAIN_PAID_SEARCH_KEYWORD

Ab
Display name Adwords block
Description The place on a SERP where an ad appeared (top, side, or bottom blocks)
Field type dimension
Data type string.text.value
Co
Display name Competition
Description Competitive density of advertisers using the given term for their ads. One (1) means the highest competition
Field type metric
Data type float.number.value
Cp
Display name CPC
Description Average price in US dollars advertisers pay for a user`s click on an ad containing a particular keyword (Google AdWords)
Field type metric
Data type float.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
Dn
Display name Domain
Description A website`s position for a particular keyword in Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Ds
Display name Description
Description Ad text
Field type dimension
Data type string.text.value
Nq
Display name Search volume
Description The average number of times users have searched for a given keyword per month. We calculate this value over the last 12 months
Field type metric
Data type int.number.value
Nr
Display name Number of results
Description The total number of organic results returned for a given keyword at the last date of collection
Field type metric
Data type int.number.value
Pd
Display name Position difference
Description The difference between the previous position a domain was earning with a particular keyword and its current position
Field type metric
Data type int.number.value
Ph
Display name Keyword
Description Keyword bringing users to the website via Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Po
Display name Position
Description Position a URL gets with a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
Pp
Display name Previous position
Description A position a domain gets with a particular keyword in Google`s top 20 organic or paid search results
Field type dimension
Data type int.number.value
Tc
Display name Traffic cost (%)
Description The total amount spent on keywords in Google AdWords for which the domain is ranking in search results
Field type metric
Data type float.number.percentage
Td
Display name Trends
Description The interest of searchers in a particular keyword during the last 12 months. This metric is based on changes in the number of queries per month
Field type dimension
Data type string.text.value
Tr
Display name Traffic (%)
Description The share of traffic driven to the website with a particular keyword for a specified period
Field type metric
Data type float.number.percentage
Tt
Display name Title
Description Ad title
Field type dimension
Data type string.text.value
Ur
Display name URL
Description The URL of the target page (Backlinks)
Field type dimension
Data type string.text.url
Vu
Display name Visible URL
Description This is the URL displayed on your Ad, identifying your site for users
Field type dimension
Data type string.text.url

Table: COMPETITOR_ORGANIC_SEARCH

Ad
Display name Adwords keywords
Description Keywords a website is buying in Google AdWords for ads that appear in paid search results
Field type metric
Data type int.number.value
Cr
Display name Competitor relevance
Description Competition level based on the total number of keywords of each domain and the number of keywords the domains have in common
Field type metric
Data type float.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
Dn
Display name Domain
Description A website`s position for a particular keyword in Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Np
Display name Common keywords
Description Common keywords that domains are ranking for in Google`s top 20 organic search results
Field type metric
Data type int.number.value
Oc
Display name Organic cost
Description Estimated price of organic keywords in Google AdWords
Field type metric
Data type int.number.value
Or
Display name Organic keywords
Description Keywords that bring users to a website via Google`s top 20 organic search results
Field type metric
Data type int.number.value
Ot
Display name Organic traffic
Description Traffic brought to a website via Google`s top 20 organic search results
Field type metric
Data type int.number.value

Table: COMPETITOR_PAID_SEARCH

Ac
Display name Adwords cost
Description Estimated budget spent buying keywords in Google AdWords for ads that appear in paid search results (monthly estimation)
Field type metric
Data type int.number.value
Ad
Display name Adwords keywords
Description Keywords a website is buying in Google AdWords for ads that appear in paid search results
Field type metric
Data type int.number.value
At
Display name Adwords traffic
Description Traffic brought to the website via paid search results
Field type metric
Data type int.number.value
Cr
Display name Competitor relevance
Description Competition level based on the total number of keywords of each domain and the number of keywords the domains have in common
Field type metric
Data type float.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
Dn
Display name Domain
Description A website`s position for a particular keyword in Google`s top 20 organic search results
Field type dimension
Data type string.text.value
Np
Display name Common keywords
Description Common keywords that domains are ranking for in Google`s top 20 organic search results
Field type metric
Data type int.number.value
Or
Display name Organic keywords
Description Keywords that bring users to a website via Google`s top 20 organic search results
Field type metric
Data type int.number.value

Table: KEYWORD

Co
Display name Competition
Description Competitive density of advertisers using the given term for their ads. One (1) means the highest competition
Field type metric
Data type float.number.value
Cp
Display name CPC
Description Average price in US dollars advertisers pay for a user`s click on an ad containing a particular keyword (Google AdWords)
Field type metric
Data type float.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
date
Display name Date
Description Actual date
Field type dimension
Data type string.time.date
Nq
Display name Search volume
Description The average number of times users have searched for a given keyword per month. We calculate this value over the last 12 months
Field type metric
Data type int.number.value
Nr
Display name Number of results
Description The total number of organic results returned for a given keyword at the last date of collection
Field type metric
Data type int.number.value
Ph
Display name Keyword
Description Keyword bringing users to the website via Google`s top 20 organic search results
Field type dimension
Data type string.text.value

Table: BACKLINK