القائمة
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 ويثبّتها لك.
استنادا إلى تصنيف 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 |
电商运营套装 - 竞品监控、库存预警、价格追踪、评论分析。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.
Analyze e-commerce metrics and create actionable dashboards. Calculate KPIs, track trends, and generate insights from sales, traffic, and conversion data.
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.