SEO

How to get around 1000 url limit Google Search Console

Learn how to get around the 1000 row limit in Google Search Console to extract all URLs and queries from your website

One issue that many marketers run into is trying to figure out how to pull all of the URLs and queries from your website using Google Search Console. This can be tricky because while using the Google Search Console tool, you can only see the top 1,000 results for queries and pages.

This may not be an issue for smaller websites, but for larger ones, with thousands and millions of pages, it may be problematic. This can prevent companies from discovering critical business insights that can help shape their SEO strategy. Luckily, there are ways to navigate around this limit of 1,000.

The first thing you'll need is the proper permissions in Google Search Console. Now, for this step, you'll want Restricted User, Full User, or Owner permissions under the property that you're looking to pull all the data from.

To do this, you'll need to go to the settings tab and click users and permissions. Once you're there, you can add a user or change the permissions for an existing user.

Once the proper permissions have been given to a user, we'll bring the data over to Google Looker Studio. You'll need a dashboard with a table for the queries or URLs, and then you'll need to add the website as a data source. 

You can add filters for the date range, and different columns for the metrics that you'd like to see.

Once the data source has been added and the table has been refreshed, you should be able to see the true number of URLs or queries that are available on Google Search Console.

Then you'll want to click the three dots on the top right of the table and click the export button. This will allow you to export all of the data into a CSV or into Google Sheets.

With a little bit of data manipulation, you can create any number of visuals. 

If you're looking for help pulling data or creating custom dashboards for your company, feel free to reach out to us today.