Google Search Console

Google search console helps you to see a summary of your most important metrics and notifications, including search performance, index coverage, and mobile usability metrics.

Sync Google Search Console data to Sourcetable

Build reports once. Connect to Google Search Console and start modeling from live data.
Here's a sample of the Google Search Console data that will be available in your Sourcetable spreadsheets:
KEYWORD_PAGE_REPORT

A report focussing the keywords used on a page and table contains date, site, search type, country, device, keyword, page, clicks, impressions, ctr and position

KEYWORD_SITE_REPORT_BY_PAGE

Contains date, site, search type, country, device, keyword, clicks, impressions, ctr and position

KEYWORD_SITE_REPORT_BY_SITE

A report telling the keywords entered for searching a site, table contains the following columns: date, site, search type, country, device, keyword, clicks, impressions, ctr and position

PAGE_REPORT

Contains date, site, page, search type, country, device, clicks, impressions, ctr and position

SITE_REPORT_BY_PAGE

Contains date, site, search type, country, device, clicks, impressions, ctr and position

SITE_REPORT_BY_SITE

Contains date, site, search type, country, device, clicks, impressions, ctr and position

SITEMAP

A sitemap is a file representing the relationships between the pages, videos, images and other files on your site.