DEV Community

New Seas Tech
New Seas Tech

Posted on

How to Find Shopify Collection Pages That Are Leaking Revenue (Using GSC + Ahrefs)

TL;DR

Your Shopify collection pages are probably showing up in Google search results thousands of times a month - and getting almost no clicks. This post shows you how to use Google Search Console and Ahrefs to find those pages, score them by revenue potential, and know exactly what to fix first.


Why Collection Pages, Not Product Pages

Most store owners optimize product pages because that's where the buy button is. But product pages target specific, low-volume queries - "acacia 6-seat outdoor dining table" has a tiny audience.

Collection pages target category-level queries - "outdoor dining tables," "organic protein powder," "linen bedding" - which carry 40 to 60 percent more search volume than individual product searches. These shoppers know what category they want but haven't picked a product yet. High intent, large audience.

Across more than 70 Shopify clients, collection pages outperform product pages on every revenue-tied metric: higher average search volume, faster ranking gains per optimization hour, and conversion rates two to three times higher per visit.

One furniture client generated $368,700 in organic revenue from 126,000 non-branded clicks over 12 months. The engine: 15 collection pages optimized per month - not thousands of individual product pages.

Collection pages are your money pages. The tools below help you find the ones you haven't unlocked yet.


Step 1: Pull Impression vs. Click Data from Google Search Console

What GSC tells you that other tools can't: how often Google is already surfacing your pages to searchers - and whether those searchers are actually clicking through.

The setup

  1. Open Google Search Console → Performance report
  2. Set date range to last 90 days
  3. Toggle on all four metrics: Total Clicks, Total Impressions, Average CTR, Average Position
  4. Go to the Pages tab and filter URLs containing /collections/

This isolates your collection pages and removes product pages, blog posts, and the homepage from the view.

What to look for

Sort by Impressions descending. Flag any collection page that hits all three of these:

  • High impressions - hundreds or thousands per month
  • CTR below 2 - 3 percent
  • Average position between 8 and 20

These pages have already earned Google's attention. The algorithm is showing them to searchers. Something is stopping the click - and that's fixable.

A collection page sitting at position 11 for a keyword with 8,000 monthly searches at 1.2% CTR is not a failing page. It's one optimization cycle away from meaningful traffic.

Build a scored priority list

Export to a spreadsheet. Add a column that multiplies impressions × (target CTR − current CTR). A fair target CTR benchmark for positions 8 - 15 is 3 - 5%. Pages with the highest scores = largest untapped opportunity. That's your working list.


Step 2: Validate and Expand Each Opportunity in Ahrefs

GSC shows you what's already happening. Ahrefs shows you what's possible.

Check current keyword rankings per page

Go to Site Explorer → your domain → Organic Keywords. Filter by the collection page URL. You'll see every keyword that page ranks for, its position, monthly search volume, and keyword difficulty.

Look specifically for keywords where the page sits at positions 11 - 20 with 5,000+ monthly searches. That's a clear revenue opportunity with a definable gap.

Find keywords the page isn't targeting yet

Open Keyword Explorer for the primary category keyword of each page. Check two things:

  1. SERP overview - if the top five results are other ecommerce collection pages (not editorial content or comparison articles), that's a strong signal your page can compete
  2. "Also rank for" and "Questions" tabs - surface long-tail variations like "outdoor dining tables for small patios" that add volume without requiring a separate page

Combine both datasets to prioritize

The pages worth working on first are those that meet all three criteria:

  • Already generating GSC impressions (Google has indexed them and considers them relevant)
  • Ranking positions 8 - 20 for at least one keyword with meaningful volume
  • Competing against other ecommerce collection pages in the SERP (not editorial content)

These pages already have traction. Your optimization effort has the highest probability of producing a real rankings jump here.


Step 3: Diagnose Why CTR Is Low

Finding the pages is 50% of the work. Understanding the cause tells you what to actually fix.

Weak title tag and meta description

Your title tag and meta description are all a searcher sees before deciding to click. If your title reads "Dining Tables - Store Name" and a competitor reads "Outdoor Dining Tables: 47 Styles for Every Patio | Free Shipping," the click goes to them.

Title tag formula that works: [Primary Keyword] | [Brand Name] - front-load the keyword, stay under 60 characters.

Example: Outdoor Dining Tables | Harbour

Meta description formula: [Primary Keyword] for [specific use case]. Browse [number] styles. [Value prop]. - keep it 155 - 160 characters.

Example: Outdoor Dining Tables for every patio size. Browse 47 styles. Free shipping on orders over $50.

Position just off page one

CTR drop-off between positions is steep. Position 1 typically earns 25 - 30% of clicks. Position 8 earns roughly 3 - 5%. Getting a page from position 12 to position 4 on a 10,000-search/month keyword isn't marginal - it can mean the difference between 300 and 2,500 monthly clicks to a high-converting page.

The levers: on-page content quality, internal linking from blog posts and adjacent collection pages, and backlink authority. Apply them to pages that already have Google's attention for maximum efficiency.


What to Do With Your List

Once you have a prioritized, data-backed list of collection pages, the optimization roadmap is concrete:

  • Rewrite title tags and meta descriptions using the formulas above
  • Add 300 - 500 words of original body copy targeting the primary keyword cluster
  • Build internal links from blog content and related collection pages
  • Clean up crawl budget wasted on filter parameter URLs

The hard part for most Shopify owners isn't the optimization - it's identifying the right pages to begin with. GSC impression data plus Ahrefs keyword validation solves that problem directly.

Your store almost certainly has collection pages Google is already trying to rank. The impressions are there. The revenue is one focused optimization cycle away.


New Seas is an SEO and content agency that works exclusively with Shopify and ecommerce brands. If you want help identifying and optimizing your store's money pages, visit newseas.co to get started.

Top comments (0)