How to find pages losing clicks, and which ones matter
By the Analistable team · Updated · 6 min read
In Search Console's Performance report, use Date → Compare (for example last 28 days vs the previous 28), open Pages and export. Calculate the change in clicks per page, then join GA4 conversions by landing page. Sort by lost clicks × conversion rate to fix the pages that cost you the most business, not just the most traffic.
Part of our guide: How to join spreadsheets on a common column
Step 1: export a comparison from Search Console
- Open Performance → Search results.
- Click the date filter, choose Compare, and pick two equal periods (compare the same weekdays to avoid weekly patterns).
- Open the Pages tab and click Export (Google Sheets, Excel or CSV).
The export has clicks, impressions, CTR and position for both periods per page.
Step 2: calculate the change
Click change = [@[Last 28 days Clicks]] - [@[Previous 28 days Clicks]]
Position change = [@[Last 28 days Position]] - [@[Previous 28 days Position]]
Impression change = [@[Last 28 days Impressions]] - [@[Previous 28 days Impressions]]The pattern tells you the cause:
| Clicks | Impressions | Position | Likely cause |
|---|---|---|---|
| Down | Down | Worse | Rankings dropped |
| Down | Stable | Stable | CTR fell — new SERP features, AI Overviews or a weaker title |
| Down | Down | Stable | Less demand (seasonality) |
Step 3: add GA4 conversions
Export GA4's Landing page report for Organic Search over the earlier period, convert Search Console URLs to paths (see combining GA4 and Search Console data), and add:
Conv rate = XLOOKUP([@Path], GA4[Landing page], GA4[Conversions], 0) / XLOOKUP([@Path], GA4[Landing page], GA4[Sessions], 1)
Lost value = -[@[Click change]] * [@[Conv rate]]Step 4: prioritise
| Page | Click change | Position change | Conv rate | Est. lost conversions |
|---|---|---|---|---|
| /pricing | -310 | 1.8 | 5.6% | 17.4 |
| /blog/merge-csv-files | -1200 | 2.5 | 0.6% | 7.2 |
| /tools/compare-spreadsheets | -180 | 0.2 | 3.9% | 7 |
The blog post lost the most clicks, but the pricing page lost the most conversions. Fix /pricing first.
Small pages swing a lot by chance. Ignore pages with fewer than ~100 clicks in the earlier period, or look at a longer window.
What to do next
- Position worse: check whether a competitor page or a Google update changed the results; refresh and expand the content.
- CTR worse at the same position: rewrite the title and description, and check for new SERP features.
- Demand lower: compare with the same period last year before changing anything.
Choosing the comparison periods
| Comparison | Use it when | Watch out for |
|---|---|---|
| Last 28 days vs previous 28 days | Spotting a recent drop quickly | Holidays or a sale inside one window |
| Last 3 months vs previous 3 months | Slow decline after a content change | Seasonal topics trending naturally |
| This month vs same month last year | Seasonal businesses | Site changes or URL moves since last year |
| Week before vs week after an update | Checking the effect of a Google update or a release | Too little data on small pages |
Search Console data for the last two or three days is usually incomplete, so end the recent window a few days ago rather than today. Equal-length windows that start on the same weekday stop weekend traffic patterns from looking like losses.
Doing the calculation in Google Sheets
If you exported to Google Sheets, the compare export has one row per page with the two periods side by side. Assuming recent clicks in column B and earlier clicks in column C, add:
D2: =B2 - C2 // click change
E2: =IF(C2 = 0, "", D2 / C2) // % change
F2: =REGEXREPLACE(A2, "^https?://[^/]+", "") // path for the GA4 joinThen pull conversions and sessions from a GA4 tab with XLOOKUP on the path and calculate the estimated lost conversions as in Step 3. Filter column D to negative values and sort by lost conversions. Remove the // comments if you paste these formulas; they are only labels here.
Second worked example: same ranking, fewer clicks
| Metric | Previous | Last | Change |
|---|---|---|---|
| Clicks | 2400 | 1500 | -900 |
| Impressions | 60000 | 60000 | 0 |
| CTR | 4.0% | 2.5% | −1.5 pts |
| Average position | 3.1 | 3 | -0.1 |
Impressions and position barely moved, yet clicks fell by 900 (37.5%). That is the second row of the cause table: something on the results page now takes the clicks. Search the main queries yourself to see what appears above the result, and test a clearer title. A rewrite won't help if an answer box fully satisfies the query, so check the conversion rate before spending time on it.
Pages that vanished or are new
The compare export only lists pages with data in at least one period. A page with clicks before and none now shows 0 in the recent column — check whether it was redirected, deleted or set to noindex with the URL Inspection tool. If a URL was deliberately moved, add its old and new clicks together before judging the loss; otherwise every migration looks like a collapse.
Troubleshooting
| Symptom | Cause | Fix |
|---|---|---|
| Total of page clicks differs from the chart total | Page and site totals are aggregated differently | Compare pages with pages, not with the headline total |
| Conv rate is blank for many pages | Paths don't match GA4 landing pages | Normalise case, trailing slashes and query strings |
| A page lost 100% of clicks | Redirect, noindex or URL change | Inspect the URL and combine old and new URLs |
| Every page fell by a similar share | Seasonality or a tracking-wide change | Compare year over year before acting on single pages |
Checking the result
- Sum the Click change column and compare it with the difference between the two periods' total clicks in the Pages export; they should agree.
- Spot-check two or three pages in the Search Console interface with a page filter and the same compare dates.
- Confirm that the pages with the biggest lost conversions actually have GA4 data: a missing lookup returns 0, which hides a page rather than ranking it.
- Look at queries for the top pages (filter by page, then open the Queries tab) to see which searches drove the loss.
Repeating it monthly
- Export the same compare report on the same day each month, with the same window length.
- Paste it into a fixed sheet layout so the change and lookup formulas keep working.
- Export GA4's organic landing pages for the earlier window and replace the GA4 tab.
- Record the top ten pages by estimated lost conversions and what you changed, so next month you can see whether the fix worked.
For more ways to line up the two sources see combining GA4 and Search Console data, and for a general approach to spotting changes between two exports see comparing two spreadsheets.
Frequently asked questions
- How many clicks does a page need before a drop is meaningful?
- There's no fixed rule, but pages with only a few dozen clicks per period swing widely by chance. Use a longer window or group small pages by folder before drawing conclusions.
- Should I use GA4 conversions from the earlier or the recent period?
- The earlier period. It reflects how the page converted before it lost traffic, which is what the lost clicks would have been worth.
- How do I compare two date ranges in Search Console?
- In the Performance report, open the date filter, choose the Compare tab and select the two periods.
- Why are my clicks down but my position is the same?
- Usually lower click-through rate: new search features, AI Overviews, ads, or a less compelling title can reduce clicks at the same ranking.
- Can I do this for more than 1,000 pages?
- The interface exports 1,000 rows. Use the Search Console API, Looker Studio or the BigQuery bulk export for larger sites.