How to keep Search Console data longer than 16 months

By Jake Marsh · Updated

To keep Search Console data longer than 16 months, copy it somewhere you control before Google drops it. In Google Sheets, install Queryledger, open Extensions > Queryledger > Open Queryledger, go to the Backups tab, pick the property and what to keep (for example Queries by day), and click Add backup. Queryledger copies the 16 months Google still has, then adds each new day once Google finalizes it.

Why the data disappears

Search Console's Performance report and its API go back 16 months. Each day, the oldest day drops off. Nothing in Search Console keeps it for you, so a site that started tracking in January can't see that January two Januaries later. The only ways to keep it are to export it regularly or to use a backup that does it daily.

Steps

  1. Open Extensions > Queryledger > Open Queryledger in the spreadsheet where the archive should live, or any spreadsheet if you'll keep it separate.

  2. Go to the Backups tab and choose the Property.

  3. Choose What to keep:

    OptionOne row perGood for
    Daily totalsdayLong-term traffic trend
    Queries by dayday and queryKeyword history
    Pages by dayday and pageContent performance over years
    Query + page by dayday, query and pageWhich page ranked for what, when
    Country + device by dayday, country and deviceMarket and mobile trends
  4. Choose the Search type (Web, Image, Video, News tab, Discover or Google News). Make one backup per search type you care about.

  5. Tick Keep it in its own spreadsheet for a big site, or for Query + page by day, which grows fastest.

  6. Click Add backup. The first run fills in everything Google still has. After that an hourly check adds each finalized day.

  7. Use Back up now (in the sidebar, or Extensions > Queryledger > Back up now) when you want it to check straight away.

How the archive stays clean

  • Only final data. Search Console's last two to three days can still change, so backups wait until Google marks a day final.
  • No duplicate days. If a run is interrupted, the next one removes the partial day before writing it again.
  • No cell-limit surprises. A Google spreadsheet holds 10 million cells. Before an archive gets there, Queryledger continues it in a new spreadsheet (part 2, part 3), linked from the backup.
  • Gaps are recorded. If a backup stops running for so long that Google drops days before they were copied, the backup notes the missing date range instead of hiding it.
  • Removing a backup keeps the rows. Archived data is never deleted when you remove the job.

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

Can I get back data that's already older than 16 months?

No. Once Google has dropped a day, it isn't available from Search Console or its API. A backup keeps everything from the oldest day Google still has, so start one as early as you can.

Which backup should I start with?

Daily totals is small and gives you the long-term trend. Add Queries by day or Pages by day for keyword and content history. Query + page by day has the most detail and grows fastest.

Do I need to keep the spreadsheet open?

No. Backups run from an hourly trigger in your Google account, whether or not the sheet is open.

Can I back up several sites?

Yes. Add one backup per property and search type. Each one is listed on the Backups tab with its last archived day.


More Queryledger guides


More Google guides