Totals and weighted position describe only the supplied rows in this view. They do not reconstruct the Google property total. Page impressions can count differently from property impressions; query exports may omit rows. Never combine page and query tables into one total.
Both exports must use the same property, dimension, search type, country, device and filters. Record their source and collection dates in Source. Describe omissions and provisional data in Scope. Search Console daily dates use Pacific Time. Supply non-overlapping periods in chronological order.
| Metric | Earlier period | Later period | Absolute change |
|---|---|---|---|
| Supplied rows | 3 | 3 | 0 |
| Clicks | 57 | 57 | 0 |
| Impressions | 800 | 800 | 0 |
| CTR | 7.12% | 7.12% | 0 percentage points |
| Weighted row position | 4.75 | 4.19 | -0.56 |
CTR = total clicks / total impressions. Position = sum(position × impressions) / total impressions, as an estimate for these rows. Any unknown position with positive impressions makes this view’s position unknown. A negative position difference means a lower number, not proof of improved business results.
A key absent from one file stays unknown for that period. It is not automatically zero, newly ranking or lost. A supplied zero is a separate observation. No percentage change is computed from a zero baseline.
| Query or page | File presence | Earlier period · Clicks | Later period · Clicks | Absolute change · Clicks | Earlier period · Impressions | Later period · Impressions | Earlier period · CTR | Later period · CTR | Earlier period · Weighted row position | Later period · Weighted row position |
|---|---|---|---|---|---|---|---|---|---|---|
| https://sample.example/guide | Both files | 22 | 30 | 8 | 400 | 500 | 5.5% | 6% | 5 | 4 |
| https://sample.example/pricing | Both files | 30 | 25 | -5 | 300 | 250 | 10% | 10% | 3 | 3 |
| https://sample.example/old | Earlier file only | 5 | Not provided | Not provided | 100 | Not provided | 5% | Not provided | 9 | Not provided |
| https://sample.example/new | Later file only | Not provided | 2 | Not provided | Not provided | 50 | Not provided | 4% | Not provided | 12 |
Use the notes to separate an observed change, a hypothesis and a proposed next check. Do not attribute ranking or traffic changes to a backlink order from these exports alone.