5,000 product pages were getting fine traffic. The category pages were dying.
We focused on the50 pages that actually drive revenue.

The client ran a 5,000-SKU DTC store with strong brand recognition and roughly $3M ARR. Product page traffic from search was decent. Category page traffic — the pages that drove genuine discovery — was rotting. Their previous SEO agency had spent two years writing 500-word blocks for individual products and had ignored the category layer entirely.

The deeper problem: 'best X for Y' searches in their vertical now trigger Google AI Overviews on most queries, and the AI Overviews cite competitor category pages — not theirs. The traffic was leaving before users reached the site at all.

We started by pulling GA4 + Shopify revenue data and identifying which 35 keywords drove 80% of search revenue. Every keyword mapped to a category page. Those 35 pages became the entire focus of the engagement — not the 5,000 product pages.

Each rebuilt category page got: rewritten on-page copy structured for AI Overview citation (TL;DR, comparison tables, FAQ schema, buying guide elements), schema saturation (ItemList, FAQPage, BreadcrumbList, AggregateRating), proper faceted navigation handling so filtered URLs didn't dilute authority, and Core Web Vitals optimization on the category template.

Product pages got templated improvements only — a one-time PDP template upgrade that added Product/Offer/AggregateRating schema sitewide. No manual product-by-product work. The math doesn't justify it on a 5,000-SKU site.

Within 90 days, 18 of the 35 rebuilt pages were ranking better than they had at any point in the previous 24 months. AI Overview placements started appearing on category-pattern queries by month 4 — 12 placements landed by the end of the engagement.

Search-attributed revenue grew 228% over the 6-month window, comparing Aug 2025 to Feb 2025 baseline. The product-page template upgrade also lifted PDP impressions by ~40%, despite no manual product page work — the schema sweep was the entire driver.

Revenue-weighted prioritization is the only ecommerce SEO playbook that actually works on stores with thousands of SKUs. The instinct to 'optimize every page' is the trap that sinks most ecommerce SEO engagements.

AI Overviews on commercial queries are a bigger threat to ecommerce SEO than most operators realize. The AI Overview cites the brand it considers most authoritative — usually a competitor with better category page structure, not necessarily a bigger brand. Catching up is achievable; ignoring it is fatal.