← Back to Blog

SEO Case Study: Fixing 404s, Indexing and CTR on a New Site

By Hassan · Published November 4, 2026 · Updated November 9, 2026 · Data: Google Search Console · 12 min read

This is a case study of this website, DigitalSkillEarnHub. Every number comes from our own Google Search Console. There is no client data here, and we do not claim results we do not have yet.

Summary

  • Starting point: 14 clicks and 12,447 impressions in 28 days, a CTR of about 0.11%.
  • Biggest problem: every inner page returned a 404 after a redeploy. The cause was a file named htaccess instead of .htaccess.
  • Second problem: 43 of 108 known URLs were not indexed, and some pages had only one internal link.
  • Third problem: about 80% of impressions came from pages at average position 21 or lower, so the low CTR was a ranking problem before it was a title problem.
  • Status: fixes went live on November 2, 2026. It is too early to report results, so this post will be updated. See the November 9 update below.

Starting snapshot

The site is a small SEO and digital skills blog on shared cPanel hosting. These are the Search Console figures for the 28 days from September 22 to October 19, 2026:

  • Clicks: 14
  • Impressions: 12,447
  • Average CTR: about 0.11%
  • Average position: roughly 28 to 31, depending on device
Line chart of daily Google impressions from September 22 to October 19, 2026, peaking at 729 on October 6
Daily impressions in the 28-day window. The site is being shown to searchers every day, but almost nobody clicks.

The country split shows the problem clearly. The United States produced 7,562 impressions and 1 click. Pakistan produced 96 impressions and 7 clicks, because those pages sit at an average position of 18.6 there, much closer to page 1 than the 31.4 in the US.

Bar chart of impressions by country: United States 7,562 with 1 click, Spain 258, India 255, Pakistan 96 with 7 clicks
Impressions and clicks by country. Visibility is not the same as clicks: position decides.

Problem 1: sitewide 404 errors

After a redeploy, the homepage worked but every inner page returned a 404. Two things were wrong:

  1. Folder structure. The live server held blog files flat in public_html, while the URLs expected a /blogs/ folder.
  2. A missing dot. The rewrite rules were saved as htaccess, not .htaccess. Without the leading dot, the server ignored the file completely, so no clean-URL rule ran.
Diagram comparing a request to /about with a file named htaccess, which returns 404, and a file named .htaccess, which rewrites to about.html and returns 200 OK
Why only the homepage worked: the root URL maps to index.html without any rewrite rule.

The fix was to restore the correct /blogs/ structure, add fallback rules for extensionless URLs, and rename the file to .htaccess. A rule like this one lets /blogs/post-name find blogs/post-name.php or .html:

RewriteCond %{DOCUMENT_ROOT}/blogs/$1.php -f
RewriteRule ^blogs/([^/]+)/?$ blogs/$1.php [L,END,QSA]

RewriteCond %{DOCUMENT_ROOT}/blogs/$1.html -f
RewriteRule ^blogs/([^/]+)/?$ blogs/$1.html [L,END]

The whole site came back as soon as the file was named correctly.

Lesson: when only the homepage works, check that the rules file is actually named .htaccess, and turn on "Show Hidden Files (dotfiles)" in cPanel File Manager so you can see it. Our 301 redirect strategy guide covers the redirect side.

Problem 2: overlapping posts

We had four posts about the same topic, website migrations. They competed with each other and none stood out. We merged them with 301 redirects:

Old URLNow redirects to
/blogs/avoid-traffic-loss-migration/blogs/website-migration-seo-checklist
/blogs/seo-migration-testing/blogs/website-migration-seo-checklist
/blogs/seo-migration-mistakes-to-avoid/blogs/website-migration-seo-checklist
/blogs/seo-traffic-dropped-after-migration/blogs/page-with-redirect-google-search-console

One strong page usually beats four thin ones, and the redirects pass the old URLs' signals to it.

Problem 3: pages not indexed

On November 3, the Page indexing report showed 65 pages indexed and 43 not indexed.

