Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for Semrush Projects

143 metrics and 123 dimensions available

CategoryFieldCodeTypeDescription
PROJECTDatedatedim
Number of resultstotalmet
Last crawllast_crawlmet
Keyword positionkeyword_positiondim
Number of resultsresults_amountmet
Visibility indexvisibilitymet
Visibility differencedifference_visibilitymet
Keyword amount (top 100)allmet
Keyword amount change (top 100)all_differencemet
Improved keyword amount (top 100)all_improvedmet
Declined keyword amount (top 100)all_declinedmet
Expired keyword amount (top 100)all_leftmet
New keyword amount (top 100)all_enteredmet
Keyword amount (top 3)top3met
Keyword amount change (top 3)top3_differencemet
Improved keyword amount (top 3)top3_improvedmet
Declined keyword amount (top 3)top3_declinedmet
Expired keyword amount (top 3)top3_leftmet
New keyword amount (top 3)top3_enteredmet
Keyword amount (top 10)top10met
Keyword amount change (top 10)top10_differencemet
Improved keyword amount (top 10)top10_improvedmet
Declined keyword amount (top 10)top10_declinedmet
Expired keyword amount (top 10)top10_leftmet
New keyword amount (top 10)top10_enteredmet
Keyword amount (top 20)top20met
Keyword amount change (top 20)top20_differencemet
Improved keyword amount (top 20)top20_improvedmet
Declined keyword amount (top 20)top20_declinedmet
Expired keyword amount (top 20)top20_leftmet
New keyword amount (top 20)top20_enteredmet
Keyword amountkeyword_amountmet
Datedatedim
Keyword positionkeyword_positiondim
Keyword domainkeyword_domaindim
Keyword IDPidim
KeywordPhdim
Keyword tagsTgdim
Avg priceCpdim
Avg searches per monthNqdim
Ranking typeLtdim
Landing URLLudim
Position at beginningBemet
Position at endFimet
Position differenceDiffmet
Position difference 1-dayDiff1met
Position difference 1-weekDiff7met
Position difference 1-monthDiff30met
Absolute visibilityVimet
Datedatedim
Keyword positionkeyword_positiondim
Keyword domainkeyword_domaindim
Keyword IDPidim
KeywordPhdim
Keyword tagsTgdim
Avg priceCpdim
Avg searches per monthNqdim
Ranking typeLtdim
Landing URLLudim
Position at beginningBemet
Position at endFimet
Position differenceDiffmet
Position difference 1-dayDiff1met
Position difference 1-weekDiff7met
Position difference 1-monthDiff30met
Datedatedim
Competitor URLUrdim
Keyword amountkeyword_amountmet
Visibility changeCdmet
VisibilityClmet
Avg positionAvmet
Position deviationSqmet
Traffic (%)Trmet
Traffic Cost (%)Tcmet
Datedatedim
Competitor URLUrdim
Keyword amountkeyword_amountmet
Visibility changeCdmet
VisibilityClmet
Avg positionAvmet
Position deviationSqmet
Traffic (%)Trmet
Traffic Cost (%)Tcmet
Datedatedim
Number of resultstotalmet
Avg positionAvmet
Traffic (%)Trmet
Traffic Cost (%)Tcmet
Absolute visibilityVimet
Relative visibilityVrmet
Datedatedim
Number of resultstotalmet
Avg positionAvmet
Traffic (%)Trmet
Traffic Cost (%)Tcmet
Absolute visibilityVimet
Relative visibilityVrmet
Crawl IDsnapshot_iddim
Finish datefinish_datedim
Issue IDissue_iddim
Issue titleissue_titledim
Page titletitle_pagedim
Info columninfo_columndim
URLurl_columndim
Projectproject_namedim
Project IDprofile_iddim
Project URLurldim
Audit statusstatusdim
Schemeschemedim
Excluded beta checksexcludedBetaChecksdim
Issuesissue_detectsdim
Clicks to reach pagedepth_clicksdim
Subdomains crawledcrawlSubdomainsdim
Crawl-delay followedrespectCrawlDelaydim
Crawl amp firstcrawlAmpFirstdim
Internal incoming links groupsinternalIncomingLinksGroupsdim
Incoming linksincoming_linksdim
Marked with canonicalcanonicaldim
With ampwithAmpdim
Schedule dayscheduleDaydim
Crawl source typecrawlSourceTypedim
Crawl source URLcrawlSourceUrldim
Precrawl errorprecrawlErrordim
GA statusgaStatusdim
GA settingsgaSettingsdim
Product groupproductGroupdim
User agent typeuser_agent_typedim
Last audit datelast_auditdim
Last failed audit datelast_failed_auditdim
Next scheduled audit datenext_auditdim
Sitemaps report URLsitemaps_reprUrldim
Sitemaps statussitemaps_statusdim
Mask ALLOWmask_allowdim
Mask DISALLOWmask_disallowdim
Excluded URL parametersremovedParametersdim
Excluded issuesexcluded_checksdim
Is notifyis_notifydim
Found errorserrorsmet
Found warningswarningsmet
Found noticesnoticesmet
Broken pagesbrokenmet
Blocked pagesblockedmet
Redirecting pagesredirectedmet
Healthy pageshealthymet
Pages with issueshaveIssuesmet
Issue amount differencehaveIssuesDeltamet
Twitter Card markupsmarkups_twitterCardmet
Open Graph markupsmarkups_openGraphmet
Schema.org markupsmarkups_schemaOrgmet
Microformat markupsmarkups_microfomatsmet
No markupsmarkups_noMarkupsmet
Crawlability totalcrawlability_totalmet
Crawlability non canonical pagescrawlability_nonCanonicalPagesmet
Crawlability permanent redirectscrawlability_permanentRedirectsmet
Crawlability redirect chains and loopscrawlability_redirectChainsAndLoopsmet
Crawlability temporary redirectscrawlability_temporaryRedirectsmet
Crawlability content duplicatescrawlability_contentDuplicatesmet
Crawlability too large pagescrawlability_tooLargePagesmet
Crawlability too slow pagescrawlability_tooSlowPagesmet
Crawlability bot blockedcrawlability_botBlockedmet
Crawlability code 4xxcrawlability_code4xxmet
Crawlability code 5xxcrawlability_code5xxmet
Amp totalampTotalmet
Pages crawled during running auditrunning_pages_crawledmet
Crawled pages limit during running auditrunning_pages_limitmet
Crawled pagespages_crawledmet
Crawled pages limitpages_limitmet
Total checks during last audittotal_checksmet
Hreflangs total pageshreflangs_totalPagesmet
Hreflangs bad pageshreflangs_badPagesmet
Hreflangs missinghreflangs_missingmet
Xdefaultxdefaultmet
Sitemaps crawled pagessitemaps_crawledPagesmet
Sitemaps total pagessitemaps_totalPagesmet
Sitemaps countsitemaps_countmet
Canonicalization emtpy or without canonical linkcanonicalization_emptyOrWithoutCanonicalLinkmet
Canonicalization self canonicalcanonicalization_selfCanonicalmet
Canonicalization canonical to other pagecanonicalization_canonicalToOtherPagemet
Error amount differenceerrors_deltamet
Warning amount differencewarnings_deltamet
Notice amount differencenotices_deltamet
Crawl IDsnapshot_iddim
Finish datefinish_datedim
Website scorewebsite_scoredim
Website score differencewebsite_score_deltadim
Warning IDwarning_iddim
Error IDerror_iddim
Notice IDnotice_iddim
Top issuestopIssuesdim
Status code group IDstatus_code_group_iddim
Fixed issue IDfixed_issue_iddim
New issue IDnew_issue_iddim
Found errorserrorsmet
Found warningswarningsmet
Found noticesnoticesmet
Crawled pagespages_crawledmet
Error amount differenceerrors_deltamet
Warning amount differencewarnings_deltamet
Notice amount differencenotices_deltamet
Warning checkswarning_checksmet
Error checkserror_checksmet
Notice checksnotice_checksmet
Status code countstatus_code_countmet
Fixed issue countfixed_issue_countmet
New issue countnew_issue_countmet
Issue IDissue_iddim
Page titletitle_pagedim
First seendiscovereddim
Page IDpage_iddim
Webpage URLsource_urldim
Page IDpage_iddim
Webpage URLsource_urldim
Page titletitle_pagedim
Markupsmarkups_stringdim
Clicks to reach pagedepth_clicksdim
Incoming linksincoming_linksdim
Canonicalcanonical_urldim
Canonical sourcecanonical_sourcesdim
Warning IDwarning_iddim
Error IDerror_iddim
Notice IDnotice_iddim
Page IDpage_iddim
Webpage URLsource_urldim
Page weightpage_weightdim
Error discoverederror_discovereddim
Error descriptionerror_infodim
Error target URLerror_target_urldim
Warning discoveredwarning_discovereddim
Warning descriptionwarning_infodim
Warning target URLwarning_target_urldim
Notice discoverednotice_discovereddim
Notice descriptionnotice_infodim
Notice target URLnotice_target_urldim
Is auditingisAuditingdim
Canonicalizationcanonicalizationdim
Page grouppageGroupdim
AJAX typeajaxTypedim
GAgadim
Found errorserrorsmet
Found warningswarningsmet
Found noticesnoticesmet
Page load timepageLoadTimemet
Crawl IDsnapshot_iddim
Finish datefinish_datedim
Excluded issuesexcluded_checksdim
Website scorewebsite_scoredim
Website score differencewebsite_score_deltadim
Warning IDwarning_iddim
Error IDerror_iddim
Notice IDnotice_iddim
Top issuestopIssuesdim
Status code group IDstatus_code_group_iddim
Fixed issue IDfixed_issue_iddim
Found errorserrorsmet
Found warningswarningsmet
Found noticesnoticesmet
Crawled pagespages_crawledmet
Crawled pages limitpages_limitmet
Error amount differenceerrors_deltamet
Warning amount differencewarnings_deltamet
Notice amount differencenotices_deltamet
Warning checkswarning_checksmet
Error checkserror_checksmet
Notice checksnotice_checksmet
Status code countstatus_code_countmet
Fixed issue countfixed_issue_countmet