How To Export Data From Google Search Console: 3 Simple Steps

Picture of Phil Hughes
Phil Hughes

Google is dead! Yeah right! There are 99,000 searches on Google every second. That’s 8.5 BILLION searches a day.

So, if you’re publishing blog posts and articles. But aren’t checking your Google Search Console metrics? You could be missing out on some amazing insights.

It could be key to the long-term success of a business.

The problem is having this data sit on its own away from your Google Analytics data. Which means that any insights are pointless. Unless you can tie them to the goals you have for a website.

So, being able to get the data out of Google Search Console. And linking back to other metrics like website and ads analytics. Is the best way to see how a marketing campaign is performing.

Right, let’s get to it.

How do you export data from Google Search Console for a property or URL?

Here’s how.

Accessing and Exporting Google Search Console Data

With these simple 3 steps. You’ll learn how to export data from Google Search Console into Excel in no time.

Step 1: View The Domain Property Or URL

Start by selecting which domain property or URL you want to export the data for.

On the top left of your screen, there will be a drop-down.

Depending on the age of the website. You could have either or, or a combination of both. In the screenshot below of my Google Search Console, you can see I have both domain properties and single URLS

I’m going to select the domain property for Elementary Analytics.

Selecting which data to review in Google Search Console

The screen will reload showing an overview of the data for the selected website.

Step 2: View The Performance Data

On the left-hand navigation. Select the ‘Performance’ option. This will take you to a more detailed view of the metrics for your website.

Step 3: Export The Data

You’ll notice, on the ‘Performance’ screen. There is a button on the top-right of the screen above the overview graph, labelled ‘Export’. Give that a click. You’ll be given different options.

What I like about Google Search Console’s export. Is that you can export to both Microsoft Excel and Google Sheets. As well as a CSV, if you want to use a different data processing tool.

Select the option you want.

“Hey, Presto”. The data will be exported and downloaded to your device.

Top Tip: If you want to export data from Google Search Console for different periods you can. Before you click export, change the ‘Date’ option to refresh the data, then click ‘Export’. Google Search Console is extremely flexible, it allows you to choose from set options. Or define the period yourself.

Understanding Google Search Console Data

At the start of this post, I touched on how important Google Search Console is in a marketing strategy.

And that’s a vital part of your data-driven marketing plans.

One of the best things about Google Search Console data. It shows you which pages or posts on your website are performing well. And which search terms are sending traffic to those pages.

This helps you tweak your marketing campaigns. Giving you insights so you can focus on improving the click-through rate of top-performing posts. As well as improving conversions from that page on your website.

Next, you can then review the keyword. First to see if you’re ranking for the keywords you targeted. Or if you need to change them. Because you are ranking for some unexpected search terms. But, that is still relevant to your industry.

Reviewing Google Search Console data does an amazing job of showing if your SEO strategy is working or not.

If you want to find out what metrics to look at inside Google Search Console. Check out this article I wrote: Top 4 Google Search Console Metrics To Track When Starting.

Utilizing Exported Data for Business Insights

Once you’ve gathered all the data from Google Search Console, it’s time to put it to good use!

Here’s how you can use the information you’ve collected to make smart decisions for your business.

Understand Search Keywords

Take a close look at the search terms and keywords you rank for.

Are they keywords you want to rank for? Are there any surprises that haven’t been considered? Knowing what to target can help you tailor your content to better suit their interests and needs.

Improve Content Strategy

Analyze which types of posts or pages are ranking higher than others.

Is the headline causing more clicks to these pages? Why is that? Are longer articles performing better than short ones, or vice versa? Use this information to create more of the content that resonates with your audience.

Targeting Advertising Efforts

Use the data to refine your advertising targeting.

If you know what people are searching for. And what sort of information they are looking at. You can adjust your ads to reach them more effectively.

By utilizing the data you’ve exported from Google Search Console, you can make informed decisions that will help your business thrive!

Conclusion: Export Data From Google Search Console

Now that you’ve learned how to gather and export data from Google Search Console. You’re ready to make your marketing even better!

Remember, knowing what people are looking for. And what causes them to click a result in the search listing. Will help you create content that they’ll love. By using this information wisely, you can reach more people and grow your business.

Keep exploring and learning, and you’ll see great results on Google Search!

Oh, you want to know more about how Google Search Console data can work with other analytics? Check out our article: What Is Analytics And Data-Driven Marketing?

Elementary Analytics - The Sherlock Holmes of Data-Driven Marketing
When you have eliminated the impossible....

Struggling to get your marketing reports finished? Does it take you all day to do one client report? We can help you solve this mystery. Our free Excel sheet creates a PDF report in seconds. All you need to do is enter your data and click ‘generate’. Elementary my dear!

You'll See The Results

Keep marketing campaigns on track — Grow your business
Elementary Analytics isn’t for creating widgets. It’s great for reviewing your campaigns. Create reports at the click of a button. And wow your boss, workmates or customers.

How it’s better: Elementary Analytics puts your website, search, ads, and social media info together. This helps your team work better. Use one tool to see how things are doing—no need to jump between platforms or spreadsheets.