メニュー
Analyze e-commerce metrics and create actionable dashboards. Calculate KPIs, track trends, and generate insights from sales, traffic, and conversion data.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
电商运营套装 - 竞品监控、库存预警、价格追踪、评论分析。24小时自动化运营，省时省力。
Analyze customer review sentiment for e-commerce products. Extract insights from positive/negative reviews, identify improvement opportunities, and track sentiment trends over time.
Analyze customer review sentiment for e-commerce products. Extract insights from positive/negative reviews, identify improvement opportunities, and track sentiment trends over time.
Generate and schedule social media content for e-commerce. Create product posts, promotional content, and engagement captions for Instagram, TikTok, Twitter, and Facebook.
Monitor competitor prices, products, and reviews for e-commerce businesses. Track pricing changes, new product launches, and customer sentiment.
Create and automate e-commerce email sequences. Build welcome series, cart abandonment emails, post-purchase flows, and re-engagement campaigns with proven templates.
SOC 職業分類に基づく
| name | ecommerce_analytics_dashboard |
| description | Analyze e-commerce metrics and create actionable dashboards. Calculate KPIs, track trends, and generate insights from sales, traffic, and conversion data. |
Analyze e-commerce metrics and create actionable business insights.
Use this skill when the user wants to:
Gather available metrics:
Sales Metrics:
Traffic Metrics:
Conversion Metrics:
Calculate key performance indicators:
## Core E-Commerce KPIs
### Revenue Metrics
| Metric | Formula | This Period |
|--------|---------|-------------|
| Average Order Value (AOV) | Revenue / Orders | $[X] |
| Revenue per Visitor (RPV) | Revenue / Visitors | $[X] |
### Conversion Metrics
| Metric | Formula | This Period |
|--------|---------|-------------|
| Conversion Rate | Orders / Sessions × 100 | X% |
| Cart Abandonment | 1 - (Checkouts/Add-to-Cart) | X% |
| Checkout Abandonment | 1 - (Purchases/Checkouts) | X% |
### Customer Metrics
| Metric | Formula | This Period |
|--------|---------|-------------|
| Customer Acquisition Cost (CAC) | Spend / New Customers | $[X] |
| Customer Lifetime Value (LTV) | AOV × Orders/Year × Retention Years | $[X] |
| LTV:CAC Ratio | LTV / CAC | X:1 |
### Marketing Metrics
| Metric | Formula | This Period |
|--------|---------|-------------|
| Return on Ad Spend (ROAS) | Revenue / Ad Spend | Xx |
| Marketing Efficiency Ratio | (Revenue - COGS - Ad Spend) / Ad Spend | X% |
Compare periods (Week-over-Week, Month-over-Month, Year-over-Year):
## Trend Analysis
### Positive Trends
- [Metric] increased by [X]% (positive)
- [Explanation of driver]
### Negative Trends
- [Metric] decreased by [X]% (watch)
- [Root cause hypothesis]
### Flat Trends
- [Metric] flat (opportunity for improvement)
Create visual-style text dashboards:
## 📊 Performance Dashboard
### Revenue Summary
┌─────────────────────────────────────────┐
│ Total Revenue: $[XXX,XXX] ▲ +XX% │
│ Orders: [X,XXX] ▲ +XX% │
│ AOV: $[XX] ▼ -X% │
└─────────────────────────────────────────┘
### Funnel Performance
[████████████░░░░] Sessions: XXX,XXX
[██████░░░░░░░░░] Add to Cart: XX%
[███░░░░░░░░░░░░] Checkout: XX%
[█░░░░░░░░░░░░░░] Purchase: XX%
### Top 3 Insights
1. [Insight with metric]
2. [Insight with metric]
3. [Insight with metric]
### Recommended Actions
- [Priority action based on data]
- [Secondary action]
| Metric | Poor | Average | Good | Excellent |
|---|---|---|---|---|
| Conversion Rate | <1% | 1-2% | 2-4% | >4% |
| AOV | <$50 | $50-100 | $100-150 | >$150 |
| Cart Abandonment | >85% | 70-85% | 60-70% | <60% |
| LTV:CAC | <1:1 | 1:1-3:1 | 3:1-5:1 | >5:1 |
| ROAS | <1x | 1-3x | 3-5x | >5x |