본문으로 건너뛰기
cccskills
무료GitHub에 공개

"ecom-analytics"

"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'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

연동 도구Google Analytics
설치 방법 보기

포함된 파일(4)

  • SKILL.md4.9 KB
  • examples/sample_scenario.md5.1 KB
  • references/ecom-benchmarks.md9.3 KB
  • references/ga4-setup.md11.6 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

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

StageMetricsWhat It Tells You
AcquisitionSessions, Users, Traffic sources, CPC, CACAre you attracting enough visitors? From where? At what cost?
EngagementPages/session, Time on site, Bounce rate, Product viewsAre visitors interested? Are they browsing?
ConversionAdd-to-cart rate, Checkout initiation rate, Purchase conversion rateWhere in the funnel are they dropping off?
RevenueRevenue, AOV, Items per order, Revenue per sessionHow much are they spending? Is the mix healthy?
RetentionRepeat purchase rate, Purchase frequency, Customer lifetime valueAre they coming back?

GA4 E-Commerce Events

EventTriggerKey Parameters
view_itemProduct page viewitem_id, item_name, price, category
add_to_cartAdd to cart clickitems array, value, currency
begin_checkoutCheckout starteditems, value, coupon
add_payment_infoPayment enteredpayment_type
purchaseOrder completedtransaction_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

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

"Implement and select ad bidding strategies from manual CPC to automated target-CPA and target-ROAS. Use this skill when the user needs to choose a bidding strategy, set up automated bidding, or optimize bid parameters — even if they say 'what bidding strategy should I use', 'target CPA setup', or 'smart bidding configuration'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Optimize advertising budget allocation across campaigns using marginal returns analysis. Use this skill when the user needs to distribute budget across multiple campaigns, optimize spend pacing, or maximize overall ROAS under budget constraints — even if they say 'how to split my ad budget', 'campaign budget optimization', or 'diminishing returns on ad spend'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Build CTR prediction models for estimating ad click-through rates from features. Use this skill when the user needs to predict click probability, build an ad ranking model, or evaluate ad creative performance — even if they say 'predict click rate', 'ad relevance scoring', or 'which ad will get more clicks'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Implement Generalized Second Price auction for ad slot allocation and pricing. Use this skill when the user needs to understand search ad auctions, compute ad positions and costs-per-click, or analyze bidding dynamics — even if they say 'how does Google Ads auction work', 'ad rank calculation', or 'second price auction for ads'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Implement VCG mechanism for incentive-compatible ad slot allocation with truthful bidding. Use this skill when the user needs to design a truthful auction mechanism, compute externality-based payments, or understand why platforms may prefer GSP over VCG — even if they say 'truthful auction design', 'VCG payments', or 'incentive-compatible mechanism'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

"Explain blockchain fundamentals including distributed ledger architecture, consensus mechanisms, and block structure. Use this skill when the user needs to understand blockchain concepts, evaluate whether blockchain fits a use case, or design a blockchain-based solution — even if they say 'how does blockchain work', 'do I need blockchain', or 'distributed ledger'.".

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

charlieviettq/awesome-agent-skill262026년 7월 20일 업데이트

charlieviettq의 스킬 모두 보기

이 스킬의 문제 신고