Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| PROJECT | Date | date | dim | |
| Number of results | total | met | ||
| Last crawl | last_crawl | met | ||
| Keyword position | keyword_position | dim | ||
| Number of results | results_amount | met | ||
| Visibility index | visibility | met | ||
| Visibility difference | difference_visibility | met | ||
| Keyword amount (top 100) | all | met | ||
| Keyword amount change (top 100) | all_difference | met | ||
| Improved keyword amount (top 100) | all_improved | met | ||
| Declined keyword amount (top 100) | all_declined | met | ||
| Expired keyword amount (top 100) | all_left | met | ||
| New keyword amount (top 100) | all_entered | met | ||
| Keyword amount (top 3) | top3 | met | ||
| Keyword amount change (top 3) | top3_difference | met | ||
| Improved keyword amount (top 3) | top3_improved | met | ||
| Declined keyword amount (top 3) | top3_declined | met | ||
| Expired keyword amount (top 3) | top3_left | met | ||
| New keyword amount (top 3) | top3_entered | met | ||
| Keyword amount (top 10) | top10 | met | ||
| Keyword amount change (top 10) | top10_difference | met | ||
| Improved keyword amount (top 10) | top10_improved | met | ||
| Declined keyword amount (top 10) | top10_declined | met | ||
| Expired keyword amount (top 10) | top10_left | met | ||
| New keyword amount (top 10) | top10_entered | met | ||
| Keyword amount (top 20) | top20 | met | ||
| Keyword amount change (top 20) | top20_difference | met | ||
| Improved keyword amount (top 20) | top20_improved | met | ||
| Declined keyword amount (top 20) | top20_declined | met | ||
| Expired keyword amount (top 20) | top20_left | met | ||
| New keyword amount (top 20) | top20_entered | met | ||
| Keyword amount | keyword_amount | met | ||
| Date | date | dim | ||
| Keyword position | keyword_position | dim | ||
| Keyword domain | keyword_domain | dim | ||
| Keyword ID | Pi | dim | ||
| Keyword | Ph | dim | ||
| Keyword tags | Tg | dim | ||
| Avg price | Cp | dim | ||
| Avg searches per month | Nq | dim | ||
| Ranking type | Lt | dim | ||
| Landing URL | Lu | dim | ||
| Position at beginning | Be | met | ||
| Position at end | Fi | met | ||
| Position difference | Diff | met | ||
| Position difference 1-day | Diff1 | met | ||
| Position difference 1-week | Diff7 | met | ||
| Position difference 1-month | Diff30 | met | ||
| Absolute visibility | Vi | met | ||
| Date | date | dim | ||
| Keyword position | keyword_position | dim | ||
| Keyword domain | keyword_domain | dim | ||
| Keyword ID | Pi | dim | ||
| Keyword | Ph | dim | ||
| Keyword tags | Tg | dim | ||
| Avg price | Cp | dim | ||
| Avg searches per month | Nq | dim | ||
| Ranking type | Lt | dim | ||
| Landing URL | Lu | dim | ||
| Position at beginning | Be | met | ||
| Position at end | Fi | met | ||
| Position difference | Diff | met | ||
| Position difference 1-day | Diff1 | met | ||
| Position difference 1-week | Diff7 | met | ||
| Position difference 1-month | Diff30 | met | ||
| Date | date | dim | ||
| Competitor URL | Ur | dim | ||
| Keyword amount | keyword_amount | met | ||
| Visibility change | Cd | met | ||
| Visibility | Cl | met | ||
| Avg position | Av | met | ||
| Position deviation | Sq | met | ||
| Traffic (%) | Tr | met | ||
| Traffic Cost (%) | Tc | met | ||
| Date | date | dim | ||
| Competitor URL | Ur | dim | ||
| Keyword amount | keyword_amount | met | ||
| Visibility change | Cd | met | ||
| Visibility | Cl | met | ||
| Avg position | Av | met | ||
| Position deviation | Sq | met | ||
| Traffic (%) | Tr | met | ||
| Traffic Cost (%) | Tc | met | ||
| Date | date | dim | ||
| Number of results | total | met | ||
| Avg position | Av | met | ||
| Traffic (%) | Tr | met | ||
| Traffic Cost (%) | Tc | met | ||
| Absolute visibility | Vi | met | ||
| Relative visibility | Vr | met | ||
| Date | date | dim | ||
| Number of results | total | met | ||
| Avg position | Av | met | ||
| Traffic (%) | Tr | met | ||
| Traffic Cost (%) | Tc | met | ||
| Absolute visibility | Vi | met | ||
| Relative visibility | Vr | met | ||
| Crawl ID | snapshot_id | dim | ||
| Finish date | finish_date | dim | ||
| Issue ID | issue_id | dim | ||
| Issue title | issue_title | dim | ||
| Page title | title_page | dim | ||
| Info column | info_column | dim | ||
| URL | url_column | dim | ||
| Project | project_name | dim | ||
| Project ID | profile_id | dim | ||
| Project URL | url | dim | ||
| Audit status | status | dim | ||
| Scheme | scheme | dim | ||
| Excluded beta checks | excludedBetaChecks | dim | ||
| Issues | issue_detects | dim | ||
| Clicks to reach page | depth_clicks | dim | ||
| Subdomains crawled | crawlSubdomains | dim | ||
| Crawl-delay followed | respectCrawlDelay | dim | ||
| Crawl amp first | crawlAmpFirst | dim | ||
| Internal incoming links groups | internalIncomingLinksGroups | dim | ||
| Incoming links | incoming_links | dim | ||
| Marked with canonical | canonical | dim | ||
| With amp | withAmp | dim | ||
| Schedule day | scheduleDay | dim | ||
| Crawl source type | crawlSourceType | dim | ||
| Crawl source URL | crawlSourceUrl | dim | ||
| Precrawl error | precrawlError | dim | ||
| GA status | gaStatus | dim | ||
| GA settings | gaSettings | dim | ||
| Product group | productGroup | dim | ||
| User agent type | user_agent_type | dim | ||
| Last audit date | last_audit | dim | ||
| Last failed audit date | last_failed_audit | dim | ||
| Next scheduled audit date | next_audit | dim | ||
| Sitemaps report URL | sitemaps_reprUrl | dim | ||
| Sitemaps status | sitemaps_status | dim | ||
| Mask ALLOW | mask_allow | dim | ||
| Mask DISALLOW | mask_disallow | dim | ||
| Excluded URL parameters | removedParameters | dim | ||
| Excluded issues | excluded_checks | dim | ||
| Is notify | is_notify | dim | ||
| Found errors | errors | met | ||
| Found warnings | warnings | met | ||
| Found notices | notices | met | ||
| Broken pages | broken | met | ||
| Blocked pages | blocked | met | ||
| Redirecting pages | redirected | met | ||
| Healthy pages | healthy | met | ||
| Pages with issues | haveIssues | met | ||
| Issue amount difference | haveIssuesDelta | met | ||
| Twitter Card markups | markups_twitterCard | met | ||
| Open Graph markups | markups_openGraph | met | ||
| Schema.org markups | markups_schemaOrg | met | ||
| Microformat markups | markups_microfomats | met | ||
| No markups | markups_noMarkups | met | ||
| Crawlability total | crawlability_total | met | ||
| Crawlability non canonical pages | crawlability_nonCanonicalPages | met | ||
| Crawlability permanent redirects | crawlability_permanentRedirects | met | ||
| Crawlability redirect chains and loops | crawlability_redirectChainsAndLoops | met | ||
| Crawlability temporary redirects | crawlability_temporaryRedirects | met | ||
| Crawlability content duplicates | crawlability_contentDuplicates | met | ||
| Crawlability too large pages | crawlability_tooLargePages | met | ||
| Crawlability too slow pages | crawlability_tooSlowPages | met | ||
| Crawlability bot blocked | crawlability_botBlocked | met | ||
| Crawlability code 4xx | crawlability_code4xx | met | ||
| Crawlability code 5xx | crawlability_code5xx | met | ||
| Amp total | ampTotal | met | ||
| Pages crawled during running audit | running_pages_crawled | met | ||
| Crawled pages limit during running audit | running_pages_limit | met | ||
| Crawled pages | pages_crawled | met | ||
| Crawled pages limit | pages_limit | met | ||
| Total checks during last audit | total_checks | met | ||
| Hreflangs total pages | hreflangs_totalPages | met | ||
| Hreflangs bad pages | hreflangs_badPages | met | ||
| Hreflangs missing | hreflangs_missing | met | ||
| Xdefault | xdefault | met | ||
| Sitemaps crawled pages | sitemaps_crawledPages | met | ||
| Sitemaps total pages | sitemaps_totalPages | met | ||
| Sitemaps count | sitemaps_count | met | ||
| Canonicalization emtpy or without canonical link | canonicalization_emptyOrWithoutCanonicalLink | met | ||
| Canonicalization self canonical | canonicalization_selfCanonical | met | ||
| Canonicalization canonical to other page | canonicalization_canonicalToOtherPage | met | ||
| Error amount difference | errors_delta | met | ||
| Warning amount difference | warnings_delta | met | ||
| Notice amount difference | notices_delta | met | ||
| Crawl ID | snapshot_id | dim | ||
| Finish date | finish_date | dim | ||
| Website score | website_score | dim | ||
| Website score difference | website_score_delta | dim | ||
| Warning ID | warning_id | dim | ||
| Error ID | error_id | dim | ||
| Notice ID | notice_id | dim | ||
| Top issues | topIssues | dim | ||
| Status code group ID | status_code_group_id | dim | ||
| Fixed issue ID | fixed_issue_id | dim | ||
| New issue ID | new_issue_id | dim | ||
| Found errors | errors | met | ||
| Found warnings | warnings | met | ||
| Found notices | notices | met | ||
| Crawled pages | pages_crawled | met | ||
| Error amount difference | errors_delta | met | ||
| Warning amount difference | warnings_delta | met | ||
| Notice amount difference | notices_delta | met | ||
| Warning checks | warning_checks | met | ||
| Error checks | error_checks | met | ||
| Notice checks | notice_checks | met | ||
| Status code count | status_code_count | met | ||
| Fixed issue count | fixed_issue_count | met | ||
| New issue count | new_issue_count | met | ||
| Issue ID | issue_id | dim | ||
| Page title | title_page | dim | ||
| First seen | discovered | dim | ||
| Page ID | page_id | dim | ||
| Webpage URL | source_url | dim | ||
| Page ID | page_id | dim | ||
| Webpage URL | source_url | dim | ||
| Page title | title_page | dim | ||
| Markups | markups_string | dim | ||
| Clicks to reach page | depth_clicks | dim | ||
| Incoming links | incoming_links | dim | ||
| Canonical | canonical_url | dim | ||
| Canonical source | canonical_sources | dim | ||
| Warning ID | warning_id | dim | ||
| Error ID | error_id | dim | ||
| Notice ID | notice_id | dim | ||
| Page ID | page_id | dim | ||
| Webpage URL | source_url | dim | ||
| Page weight | page_weight | dim | ||
| Error discovered | error_discovered | dim | ||
| Error description | error_info | dim | ||
| Error target URL | error_target_url | dim | ||
| Warning discovered | warning_discovered | dim | ||
| Warning description | warning_info | dim | ||
| Warning target URL | warning_target_url | dim | ||
| Notice discovered | notice_discovered | dim | ||
| Notice description | notice_info | dim | ||
| Notice target URL | notice_target_url | dim | ||
| Is auditing | isAuditing | dim | ||
| Canonicalization | canonicalization | dim | ||
| Page group | pageGroup | dim | ||
| AJAX type | ajaxType | dim | ||
| GA | ga | dim | ||
| Found errors | errors | met | ||
| Found warnings | warnings | met | ||
| Found notices | notices | met | ||
| Page load time | pageLoadTime | met | ||
| Crawl ID | snapshot_id | dim | ||
| Finish date | finish_date | dim | ||
| Excluded issues | excluded_checks | dim | ||
| Website score | website_score | dim | ||
| Website score difference | website_score_delta | dim | ||
| Warning ID | warning_id | dim | ||
| Error ID | error_id | dim | ||
| Notice ID | notice_id | dim | ||
| Top issues | topIssues | dim | ||
| Status code group ID | status_code_group_id | dim | ||
| Fixed issue ID | fixed_issue_id | dim | ||
| Found errors | errors | met | ||
| Found warnings | warnings | met | ||
| Found notices | notices | met | ||
| Crawled pages | pages_crawled | met | ||
| Crawled pages limit | pages_limit | met | ||
| Error amount difference | errors_delta | met | ||
| Warning amount difference | warnings_delta | met | ||
| Notice amount difference | notices_delta | met | ||
| Warning checks | warning_checks | met | ||
| Error checks | error_checks | met | ||
| Notice checks | notice_checks | met | ||
| Status code count | status_code_count | met | ||
| Fixed issue count | fixed_issue_count | met |