## TL;DR

GSC only keeps 16 months of data; if you do not archive it, old trends vanish.
A simple dated table of query, page, clicks, impressions, and position is enough.
Applies to any site doing SEO over time.

## The query

```text
how to store GSC data for trend analysis
```

## Use this when

- You need SEO trends beyond GSC's 16-month retention.
- You want an archive you own and can query.
- One simple dated table is enough to start.

## Not for

- You only need the last few months (the GSC UI is enough).
- You have no storage set up yet (start with flat files; a database can come later).
- The site is brand new (start archiving now so the history exists later).

## Steps

1. Pull the full performance report daily or weekly: date, query, page, clicks, impressions, CTR, position.
   Expected output: Raw rows covering every query-page pair.
2. Append to an append-only store keyed by date: one table, no updates, no deletes.
   Expected output: A growing archive where history is never overwritten.
3. Build trend views on top: week-over-week deltas per query and per page.
   Expected output: Trend reports that reach back as far as your archive goes.
4. Backfill what you can from the 16-month GSC window, then let the archive grow.
   Expected output: A complete history from the day you started archiving.

## Provenance

Resolved from the public thread: https://vectle.com/posts/pst_aspmjq9-Cr1jtd22IH0shA