Ecom analytics
Skill charlieviettq/awesome-agent-skill/.claude/skills/ecom-analytics
Curated skill pack for LLM agents in engineer and science workflow (Cursor & Claude ready).
npx -y skills add charlieviettq/awesome-agent-skill --skill ecom-analyticsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 22 stars22 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
"Analyze e-commerce performance using GA4 metrics, conversion funnel analysis, and key e-commerce KPIs. Use this skill when the user needs to evaluate online store performance, diagnose conversion drop-offs, set up e-commerce tracking, or create performance dashboards — even if they say 'why are sales down', 'optimize our online store', 'set up GA4 for e-commerce', or 'what metrics should we track'.".
SKILL.md
4.9 KB, as published. Nobody here has run it
E-Commerce Analytics
Overview
E-commerce analytics measures online store performance across traffic, conversion, and revenue dimensions. This skill covers GA4 e-commerce tracking setup, funnel analysis, and key metric interpretation to diagnose why a store is or isn't performing.
Framework
IRON LAW: Diagnose by Funnel Stage, Not by Symptom
"Sales are down" is a symptom, not a diagnosis. Decompose into funnel stages:
Traffic × Conversion Rate × AOV = Revenue
If revenue drops 20%, is it because traffic dropped (acquisition problem),
conversion dropped (UX/pricing problem), or AOV dropped (product mix problem)?
Each requires a completely different fix.
E-Commerce Funnel & Key Metrics
| Stage | Metrics | What It Tells You |
|---|---|---|
| Acquisition | Sessions, Users, Traffic sources, CPC, CAC | Are you attracting enough visitors? From where? At what cost? |
| Engagement | Pages/session, Time on site, Bounce rate, Product views | Are visitors interested? Are they browsing? |
| Conversion | Add-to-cart rate, Checkout initiation rate, Purchase conversion rate | Where in the funnel are they dropping off? |
| Revenue | Revenue, AOV, Items per order, Revenue per session | How much are they spending? Is the mix healthy? |
| Retention | Repeat purchase rate, Purchase frequency, Customer lifetime value | Are they coming back? |
GA4 E-Commerce Events
| Event | Trigger | Key Parameters |
|---|---|---|
view_item | Product page view | item_id, item_name, price, category |
add_to_cart | Add to cart click | items array, value, currency |
begin_checkout | Checkout started | items, value, coupon |
add_payment_info | Payment entered | payment_type |
purchase | Order completed | transaction_id, value, tax, shipping, items |
Diagnosis Framework
Phase 1: Traffic Check
- Is total traffic up/down/flat vs prior period?
- Which channels changed? (organic, paid, social, direct, referral)
- Is traffic quality declining? (bounce rate, pages/session by source)
Phase 2: Conversion Check
- Where is the biggest funnel drop-off?
- Compare: View → Add to cart → Checkout → Purchase
- Industry benchmark conversion rates: 1-3% overall, 5-10% add-to-cart
Phase 3: Revenue Check
- AOV trend: rising (upselling working) or falling (discounting eroding value)?
- Product mix: is revenue shifting to lower-margin products?
- Revenue per session: the master metric (traffic quality × conversion × AOV)
Phase 4: Retention Check
- Repeat purchase rate by cohort
- Time between first and second purchase
- LTV trend by acquisition channel
Output Format
# E-Commerce Performance Report: {Store}
## Summary Dashboard
| Metric | Current | Prior Period | Change | Status |
|--------|---------|-------------|--------|--------|
| Sessions | {N} | {N} | {%} | 🟢/🟡/🔴 |
| Conversion Rate | {%} | {%} | {%} | 🟢/🟡/🔴 |
| AOV | ${X} | ${X} | {%} | 🟢/🟡/🔴 |
| Revenue | ${X} | ${X} | {%} | 🟢/🟡/🔴 |
## Funnel Analysis
| Stage | Volume | Rate | Drop-off | Benchmark |
|-------|--------|------|----------|-----------|
| Sessions | {N} | 100% | — | — |
| Product Views | {N} | {%} | {%} | — |
| Add to Cart | {N} | {%} | {%} | 5-10% |
| Checkout | {N} | {%} | {%} | 40-60% of ATC |
| Purchase | {N} | {%} | {%} | 1-3% overall |
## Diagnosis
- Primary issue: {funnel stage} — {specific problem}
- Root cause: {analysis}
## Recommendations
1. {action targeting the diagnosed stage}
Gotchas
- Conversion rate is meaningless without traffic quality context: A 5% conversion rate from email (high-intent) and 0.5% from display ads (low-intent) are both normal. Don't compare across channels.
- GA4 sessions ≠ Universal Analytics sessions: GA4 uses event-based model. Session timeout and attribution rules differ. Expect 5-15% discrepancy during migration.
- Mobile conversion is always lower: Mobile: 1-2%, Desktop: 3-5% is typical. Don't mix them in one number — analyze separately.
- Seasonality matters: Compare same period YoY, not just MoM. E-commerce has strong seasonal patterns (11.11, Christmas, Chinese New Year).
- Revenue ≠ profit: A 20% revenue increase from aggressive discounting may reduce profit. Track margin alongside revenue.
References
- For GA4 setup guide, see
references/ga4-setup.md - For e-commerce benchmark data by industry, see
references/ecom-benchmarks.md