What Google retains
Search Console exposes a limited historical performance window. That is enough for year-over-year analysis only when data is captured and retained consistently.
What the API can return
The Search Analytics API supports dimensions such as query, page, country, device, date, and search appearance, but returns top rows rather than guaranteeing every long-tail row.
Why daily storage matters
A durable daily fact table creates stable baselines, comparable periods, data-health checks, and reports that do not depend on manually exported spreadsheets.
How RankPortfolio backfills
RankPortfolio imports recent aggregate history first, then progressively fills deeper query and page dimensions while respecting API and runtime limits.