Google Search Console Data
The default GSC interface is limited as you already know, and the API allows much more data and flexibility. Yet, the Big Query export option contains even more data, and more columns.
This dashboard is based on the Big Query option:
- Data from the GSC account is automatically exported to GBQ on a daily basis (the option is available through the online interface).
- The latest day's data from GBQ is imported to this server on a daily basis.
- Data on this server is saved in an efficient format that allows for fast querying and enables insightful analysis.
Features
- Compare data on multiple dimensions; countries, devices, search types, and dates, all in one chart.
- View multiple countries at the same time for the selected metric.
- Split the charts by device.
- Split the charts by search types (web, image, video, news, discover).
- Use any combination of the above options.
- Filter for queries including/excluding a certain regex
- Filter for URLs including/excluding a certain regex
- Query cannibalization report showing queries that appeared for multiple URL, with a split of metrics for each
- Query analytics: Classify the queries using regular expressions in a completely flexible way (by intent, topic, location, brand/non-brand, etc.)
- Query ngram analysis with counts weighted by impressions or clicks
- Available metrics: impressions, clicks, ctr, average position, query count, and URL count
- Overview report for each entity (date, URL, query, country, device, search type, and all additional columns like "is anonymized query", "is product snippet", etc.)
- Export any table with(out) filtering
- Draw trend lines on chart and get automatic calculation of growth/decline
Upcoming features
- Exporting the charts you created to an interactive HTML file.
- Compare dates.
- URL path analysis
- Structure of the website
/dir_1/dir_2/... analysis
- Analysis using all available metrics and dimensions
Features suggestions and bugs
If you have any suggestion on how to improve things or if you come across any bugs, please get in touch and share them.