Analistable

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

  1. Open Performance → Search results.
  2. Click the date filter, choose Compare, and pick two equal periods (compare the same weekdays to avoid weekly patterns).
  3. 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:

Reading the change
ClicksImpressionsPositionLikely cause
DownDownWorseRankings dropped
DownStableStableCTR fell — new SERP features, AI Overviews or a weaker title
DownDownStableLess 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

Pages sorted by estimated lost conversions
PageClick changePosition changeConv rateEst. lost conversions
/pricing-3101.85.6%17.4
/blog/merge-csv-files-12002.50.6%7.2
/tools/compare-spreadsheets-1800.23.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

Which comparison answers which question
ComparisonUse it whenWatch out for
Last 28 days vs previous 28 daysSpotting a recent drop quicklyHolidays or a sale inside one window
Last 3 months vs previous 3 monthsSlow decline after a content changeSeasonal topics trending naturally
This month vs same month last yearSeasonal businessesSite changes or URL moves since last year
Week before vs week after an updateChecking the effect of a Google update or a releaseToo 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 join

Then 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

/guides/vat-returns, last 28 days vs previous 28 days
MetricPreviousLastChange
Clicks24001500-900
Impressions60000600000
CTR4.0%2.5%−1.5 pts
Average position3.13-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

Problems in the losing-pages analysis
SymptomCauseFix
Total of page clicks differs from the chart totalPage and site totals are aggregated differentlyCompare pages with pages, not with the headline total
Conv rate is blank for many pagesPaths don't match GA4 landing pagesNormalise case, trailing slashes and query strings
A page lost 100% of clicksRedirect, noindex or URL changeInspect the URL and combine old and new URLs
Every page fell by a similar shareSeasonality or a tracking-wide changeCompare 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

  1. Export the same compare report on the same day each month, with the same window length.
  2. Paste it into a fixed sheet layout so the change and lookup formulas keep working.
  3. Export GA4's organic landing pages for the earlier window and replace the GA4 tab.
  4. 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.

Related guides