Semrush Projects data warehouse table groups

Prev Next

Table: TRACKING_CAMPAIGN_DATES

dataSourceName
date
last_crawl
today
total

Table: TRACKING_OVERVIEW_ORGANIC

all
all_declined
all_difference
all_entered
all_improved
all_left
dataSourceName
difference_visibility
keyword_amount
keyword_position
results_amount
today
top10
top10_declined
top10_difference
top10_entered
top10_improved
top10_left
top20
top20_declined
top20_difference
top20_entered
top20_improved
top20_left
top3
top3_declined
top3_difference
top3_entered
top3_improved
top3_left
visibility

Table: TRACKING_POSITION_ORGANIC

Be
Cp
dataSourceName
date
Diff
Diff1
Diff30
Diff7
Fi
keyword_domain
keyword_position
Lt
Lu
Nq
Ph
Pi
Tg
today
Vi

Table: TRACKING_POSITION_ADWORDS

Be
Cp
dataSourceName
date
Diff
Diff1
Diff30
Diff7
Fi
keyword_domain
keyword_position
Lt
Lu
Nq
Ph
Pi
Tg
today

Table: TRACKING_COMPETITORS_ORGANIC

Av
Cd
Cl
dataSourceName
date
keyword_amount
Sq
Tc
today
Tr
Ur

Table: TRACKING_COMPETITORS_ADWORDS

Av
Cd
Cl
dataSourceName
date
keyword_amount
Sq
Tc
today
Tr
Ur

Table: TRACKING_VISIBILITY_ORGANIC

Av
dataSourceName
date
Tc
today
total
Tr
Vi
Vr

Table: TRACKING_VISIBILITY_ADWORDS

Av
dataSourceName
date
Tc
today
total
Tr
Vi
Vr

Table: SITEAUDIT_SNAPSHOT_LIST

dataSourceName
finish_date
snapshot_id
today

Table: SITEAUDIT_META

dataSourceName
info_column
issue_id
issue_title
title_page
today
url_column

Table: SITEAUDIT_CAMPAIGN_INFO

ampTotal
blocked
broken
canonical
canonicalization_canonicalToOtherPage
canonicalization_selfCanonical
crawlability_botBlocked
crawlability_code4xx
crawlability_code5xx
crawlability_contentDuplicates
crawlability_nonCanonicalPages
crawlability_permanentRedirects
crawlability_redirectChainsAndLoops
crawlability_temporaryRedirects
crawlability_tooLargePages
crawlability_tooSlowPages
crawlability_total
crawlAmpFirst
crawlSourceType
crawlSourceUrl
crawlSubdomains
dataSourceName
depth_clicks
errors
errors_delta
excluded_checks
excludedBetaChecks
gaSettings
gaStatus
haveIssues
haveIssuesDelta
healthy
hreflangs_badPages
hreflangs_missing
hreflangs_totalPages
internalIncomingLinksGroups
is_notify
issue_detects
last_audit
last_failed_audit
markups_microfomats
markups_noMarkups
markups_openGraph
markups_schemaOrg
markups_twitterCard
mask_allow
mask_disallow
next_audit
notices
notices_delta
pages_crawled
pages_limit
precrawlError
productGroup
profile_id
project_name
redirected
removedParameters
respectCrawlDelay
running_pages_crawled
running_pages_limit
scheduleDay
scheme
sitemaps_count
sitemaps_crawledPages
sitemaps_reprUrl
sitemaps_status
sitemaps_totalPages
status
today
total_checks
url
user_agent_type
warnings
warnings_delta
withAmp
xdefault

Table: SITEAUDIT_SNAPSHOT_INFO

dataSourceName
error_checks
error_id
errors
errors_delta
finish_date
fixed_issue_count
fixed_issue_id
new_issue_count
new_issue_id
notice_checks
notice_id
notices
notices_delta
pages_crawled
snapshot_id
status_code_count
status_code_group_id
today
topIssues
warning_checks
warning_id
warnings
warnings_delta
website_score
website_score_delta

Table: SITEAUDIT_SNAPSHOT_ISSUE

dataSourceName
discovered
issue_id
page_id
source_url
title_page
today

Table: SITEAUDIT_PAGE_LIST

dataSourceName
page_id
source_url
today

Table: SITEAUDIT_PAGE_INFO

ajaxType
canonical_sources
canonical_url
canonicalization
dataSourceName
depth_clicks
error_discovered
error_id
error_info
error_target_url
errors
ga
isAuditing
markups_string
notice_discovered
notice_id
notice_info
notice_target_url
notices
page_id
page_weight
pageGroup
pageLoadTime
source_url
title_page
today
warning_discovered
warning_id
warning_info
warning_target_url
warnings

Table: SITEAUDIT_CAMPAIGN_HISTORY

dataSourceName
error_checks
error_id
errors
errors_delta
excluded_checks
finish_date
fixed_issue_count
fixed_issue_id
notice_checks
notice_id
notices
notices_delta
pages_crawled
pages_limit
snapshot_id
status_code_count
status_code_group_id
today
topIssues
warning_checks
warning_id
warnings
warnings_delta
website_score
website_score_delta

Table: ORGPOSITION