Skip to main content
Workspace /SEO Recovery Engine
No website connected
SEO Action Planner

Why Pages.csv does not match the GSC total

A different total does not automatically mean the CSV was misread. First compare the same property, dates, search type, country, device and other Search Console filters. The Pages export and the headline can also use different aggregation.

Daily totals and page totals answer different questions

For a standard property-level performance export, Chart.csv contains daily clicks and impressions. Summing those days provides a reference for the headline over that coverage. Pages.csv groups by URL. Multiple URLs from a property can receive impressions in the same result, so page sums may exceed property-level impressions.

Missing rows are not missing traffic estimates

Search Console table exports can be capped at 1,000 rows. Query exports also omit anonymised queries. These limitations affect different dimensions differently: anonymised-query omissions do not prove the cause of a particular Pages-versus-Chart gap. Never add Pages, Queries, Countries and Devices totals together: they describe overlapping traffic, not separate visits.

Reconcile without editing the figures

  1. Export the full ZIP for the exact selected reporting period.
  2. Compare Pages.csv clicks and impressions separately against the daily sums.
  3. Check the row count, duplicate exclusions and Chart daily coverage.
  4. Calculate CTR as total clicks divided by total impressions, not an average of row CTRs.
  5. Treat impression-weighted exported average positions as approximations because CSV rows contain rounded averages.

Dates cannot split a Pages export

Pages.csv is already aggregated across its exported period. Editing its date label cannot recover per-page metrics for fewer days. Export a new Pages report for the dates you want. Chart days can be filtered, but they cannot supply per-page daily metrics.

Upload your matching ZIP to SEO Action Planner and open “Check these totals against Search Console” to inspect the source and displayed totals.