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
-
Open Extensions > Queryledger > Open Queryledger in the spreadsheet where the archive should live, or any spreadsheet if you'll keep it separate.
-
Go to the Backups tab and choose the Property.
-
Choose What to keep:
Option One row per Good for Daily totals day Long-term traffic trend Queries by day day and query Keyword history Pages by day day and page Content performance over years Query + page by day day, query and page Which page ranked for what, when Country + device by day day, country and device Market and mobile trends -
Choose the Search type (Web, Image, Video, News tab, Discover or Google News). Make one backup per search type you care about.
-
Tick Keep it in its own spreadsheet for a big site, or for Query + page by day, which grows fastest.
-
Click Add backup. The first run fills in everything Google still has. After that an hourly check adds each finalized day.
-
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
- How to export more than 1,000 rows from Search Console
- How to compare Search Console data year over year in Google Sheets
More Google guides
- How to create barcodes in Google Sheets (Rowcode)
- How to create a PDF for each row in Google Sheets (PickMerge)
- How to share only part of a Google Sheet (Rowsplit)
- How to print 5160 address labels from Google Sheets (Labelyard)