Stacked bar showing 65 indexed pages and 43 not indexed pages in Google Search Console on November 3, 2026
The indexing report. Not every non-indexed URL is a problem.

Not every reason in the report needs a fix:

  • Page with redirect and Excluded by noindex were expected. They are old URLs that redirect and pages we chose to hide.
  • Crawled – currently not indexed was the real issue. Google had visited those pages and chosen not to index them. Our guide to this status covers the causes.
  • Not found (404) needed a check, to be sure no real page was in the list.

In the URL Inspection tool, one of these pages was crawled and allowed, but had very few internal links pointing to it. That pointed to internal linking, not a technical block. See also Page with redirect in Google Search Console.

Problem 4: impressions but almost no clicks

Bar chart of Google impressions by average position: 193 at positions 1-10, 2,310 at 11-20, 2,711 at 21-30, 6,473 at 31-50, 997 at 51 and below
Impressions by average position. Only about 1.6% came from page 1. The last bar, labeled “50 and below” in the image, means positions 51 and below. The five bars add up to 12,684, about 237 more than the 12,447 headline total; both figures come from Search Console exports and we have not reconciled the gap.

Low CTR is only a title problem on page 1. Only about 1.6% of our impressions came from pages in positions 1 to 10. About half came from positions 31 to 50, where almost nobody clicks. So the first job was to rank higher. We still rewrote titles and descriptions for the pages closest to page 1, using the exact wording people searched. Examples:

PageBeforeAfter
Low competition keywordsHow to Find Low-Competition Keywords: SEO GuideLow Competition Keywords: How to Find Them (Step by Step)
SERP featuresHow to Analyze SERP Features: Practical SEO GuideHow to Analyze SERP Features & Search Intent (Guide)
LSI keywordsLSI Keywords vs Semantic SEO: What Actually Matters? (SEO Strategy Guide)LSI Keywords vs Semantic SEO: What Actually Works

For example, "low competition keywords" had 234 impressions at an average position of 32.9, and several SERP feature queries sat at positions 13 to 25. Those pages have the best chance of reaching page 1. We also shortened about 25 titles that were over 65 characters, because Google cuts long titles off. See also 9 fixes for low CTR and impressions but no clicks.

An audit of our own pages found ten pages that had only one internal link pointing to them. We added "Related reading" boxes from relevant posts. Here are two of them:

PageInternal links beforeAfter
fix-search-intent-existing-content15
trend-based-seo-strategy15

Four other pages, a QA post and three sample project pages, also got more links, but we later set them to noindex (see the November 9 update).

See internal linking after a migration for the method.

The checklist we used

  1. Make sure the rules file is named .htaccess and sits in public_html.
  2. Open the live URLs in a private window and check for 404s.
  3. Compare the sitemap to the real files, so every sitemap URL exists and none redirects.
  4. Merge posts that compete for the same topic, and 301 the old URLs.
  5. Read the Page indexing report and separate expected reasons from real ones.
  6. Count internal links to each page and fix the pages with one or none.
  7. Shorten titles over about 60 characters and descriptions over about 160.
  8. Update lastmod in the sitemap, resubmit it, and request indexing for changed pages.

Results so far

It is too early to report results. The title, link and sitemap changes went live on November 2, 2026, and Google usually needs a few weeks to re-crawl and re-rank pages. We will add a follow-up table here with the same 28-day Search Console comparison, once we have the data. Until then, the only performance numbers in this case study are the starting ones. The November 9 update below is an audit of the site, not a ranking result.

Update, November 9, 2026

After the first fixes went live on November 2, we pulled a new Search Console export (August 4 to November 3, 2026) and audited the sitemap. These are facts about the site, not ranking results.

What the export shows

MonthClicksImpressionsAverage of daily positions
August712,93829.5
September2215,73024.7
October1213,33040.2
November 1-361,48356.1

The average position got worse, from about 25 in September to about 40 in October and about 56 in the first three days of November. We do not know the cause yet. One likely part is that more pages and queries now appear in the results, and most of them start on page 3 or deeper, which pulls the average down. We will compare page by page before drawing a conclusion.

