Chapter 01: Chapter 1 · Pick the 20 pages that matter (week 1)
Export impressions, clicks and orders per product from Search Console and your Shopify admin, then choose 20 pages: the ones with the most revenue, plus the ones with high impressions and few clicks. Fixing a short list beats lightly touching 400 products, and it makes the result measurable.
Build the shortlist
In Search Console, open Performance, filter to the last 90 days, switch to the Pages tab and export. Keep only product URLs (those containing /products/). In Shopify admin, open Analytics and export sales by product for the same 90 days. Put both in one sheet, matched on product name.
Pick from three groups. Top revenue: your 8 best sellers, because small gains here pay most. High impressions, low clicks: pages Google already shows, where the title or description is not winning the click. High clicks, low sales: pages that attract visitors but do not convert, where the page itself is the problem. Write down the main query a buyer would use for each one, such as "oxidised silver jhumkas" or "cold pressed groundnut oil 5 litre".
| Product URL | Main buyer query | Clicks (90 days) | Orders (90 days) | Clicks at week 4 | Orders at week 4 |
|---|---|---|---|---|---|
| /products/oxidised-silver-jhumkas | oxidised silver jhumkas | blank | blank | blank | blank |
| blank | blank | blank | blank | blank | blank |
| blank | blank | blank | blank | blank | blank |
| blank | blank | blank | blank | blank | blank |
- A sheet with 20 product URLs and their baseline numbers
- The main buyer query written next to each one
