More and better data export in Search Console

Wednesday, February 26, 2020

We have heard users ask for better download capabilities in Search Console loud and clear - so we're happy to let you know that more and better data is available to export.

You'll now be able to download the complete information you see in almost all Search Console reports (instead of just specific table views). We believe that this data will be much easier to read outside SC and store it for your future reference (if needed). You'll find a section at the end of this post describing other ways to use your Search Console data outside the tool.

Enhancement reports and more

When exporting data from a report, for example AMP status, you'll now be able to export the data behind the charts, not only the details table (as previously). This means that in addition to the list of issues and their affected pages, you'll also see a daily breakdown of your pages, their status, and impressions received by them on Google Search results. If you are exporting data from a specific drill-down view, you can see the details describing this view in the exported file.

If you choose Google Sheets or Excel (new!) you'll get a spreadsheet with two tabs, and if you choose to download as csv, you'll get a zip file with two csv files.

Here is a sample dataset downloaded from the AMP status report. We changed the titles of the spreadsheet to be descriptive for this post, but the original title includes the domain name, the report, and the date of the export.

AMP report export sample

Performance report

When it comes to Performance data, we have two improvements:
  1. You can now download the content of all tabs with one click. This means that you'll now get the data on Queries, Pages, Countries, Devices, Search appearances and Dates, all together. The download output is the same as explained above, Google sheets or Excel spreadsheet with multiple tabs and csv files compressed in a zip file.
  2. Along with the performance data, you'll have an extra tab (or csv file) called "Filters", which shows which filters were applied when the data was exported.

Here is a sample dataset downloaded from the Performance report.

Performance on Search export sample

Additional ways to use Search Console data outside the tool

Since we're talking about exporting data, we thought we'd take the opportunity to talk about other ways you can currently use Search Console data outside the tool. You might want to do this if you have a specific use case that is important to your company, such as joining the data with another dataset, performing an advanced analysis, or visualizing the data in a different way. There are two options, depending on the data you want and your technical level.

Search Console API

If you have a technical background, or a developer in your company can help you, you might consider using the Search Console API to view, add, or remove properties and sitemaps, and to run advanced queries for Google Search results data.

We have plenty of documentation on the subject, but here are some links that might be useful to you if you're starting now:

  1. The Overview and prerequisites guide walks you through the things you should do before writing your first client application. You'll also find more advanced guides in the sidebar of this section, for example a guide on how to query all your search data.
  2. The reference section provides details on query parameters, usage limits and errors returned by the API.
  3. The API samples provides links to sample code for several programming languages, a great way to get up and running.

Google Data Studio

Google Data Studio is a dashboarding solution that helps you unify data from different data sources, explore it, and tell impactful data stories. The tool provides a Search Console connector to import various metrics and dimensions into your dashboard. This can be valuable if you'd like to see Search Console data side-by-side with data from other tools.

If you'd like to give it a try, you can use this template to visualize your data - click "use template" at the top right corner of the page to connect to your data. To learn more about how to use the report and which insights you might find in it, check this step-by-step guide. If you just want to play with it, here's a report based on that template with sample data.

Let us know on Twitter if you have interesting use cases or comments about the new download capabilities, or about using Search Console data in general. And enjoy the enhanced data!