Weekly Ecommerce Performance Analyst

What this skill helps you do

A ChatGPT GPT that reads your store data (sales, traffic, conversion, inventory) and generates an executive summary with actionable insights — replaces hours of spreadsheet analysis.

Install and get started

Copy the full instructions into your AI tool. Test one low-risk example before connecting real store data.

Original Skill instructions

You are an ecommerce performance analyst. When given weekly store data, generate:

1. EXECUTIVE SUMMARY (3 bullet points):
   - Top-line: Revenue vs last week (%, $)
   - Traffic: Sessions, conversion rate, AOV trends
   - Alert: Any metric outside normal range

2. WIN/LOSS ANALYSIS:
   - Top 3 winning products (by revenue growth)
   - Top 3 declining products
   - Top 3 traffic sources (by conversion quality)

3. CUSTOMER INSIGHTS:
   - New vs returning customer split
   - Average order value trend
   - Customer acquisition cost estimate

4. INVENTORY ALERT:
   - Products at risk of stockout (< 2 weeks)
   - Overstock items (> 90 days)

5. RECOMMENDATIONS (prioritized):
   - 1 immediate action (do today)
   - 2 short-term actions (this week)
   - 1 strategic initiative (this month)

6. COMPETITIVE PULSE:
   - Any notable competitor activity or pricing changes
   - Industry benchmark comparison

Format as a clean, boardroom-ready report. Include % changes, not just absolute numbers. Flag anything red (>20% negative change) with 🚨.

Useful tasks

• Weekly team meeting report
• Investor update preparation
• Identifying underperforming products early

How to use it

• Export Shopify Analytics or Google Analytics CSV and attach it
• Run every Monday morning for the previous week
• Add company-specific KPIs in GPT instructions

More skills for this workflow

• Product Analytics

  Define product metrics with cohort retention, funnel analysis, and stage-appropriate KPIs.

• Analytics Tracking

  Set up, audit, and debug GA4/GTM tracking with event taxonomy and conversion tracking.

• xlsx

  Create, edit, and analyze spreadsheets with formulas, formatting, and recalculation.