• Search Engine Land
  • Sections
    • SEO
    • SEM
    • Local
    • Retail
    • Google
    • Bing
    • Social
    • Resources
    • More
    • Home
  • Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • Live
  • More
  • Events
  • SUBSCRIBE

Search Engine Land

Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • More
  • Newsletters
  • Home
SEO

Google Webmaster Tools Adds Useful Download Options

Google webmaster tools data is helpful stuff, but has been somewhat tough to download and use. Last month, Google made things a bit easier by providing a Python script for downloading search query data (as this report isn’t available as of yet through the API). Now, they’ve added new download options that significantly add to […]

Vanessa Fox on January 20, 2012 at 2:48 pm
  • More

Google webmaster tools data is helpful stuff, but has been somewhat tough to download and use. Last month, Google made things a bit easier by providing a Python script for downloading search query data (as this report isn’t available as of yet through the API). Now, they’ve added new download options that significantly add to the usefulness of the data. Below, why these new CSV files are so important.

Search Queries: Download Chart Data

Search query chart data downloads provide access to information not easily available before. When you view search query data, the chart in the user interface shows impression and click data per day, but in the past, this detail has only been available if you hover over a dot in the chart.

Google webmaster tools search query charts

Now, you can access this data by clicking the Download Chart Data  button below the Top Queries and Top URLs reports. (You can use filtering options to drill into specific data or date ranges).

The data downloads to a CSV file as shown below:

Query Data CSV

When you click on a specific query in the Top Queries report page, you see a similar chart, but its data is not available for download. In the example below, clicking on [track santa claus] query in the Top Queries report brings up the query details for that single query, and you can download the page and position information, but not the chart data. (Note that a display bug seems to be preventing the buttons on this page from displaying in Internet Explorer.)

Google webmaster tools query details

You can filter the Top Queries report and download the impression and click data from there (although you may not be able to filter to a single query). In the example below, a filtered report for [track santa claus] resulted in 16 queries.

Google search query details

The chart data in this case can be particularly useful due to how Google reports trended data. Watch for a separate post detailing how this works, but in short, Google reports on the top 1,000 queries per day. For reports that span multiple days, such as the example above, impression and click data is only included if the query was in the top 1,000 for each day. This can result in misleading totals, since the impressions and clicks aren’t totals for the entire data range, but only totals from the days in that range that the query was in the top 1,000. Confusing? Totally understandable.

Let’s look at the example above. I’ve filtered the Top Queries report to only show queries that include [track santa claus] for a 31 day period and the report shows:

  • 16 queries
  • 170,000 impressions
  • 3,000 clicks

Does this mean the site got traffic for only 16 queries that contain the words [track santa claus]? No, it means that only 16 queries made it into the top 1,000 at least one day during the date range. Based on that foundation, you might assume that those 16 queries resulted in 170,000 impressions for the site and brought in 3,000 clicks for the 31 day period. But that assumption would be wrong. (This is where things can really start to get confusing.)

The Search Queries report only reports data (at all) for those days that a query is in the top 1,000. And the totals are the sum of the counts on those days only — not the entire date range. This level of detail has always been available (sort of) by way of the dots on the charts. Looking more closely at our [track santa claus] example, notice that several days in the chart don’t have dots.

Google query detail no data

The days without dots are the days that the query (or set of queries) didn’t make the top 1,000 and therefore have no data reported. Until now, the only way to make some sense of the data was to count the dots to better understand the summary data. Now, when you download the chart data, you can much more easily understand what the visualization represents:

Query Detail CSV

With the CSV, it’s much more apparent that although the specified date range is 12/18/11 – 1/17/12, the totals are for 11 days, not 31. These queries were in the top 1,000 on 12/27, but not on the 28th or 29th. Does this mean that on the 28th, the impressions and clicks were lower than on the 27th? Maybe. Or it could mean that impressions and clicks stayed the same but another query spiked in volume and bumped it from the top 1,000.

User Interface Improvements

One nice change is the ability to view more data on a page. Most pages, including the dashboard page listing all sites in the account, now include an option for the number of rows to show.

Google webmaster tools show rows

You can now view up to 500 rows at once, which makes overall account management and data viewing much easier.

I had initially thought that more link data might be available as well, but after talking with Google, I realize that the user interface improvements have simply made the link reports more easily visible.

In particular, the detailed chart data available for download provides a significant improvement as it brings a much more accurate understanding of what the data actually is. Watch for my more detailed post on the search query data shortly.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.



About The Author

Vanessa Fox
Vanessa Fox is a Contributing Editor at Search Engine Land. She built Google Webmaster Central and went on to found software and consulting company Nine By Blue and create Blueprint Search Analytics< which she later sold. Her book, Marketing in the Age of Google, (updated edition, May 2012) provides a foundation for incorporating search strategy into organizations of all levels. Follow her on Twitter at @vanessafox.

Related Topics

Channel: SEOGoogle: Search Console

We're listening.

Have something to say about this article? Share it with us on Facebook, Twitter or our LinkedIn Group.

Get the daily newsletter search marketers rely on.
See terms.

ATTEND OUR EVENTS

Lorem ipsum doler this is promo text about SMX events.

April 13, 2021: SMX Create

May 18-19, 2021: SMX London

June 8-9, 2021: SMX Paris

June 15-16, 2021: SMX Advanced

June 21-22, 2021: SMX Advanced Europe

August 17, 2021: SMX Convert

November 9-10, 2021: SMX Next

December 14, 2021: SMX Code

Available On-Demand: SMX

Available On-Demand: SMX Report

×


Learn More About Our SMX Events

Discover actionable tactics that can help you overcome crucial marketing challenges. Our next conference will be held:

MarTech 2021: March 16-17

MarTech 2021: Sept. 14-15

MarTech 2020: Watch On-Demand

×

Attend MarTech - Click Here


Learn More About Our MarTech Events

White Papers

  • B2B Marketing Trends Shaping 2021
  • State of Email Marketing 2021 Report
  • Three Pillars of CRM Data Management
  • What Customer Experience Means in 2021
  • The 7 Phases of a Website Redesign
See More Whitepapers

Webinars

  • Crawl Your Way Towards Better Search Results With Dynamic Rendering
  • The AI Revolution Is Coming to Every Stage of Your Buyer’s Journey
  • The Fundamentals of Link Building for E-Commerce & Affiliate Sites in 2021
See More Webinars

Research Reports

  • Local Marketing Solutions for Multi-Location Businesses
  • Enterprise Digital Asset Management Platforms
  • Identity Resolution Platforms
  • Customer Data Platforms
  • B2B Marketing Automation Platforms
  • Call Analytics Platforms
See More Research

h
Receive daily search news and analysis.

Channels

  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social

Our Events

  • SMX
  • MarTech

Resources

  • White Papers
  • Research
  • Webinars

About

  • About Us
  • Contact
  • Privacy
  • Marketing Opportunities
  • Staff

Follow Us

  • Facebook
  • Twitter
  • LinkedIn
  • Newsletters
  • RSS
  • Youtube

© 2021 Third Door Media, Inc. All rights reserved.

Your privacy means the world to us. We share your personal information only when you give us explicit permission to do so, and confirm we have your permission each time. Learn more by viewing our privacy policy.Ok