Find which queries or pages lost clicks.

Export two separate periods

1. Open the Search results Performance report. Choose one property, search type and set of filters.
2. Set the first date range. Export CSV and open its Queries or Pages table. Enable Clicks, Impressions, CTR and Position.
3. Repeat for the second range with the same filters and table type. Use separate exports, without comparison columns.
4. Load each table below and enter the exact inclusive dates you selected. This tool cannot verify the export dates or filters.

Accepted headers are Query or Top queries, or Page or Top pages, plus Clicks, Impressions, CTR and Position. Use English headers. Each file may contain up to 10,000 rows.

Read the calculation

Counts are divided by the number of calendar days, including both dates. Rows observed in both exports have a clicks per day change. A zero in an exported row stays zero. A row absent from an export is marked not observed, with no change or effects calculated. Totals cover matched rows only.

For each matched row, I means impressions per day and R means clicks divided by impressions. We recompute R from counts because exported CTR can be rounded. With 0 impressions, R is defined as 0. The impression effect is (I after − I before) × (R before + R after) ÷ 2. The CTR effect is (R after − R before) × (I before + I after) ÷ 2. The effects add exactly to the change before display rounding.

These are arithmetic components, not proof of cause. Review date ranges, demand, page changes and Search Console filters before deciding what happened. Overlapping ranges show a warning. Compare equivalent weekdays and seasons where possible.

Questions about the results

Does a missing row mean rankings were lost?

No. Exports can omit rows. This tool makes no ranking-loss claim about missing rows. Position is validated as a metric but does not establish a cause.

Will these totals match Search Console?

They may differ. Google limits report exports to representative rows, and chart and table aggregation can differ. Google also exports unavailable values as zero. We can only compare the values in your files. See Google's export limits and instructions and Performance report definitions.

Can this prove why traffic fell?

No. It shows where observed changes appear and separates the calculation into impressions and CTR. It does not diagnose an update, penalty, technical issue or changing demand.