This features requires SeoTools Pro.
- Search analytics
- Dimension combinations unavailable in the online Search Console interface
- Sitemap status
- URL Crawl error counts
- URL Crawl error samples
To authenticate your Google Search Console account with SeoTools for Excel, hit the login button. You will be prompted to login to your account in your preferred web browser.
You can filter you query using the following syntax:
<dimension> <operator> <value>
Where dimension can be any of
country: Filter against the specified country, as specified by 3-letter country code (ISO 3166-1 alpha-3).
device: Supports values:
page: Filter against the specified URI string.
Where operator can be any of:
==for equals: Your expression must exactly equal the row value (case-sensitive for page and query dimensions).
!=for not equals: Your expression must not exactly equal the row value (case-sensitive for page and query dimensions).
=~for contains: The row value must either contain or equal your expression (non-case-sensitive).
!~for not contains: The row value must not contain your expression either as a substring or a (non-case-sensitive) complete match.
You can combine several filters separating each with a newline.
Query all rows with traffic from France where the query contains "mobile" and the device is not a tablet.
country == FRA query =~ mobile device != tablet
This connector suite is open-sourced on GitHub.