The data that changed how I think about SEO
I run a niche content site. Last week I pulled 28 days of Google Search Console data and found something that broke my mental model completely.
769 of my pages rank in Google's top 10 positions. Most of them have never received a single click.
Not position 50. Not position 30. Position one through ten. The promised land. And still — nothing.
Here's what the numbers actually look like across 1,684 indexed pages:
- 21,257 total impressions
- 100 total clicks
- 0.47% overall CTR
- 95.2% of pages received zero clicks (1,604 out of 1,684)
The headline stat is bad. But the breakdown is what kept me up at night.
The position bucket breakdown
I grouped every page by its average Google position. Here's what came out:
| Position Range | Pages | Impressions | Clicks | CTR |
|---|---|---|---|---|
| 1–10 | 510 | 3,821 | 48 | 1.26% |
| 11–20 | 386 | 5,412 | 36 | 0.67% |
| 21–30 | 159 | 4,783 | 11 | 0.23% |
| 31–50 | 262 | 4,604 | 5 | 0.11% |
| 51–100 | 287 | 2,637 | 0 | 0.00% |
The position 1–10 bucket looks fine at 1.26%. But zoom in: 510 pages sit in this bucket, and 462 of them got zero clicks. Only 48 pages did any work at all.
Why ranking #1 means nothing (sometimes)
Here's the part that doesn't fit any SEO playbook. Pages at position 1.0 with single-digit impressions:
- "jewelry trends 2026 what people are actually wearing" — position 1.0, 2 impressions, 0 clicks
- "science crystal healing" — position 1.0, 2 impressions, 0 clicks
- "vanadinite mibladen morocco mineral" — position 1.0, 2 impressions, 0 clicks
These pages rank first. They win the SERP. And the reward is 2 impressions. Maybe 0.
The issue isn't ranking. It's that nobody searches for these queries. Position 1 for a query with 2 monthly searches is worth less than position 15 for a query with 500 monthly searches.
My site's most visited page — "jewelry design software guide" — ranks at position 53 with 816 impressions and zero clicks. That page lost not because it's bad content, but because it needed to be on page 1, not page 6, for a query that actually gets volume.
The duplicate content tax: 409 pages, 11,548 wasted impressions
I found another problem hiding in the data. 409 of my 1,684 indexed pages are duplicate entries — the same slug appearing with and without a trailing slash. That's 24.3% of my index wasted on canonical duplicates.
These duplicate pages accumulated 11,548 impressions over 28 days. Google is splitting its crawl budget and index signals across two URLs for the same content.
My .htaccess was set up to handle trailing slashes, but Google had already indexed both variants. The fix is simple — 301 redirects and canonical tags. But I lost weeks of ranking signal before I noticed.
The impression growth trap
Here's the trend that looks like success but isn't:
| Date | Impressions | Clicks | CTR |
|---|---|---|---|
| Jun 18 | 10,441 | 63 | 0.60% |
| Jun 19 | 11,005 | 66 | 0.60% |
| Jun 20 | 11,285 | 66 | 0.58% |
| Jun 21 | 12,114 | 68 | 0.56% |
| Jun 23 | 13,001 | 66 | 0.51% |
Impressions grew 24.5% in five days. Clicks stayed flat at ~66/day. CTR actually dropped from 0.60% to 0.51%.
More impressions at a lower CTR means Google is surfacing my content for more queries, but those queries are progressively less relevant. I'm getting visibility in searches where users don't want what I have. Volume went up. Value went down.
What I'm actually doing about it
Three changes based on the data:
Deleting or redirecting the long-tail dead weight. Pages with position 1–10 but under 5 impressions are ranking for queries nobody cares about. I'm either merging them into higher-volume pages or noindexing them.
Fixing the duplicate slug problem. 409 pages with trailing slash variants need 301 redirects. This alone should consolidate the 11,548 split impressions.
Stopping content production for 30 days. My site has 1,971 pages. Adding more to a 0.47% CTR site is pouring water into a leaky bucket. Fix the existing 95.2% failure rate first.
The uncomfortable question
SEO tools will tell you to "create more content" and "target long-tail keywords." But my data shows 769 pages ranking in the top 10 that generate essentially zero traffic. The long tail isn't a strategy — it's a graveyard.
I'm not saying content doesn't work. I'm saying the default assumption that "more pages = more traffic" broke down for me at around 800 pages. Beyond that, each new page had a diminishing probability of ever getting a click.
What does your Google Search Console data look like? Have you checked how many of your "ranking" pages actually get clicks? I'd be curious if this pattern holds for other niche sites.