Moz data warehouse table groups

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

Table: URLMETRICS

CanonicalURL
Display name Canonical URL
Field type dimension
Data type string.text.url
DomainAuthority
Display name Domain Authority
Field type metric
Data type float.number.value
HTTPcode
Display name HTTP Status Code
Field type dimension
Data type int.number.value
MozRankSubdomain
Display name MozRank for subdomain
Field type metric
Data type float.number.value
MozRankSubdomainRaw
Display name MozRank for subdomain (raw score)
Field type metric
Data type float.number.value
MozRankURL
Display name MozRank for URL
Field type metric
Data type int.number.value
MozRankURLraw
Display name MozRank for URL (raw score)
Field type metric
Data type float.number.value
PageAuthority
Display name Page Authority
Field type metric
Data type float.number.value
PageTitle
Display name Page title
Field type dimension
Data type string.text.value
TimeLastCrawled
Display name Time last crawled
Field type dimension
Data type string.time.date

Table: LINKMETRICS

anchor
Display name Anchor text
Field type dimension
Data type string.text.value
anchornorm
Display name Anchor text without markup
Field type dimension
Data type string.text.value
CanonicalURL
Display name Canonical URL
Field type dimension
Data type string.text.url
CanonicalURL_target
Display name Canonical URL (target)
Field type dimension
Data type string.text.url
DomainAuthority
Display name Domain Authority
Field type metric
Data type float.number.value
DomainAuthority_target
Display name Domain Authority (target)
Field type metric
Data type float.number.value
HTTPcode
Display name HTTP Status Code
Field type dimension
Data type int.number.value
HTTPcode_target
Display name HTTP Status Code (target)
Field type dimension
Data type int.number.value
link_img
Display name Link property: Img
Field type dimension
Data type bool
link_nofollow
Display name Link property: no follow
Field type dimension
Data type bool
link_properties_combined
Display name Link properties
Field type dimension
Data type string.text.value
link_relcanonical
Display name Link property: rel canonical
Field type dimension
Data type bool
link_samerootdomain
Display name Link property: same root domain
Field type dimension
Data type bool
link_samesubdomain
Display name Link property: same subdomain
Field type dimension
Data type bool
Links_target
Display name Links (target)
Field type metric
Data type int.number.value
MozRankSubdomain
Display name MozRank for subdomain
Field type metric
Data type float.number.value
MozRankSubdomain_target
Display name MozRank for subdomain (target)
Field type metric
Data type float.number.value
MozRankSubdomainRaw
Display name MozRank for subdomain (raw score)
Field type metric
Data type float.number.value
MozRankSubdomainRaw_target
Display name MozRank for subdomain (raw score) (target)
Field type metric
Data type float.number.value
MozRankURL
Display name MozRank for URL
Field type metric
Data type int.number.value
MozRankURL_target
Display name MozRank for URL (target)
Field type metric
Data type float.number.value
MozRankURLraw
Display name MozRank for URL (raw score)
Field type metric
Data type float.number.value
MozRankURLraw_target
Display name MozRank for URL (raw score) (target)
Field type metric
Data type float.number.value
PageAuthority
Display name Page Authority
Field type metric
Data type float.number.value
PageAuthority_target
Display name Page Authority (target)
Field type metric
Data type float.number.value
PageTitle
Display name Page title
Field type dimension
Data type string.text.value
PageTitle_target
Display name Page title (target)
Field type dimension
Data type string.text.value
RequestURL
Display name Request URL
Field type dimension
Data type string.text.url
TimeLastCrawled
Display name Time last crawled
Field type dimension
Data type string.time.date
TimeLastCrawled_target
Display name Time last crawled (target)
Field type dimension
Data type string.time.date