Compare a ranking report · Queries

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.

Property or project
https://sample.example/
Data source
Fictional Search Console-style teaching exports · 2026-10-20
Source scope and filters
Example property; Web search; all countries and devices; same filters; final illustrative data; incomplete teaching subset. Daily dates are Pacific Time.
Summary and limitations
Compare matched queries before describing a site-wide trend. Keep missing keys and outcome measurements explicitly unknown.
Report dimension
Queries
Earlier period
2026-09-01 / 2026-09-14 · 14 Days · en-queries-baseline.csv
Later period
2026-10-01 / 2026-10-14 · 14 Days · en-queries-current.csv

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.

MetricEarlier periodLater periodAbsolute change
Supplied rows330
Clicks9377-16
Impressions1,0501,10050
CTR8.86%7%-1.86 percentage points
Weighted row position2.957.364.41

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 pageFile presenceEarlier period · ClicksLater period · ClicksAbsolute change · ClicksEarlier period · ImpressionsLater period · ImpressionsEarlier period · CTRLater period · CTREarlier period · Weighted row positionLater period · Weighted row position
samplebrandBoth files9040-5090020010%20%21
link researchBoth files232301008002%4%108
legacy guideEarlier file only1Not providedNot provided50Not provided2%Not provided6Not provided
reporting checklistLater file onlyNot provided5Not providedNot provided100Not provided5%Not provided15

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.