How to export more than 1,000 rows from Search Console

By Jake Marsh · Updated

To export more than 1,000 rows from Search Console, use the Search Console API instead of the Export button, which stops at 1,000. In Google Sheets, install Queryledger, open Extensions > Queryledger > Open Queryledger, tick the property on the Report tab, choose Query and Page under Dimensions, leave Row limit at 0, and click Pull into a new tab. Queryledger keeps paging until the API has no more rows.

Where the 1,000-row limit comes from

Google's own guide to Search Console performance data says the user interface exports at most 1,000 rows. The Search Analytics API returns up to 25,000 rows per request and, with paging, up to 50,000 rows per day per site per search type. Queryledger reads through the API and requests the next page until Google stops sending rows.

Steps

  1. Open Extensions > Queryledger > Open Queryledger.
  2. Tick one or more properties under Properties. Several properties come back in one table with a Property column.
  3. Pick the dates. Last 28 days and Last 3 months match the Search Console defaults; Everything Google still has (16 months) pulls the full window.
  4. Choose Dimensions. Query and Page together give one row per query per page. Add Date for a row per day.
  5. Add filters if you only want part of the site: Page contains /blog/, or Query matches regex ^how.
  6. Leave Row limit at 0 and set a Tab name, or leave it automatic.
  7. Click Pull into a new tab.

Getting the most rows

To getDo this
More queries per pagePull a shorter date range, or one search type at a time
Every page, even with few clicksUse Page as the only dimension; fewer dimension combinations means fewer rows dropped
One section in depthFilter by Page contains the folder
Several sites in one tableTick each property; each counts as one trial use

Two things the API never returns, in any tool: anonymized queries (searches Google keeps private) and rows beyond 50,000 per day per search type. For a site that needs more than that, Google's Bulk data export to BigQuery is the tool.

What it costs

Queryledger's free trial covers 30 uses or 14 days, whichever comes first, with no card needed. A use is one property in a pull, one comparison, or one backup's daily run that adds data, and the whole 16-month backfill counts as one. After that it's $49 a month or $492 a year per Google account, or $149 a month for a team plan that covers everyone at your company's domain. Install it from the Queryledger page.

Queryledger: Search Console Backups & Reports

Search Console data in Google Sheets, with daily backups that keep your history past 16 months $49 a month or $492 a year per Google account.


Questions

Is the data the same as in the Search Console report?

It comes from the same source through Google's API, with dates in Pacific Time like Search Console. Totals for a query-level table can be lower than the report's chart because anonymized queries are left out of query rows.

Can I export Search Console data for several websites at once?

Yes. Tick several properties and the rows land in one table with a Property column.

Can I include the last few days?

Tick Include fresh data (last 2-3 days, may still change). Without it, pulls use final data only.

How long does a big pull take?

It depends on how many rows Google returns. Queryledger requests the pages for several properties in parallel and retries when Google asks it to slow down.


More Queryledger guides


More Google guides