Which sitemap pages are probably indexed

Of the 75 URLs in our sitemap, 61 had at least one impression in that export, which means Google has indexed them. The other 14 had none. This is our own estimate, not Google's Page indexing report. Our checks found no noindex tag, wrong canonical or missing file on any of the 14, so the cause is content: one page was new, three were short sample pages, and ten covered topics that overlap other posts on this site.

What we changed on November 9

  • Set five thin or out-of-date pages to noindex and removed them from the sitemap, which now lists 70 URLs: three sample project pages, an off-topic QA post and a post about an older Google update.
  • Added a short "Quick answer" box to eight overlapping posts, so each page states its own purpose and links to its closest sibling.
  • Added sections that answer queries we already appear for, such as SERP analysis tips and the low competition keywords list.
  • Removed unsupported claims from older posts, such as promised results.
  • Added more internal links to this case study and between related posts, and updated the sitemap dates.

Next check: a new export around November 25, compared with the same pages in this one. We will add the real change here, whether it is better or worse.

Lessons

  1. Name your rules file correctly, and show hidden files in your file manager.
  2. Do not fix every line in the indexing report. Separate expected reasons (redirects, noindex) from real ones.
  3. Merge posts that compete for the same topic, and redirect the old URLs.
  4. Internal links are one of the cheapest ways to signal that a page matters.
  5. Judge CTR only where you rank on page 1. Otherwise, work on position first.

Frequently asked questions

Why did only the homepage work after the redeploy?

The homepage loads index.html without any rewrite rule. Every other clean URL, such as /about, needs the rules in .htaccess. The server ignored the rules because the file was saved as htaccess, without the leading dot, so every inner page returned a 404.

How do I check that my .htaccess file is working?

Turn on Show Hidden Files in cPanel File Manager and confirm the file is named .htaccess in public_html. Then open a clean URL in a private window. If it loads, the rules are active. If you get a 404, the file name or its location is wrong.

What does Crawled – currently not indexed mean?

It means Google visited the page, could read it, and chose not to add it to the index yet. It is not an error. It usually points to thin or similar content, or too few internal links, rather than a technical block.

How do I get a crawled but not indexed page indexed?

Make the page clearly different from your other posts, add internal links to it from related pages, improve the content so it answers the query fully, then request indexing in URL Inspection. Google may still take a few weeks to decide.

Are Page with redirect and Excluded by noindex errors?

No. Page with redirect lists old URLs that correctly redirect, and Excluded by noindex lists pages you chose to hide. Both are expected. Only worry if a page you want ranked appears in either list.

Why is my CTR low when I get thousands of impressions?

CTR depends mostly on position. In our data, only about 1.6% of impressions came from positions 1 to 10, and about half came from positions 31 to 50. At those positions almost nobody clicks, whatever the title says.

Does rewriting titles and meta descriptions improve rankings?

Titles help Google understand the page and help users decide to click, so they matter. But a better title mainly raises CTR on page 1. To move up from page 3, you also need stronger content and more internal links.

How long should a title and meta description be?

Keep titles to about 60 characters and descriptions to about 150 to 160, so Google does not cut them off. Put the main keyword near the start, and use the wording people actually search.

How many internal links does a page need?

There is no fixed number, but a page with only one internal link looks unimportant. Aim for at least three to five relevant links to each important page, with descriptive anchor text, from pages on a related topic.

When should I resubmit my sitemap?

Resubmit it after you add pages, change URLs or update lastmod dates. For one changed page, URL Inspection with Request Indexing is enough. Keep redirected and noindex URLs out of the sitemap.

Should I merge posts that cover the same topic?

Usually yes. Several thin posts on one topic compete with each other. Merge them into one strong page and 301 redirect the old URLs to it, so the old links and signals point to a single page.

How long until SEO changes show results in Search Console?

Google needs to re-crawl and re-evaluate pages, which usually takes a few weeks. Compare the same 28-day period before and after, and avoid judging results after only a few days.