Product Sales Performance Analysis Steps

STEPS:

1. Shopify Admin Dashboard > Analytics > Reporting > open the Total Sales by Product - By Net Items Sold report created by C9

2. Set the date range to: 1 [Month] - 31 [Month] 2025

3. Export the report into CSV.

4. Google Merchant Center Next > Analytics > Custom Reports > open the C9 - Organic Shopping Performance report created by C9

5. Set the date range to: 1 [Month] - 31 [Month] 2025

6. Export the report into CSV.

7. Start a Claude chat.

CLAUDE PROMPTS:

1. PROMPT: [Attach the Shopify report CSV]; "Given this sheet, give me a breakdown in table format the Top 10 Product Types by Net Items Sold (All Products). The columns must include Rank, Product Type, Net Items Sold, % of Total Sales, No of Products, Avg Items per Product, and Top Product (items sold) - where items sold reflects the sum of all its variants"

RESULT: This will give you the Top 10 Product Types by Net Items Sold (All Products) table

2. PROMPT:"Give me the key insights from this breakdown. Include Category Performance, Product-Level Insights, and Strategic Implications"

RESULT: This will give you the Top 10 Product Types by Net Items Sold (All Products) key insights

3. PROMPT: "Using the same sheet, give me a breakdown in table format the Top 10 Product Types by Net Items Sold (Limited to Top 200 Products). The columns must include Rank, Product Type, Net Items Sold, % of Top 200 Sales, No of Products in Top 200, Avg Items per Product, and Top Product (Items Sold in Top 200) - where items sold reflects the sum of all its variants"

RESULT: This will give you the Top 10 Product Types by Net Items Sold (Limited to Top 200 Products) table

4. PROMPT: "Give me the key insights from this breakdown. Include Category Performance, Product-Level Insights, and Strategic Implications"

RESULT: This will give you the Top 10 Product Types by Net Items Sold (Limited to Top 200 Products) key insights

5. PROMPT: [Attach the GMC report CSV]; "Given this sheet, give me a breakdown in table format the Top 10 Product Categories by Organic Performance (All Products) based on combined performance score of clicks (60% weight) and impressions (40% weight). The columns must include Rank, Category, Category Level, Clicks, Impressions, CTR%, No. of Products, and Top Product by Overall Performance (based on clicks and impressions)"

RESULT: This will give you the Top 10 Product Categories by Organic Performance (All Products) table

6. PROMPT: "Give me the key insights from this breakdown. Include Category Performance, Product-Level Insights, and Strategic Implications"

RESULT: This will give you the Top 10 Product Categories by Organic Performance (All Products) key insights

7. PROMPT: “Given this same sheet, give me a breakdown in table format the Top 10 Product Categories by Organic Performance (Limited to Top 200 Products) based on combined performance score of clicks (60% weight) and impressions (40% weight). The columns must include Rank, Category, Category Level, Clicks, Impressions, CTR%, No. of Products, and Top Product by Overall Performance in top 200 (based on clicks and impressions)”

RESULT: This will give you the Top 10 Product Categories by Organic Performance (Limited to Top 200 Products) table

8. PROMPT: "Give me the key insights from this breakdown. Include Category Performance, Product-Level Insights, and Strategic Implications"

RESULT: This will give you the Top 10 Product Categories by Organic Performance (Limited to Top 200 Products) key insights

STEPS CONTINUED:

8. Once you’ve compiled all this information in a doc, export that into pdf.

9. Return to the Claude chat.

CLAUDE PROMPTS:

8. PROMPT: [ATTACH THE DOC]; “Based on this document, give me a summary of findings that would help inform strategic decision making for ecommerce inventory decisions (including replenishment), seo/google merchant center campaign optimisations, and overall marketing development, etc.

RESULT: This will give you the Strategic Summary