majiayu000 Discount Analytics Skill
Purpose: Marketing attribution and promo code ROI tracking
What This Skill Does
Analyzes discount code performance through Lemon Squeezy API:
- Fetch all discount codes
- Calculate redemptions per code
- Track revenue by code (gross vs. discounted)
- Identify top-performing codes
- Calculate conversion rates
- ROI analysis by marketing channel
- Identify underperforming codes
When to Use This Skill
Common use cases:
- Post-launch review: "Which launch codes worked best?"
- Marketing attribution: "Did PODCAST30 drive more sales than EMAIL25?"
- ROI calculation: "Was LAUNCH50 worth the 50% discount?"
- Campaign planning: "What discount % gets best results?"
- Budget allocation: "Which channels should we invest more in?"
- Code cleanup: "Which codes are unused and can be deleted?"
API Authentication
Uses LEMON_SQUEEZY_API_KEY environment variable (already set in Cloudflare).
Usage Examples
Example 1: All-time performance
User: Show me discount code performance
Assistant: [Uses discount-analytics skill to fetch all codes and calculate metrics]
Example 2: Specific code
User: How many people used LAUNCH50?
Assistant: [Filters analytics for LAUNCH50 specifically]
Example 3: Compare codes
User: Which worked better: PODCAST30 or EMAIL30?
Assistant: [Compares redemptions, revenue, and conversion rates]
Implementation
Step 1: Fetch All Discount Codes
Endpoint: GET https://api.lemonsqueezy.com/v1/discounts
Request:
curl "https://api.lemonsqueezy.com/v1/discounts?filter[store_id]=YOUR_STORE_ID&page[size]=100" \
-H "Accept: application/vnd.api+json" \
-H "Authorization: Bearer $LEMON_SQUEEZY_API_KEY"
Response structure:
{
"data": [
{
"type": "discounts",
"id": "1",
"attributes": {
"store_id": 264940,
"name": "Launch Week - 50% Off",
"code": "LAUNCH50",
"amount": 50,
"amount_type": "percent",
"status": "published",
"duration": "once",
"max_redemptions": 100,
"redemptions_count": 45,
"is_limited_redemptions": true,
"expires_at": "2026-01-12T23:59:59Z",
"created_at": "2026-01-05T10:00:00Z"
}
},
{
"type": "discounts",
"id": "2",
"attributes": {
"store_id": 264940,
"name": "Podcast Appearance Code",
"code": "PODCAST30",
"amount": 30,
"amount_type": "percent",
"status": "published",
"duration": "once",
"max_redemptions": null,
"redemptions_count": 23,
"is_limited_redemptions": false,
"expires_at": null,
"created_at": "2026-01-07T10:00:00Z"
}
}
],
"meta": {
"page": {
"currentPage": 1,
"from": 1,
"lastPage": 1,
"perPage": 100,
"to": 2,
"total": 2
}
}
}
Step 2: Fetch Orders with Discount Usage
Endpoint: GET https://api.lemonsqueezy.com/v1/orders
Request:
curl "https://api.lemonsqueezy.com/v1/orders?filter[store_id]=YOUR_STORE_ID&page[size]=100" \
-H "Accept: application/vnd.api+json" \
-H "Authorization: Bearer $LEMON_SQUEEZY_API_KEY"
Filter orders that used discounts:
orders.filter(order => order.attributes.discount_total > 0)
Extract discount code from order:
order.attributes.first_order_item.discount_code // "LAUNCH50"
Step 3: Calculate Metrics
Per-code metrics:
// For each discount code
const metrics = {
code: "LAUNCH50",
redemptions: 45,
redemption_rate: "45%", // 45/100 max redemptions
total_revenue: 337.50, // Sum of all orders with this code (after discount)
gross_revenue: 675.00, // What revenue would have been without discount
discount_amount: 337.50, // Total discount given
average_order: 7.50, // total_revenue / redemptions
status: "Active" | "Expired" | "Maxed Out",
expires: "2026-01-12",
created: "2026-01-05"
};
Overall metrics:
const summary = {
total_codes: 5,
active_codes: 3,
total_redemptions: 112,
total_revenue_with_discounts: 892.00,
total_discount_given: 445.00,
average_discount_percent: 35,
most_popular_code: "LAUNCH50"
};
Step 4: Rank by Performance
Sort by redemptions (popularity):
codes.sort((a, b) => b.redemptions_count - a.redemptions_count);
Sort by revenue (value):
codes.sort((a, b) => b.total_revenue - a.total_revenue);
Sort by conversion rate (efficiency):
codes.sort((a, b) => b.redemption_rate - a.redemption_rate);
Output Format
# 📊 Discount Code Analytics
**Report Generated:** January 6, 2026 at 10:00 AM AEDT
**Reporting Period:** All Time
---
## 💰 Summary
| Metric | Value |
|--------|-------|
| **Total Codes** | 5 active |
| **Total Redemptions** | 112 |
| **Revenue (with discounts)** | $892.00 AUD |
| **Revenue (without discounts)** | $1,337.00 AUD |
| **Total Discount Given** | $445.00 AUD |
| **Average Discount** | 33.3% |
---
## 🏆 Top Performing Codes
### 1. LAUNCH50 - Launch Week Promotion
- **Redemptions:** 45 / 100 (45% utilization)
- **Revenue Generated:** $337.50 AUD (after 50% discount)
- **Gross Revenue Impact:** $675.00 AUD
- **Discount Given:** $337.50 AUD
- **Average Order:** $7.50 AUD
- **Status:** ✅ Active (expires Jan 12)
- **ROI:** Strong - Drove 40% of all sales
### 2. PODCAST30 - Podcast Appearance
- **Redemptions:** 23 (unlimited)
- **Revenue Generated:** $241.50 AUD (after 30% discount)
- **Gross Revenue Impact:** $345.00 AUD
- **Discount Given:** $103.50 AUD
- **Average Order:** $10.50 AUD
- **Status:** ✅ Active (no expiry)
- **ROI:** Excellent - Best revenue per redemption
### 3. EMAIL25 - Email List
- **Redemptions:** 18 (unlimited)
- **Revenue Generated:** $202.50 AUD (after 25% discount)
- **Gross Revenue Impact:** $270.00 AUD
- **Discount Given:** $67.50 AUD
- **Average Order:** $11.25 AUD
- **Status:** ✅ Active (no expiry)
- **ROI:** Good - Consistent performance
### 4. BETA100 - Beta Readers
- **Redemptions:** 20 / 20 (100% utilization - MAXED OUT)
- **Revenue Generated:** $0.00 AUD (100% discount)
- **Gross Revenue Impact:** $300.00 AUD (value delivered)
- **Discount Given:** $300.00 AUD
- **Average Order:** $0.00 AUD
- **Status:** 🔴 Maxed Out
- **ROI:** N/A - Goodwill/marketing investment
### 5. MUSEPANTS - Special Giveaway
- **Redemptions:** 2 / 2 (100% utilization - MAXED OUT)
- **Revenue Generated:** $0.00 AUD (100% discount)
- **Gross Revenue Impact:** $30.00 AUD
- **Discount Given:** $30.00 AUD
- **Average Order:** $0.00 AUD
- **Status:** 🔴 Maxed Out (expires Jan 31)
- **ROI:** N/A - Special reward
### 6. FRIEND15 - Referral Program
- **Redemptions:** 4 (unlimited)
- **Revenue Generated:** $51.00 AUD (after 15% discount)
- **Gross Revenue Impact:** $60.00 AUD
- **Discount Given:** $9.00 AUD
- **Average Order:** $12.75 AUD
- **Status:** ✅ Active (no expiry)
- **ROI:** Low volume, high margin
---
## 📈 Performance Insights
### Best for Volume (Most Redemptions)
1. LAUNCH50 - 45 redemptions
2. PODCAST30 - 23 redemptions
3. BETA100 - 20 redemptions
### Best for Revenue (Highest Total Revenue)
1. LAUNCH50 - $337.50 AUD
2. PODCAST30 - $241.50 AUD
3. EMAIL25 - $202.50 AUD
### Best for Margin (Least Discount Given)
1. FRIEND15 - 15% average discount
2. EMAIL25 - 25% average discount
3. PODCAST30 - 30% average discount
### Highest Average Order Value
1. FRIEND15 - $12.75 per order
2. EMAIL25 - $11.25 per order
3. PODCAST30 - $10.50 per order
---
## 🎯 Marketing Attribution
**Channel Performance:**
| Channel | Code | Redemptions | Revenue | Avg Discount | ROI Grade |
|---------|------|-------------|---------|--------------|-----------|
| Launch Event | LAUNCH50 | 45 | $337.50 | 50% | A+ |
| Podcast | PODCAST30 | 23 | $241.50 | 30% | A |
| Email List | EMAIL25 | 18 | $202.50 | 25% | B+ |
| Referrals | FRIEND15 | 4 | $51.00 | 15% | C |
**Insights:**
- **Launch event** drove 40% of all sales (highest volume)
- **Podcast appearance** had best revenue per redemption ($10.50 avg)
- **Email list** most sustainable (lower discount, steady redemptions)
- **Referral program** low volume (needs promotion)
---
## 💡 Recommendations
### High Priority
1. **LAUNCH50 expiring soon** (Jan 12) - Consider extending or creating LAUNCH25 successor
2. **PODCAST30 performing well** - Book more podcast appearances
3. **BETA100 maxed out** - Create BETA2026 for new batch if needed
### Medium Priority
4. **EMAIL25 steady performer** - Promote more to email list
5. **FRIEND15 underutilized** - Promote referral program more actively
### Low Priority
6. **MUSEPANTS completed** - Archive (2/2 redemptions used)
---
## 🔍 Detailed Code Status
**Active Codes:** 4
- LAUNCH50 (expires Jan 12)
- PODCAST30 (no expiry)
- EMAIL25 (no expiry)
- FRIEND15 (no expiry)
**Maxed Out Codes:** 2
- BETA100 (20/20 used)
- MUSEPANTS (2/2 used)
**Expired Codes:** 0
---
## 📊 Time Series Analysis
**Redemptions Over Time:**
| Date Range | LAUNCH50 | PODCAST30 | EMAIL25 | Total |
|------------|----------|-----------|---------|-------|
| Jan 5-7 | 25 | 0 | 5 | 30 |
| Jan 8-10 | 15 | 12 | 8 | 35 |
| Jan 11-13 | 5 | 11 | 5 | 21 |
**Insights:**
- LAUNCH50 peaked early (launch day excitement)
- PODCAST30 steady post-launch (evergreen content)
- EMAIL25 consistent (recurring campaigns)
---
## 🎨 Campaign Planning
**What worked:**
- ✅ 50% discount drove high volume (45 redemptions)
- ✅ 30% discount had best revenue per redemption
- ✅ Podcast codes convert well (23 redemptions)
- ✅ Time-limited codes create urgency
**What didn't work:**
- ❌ Referral program underutilized (only 4 redemptions)
- ⚠️ 100% discount codes are generous but zero revenue
**Optimize next launch:**
1. Create tiered launch codes:
- EARLYBIRD40 (first 50 customers)
- LAUNCH30 (next 100 customers)
- LAUNCH20 (extended run)
2. More podcast appearances (proven channel)
3. Promote referral program actively
4. Test lower discounts (20-25%) to improve margins
---
## 📉 Underperforming Codes
**Codes with <5 redemptions:**
- FRIEND15: 4 redemptions (needs promotion)
**Action items:**
1. Email existing customers about referral program
2. Add referral CTA to order confirmation
3. Create social media posts promoting FRIEND15
4. Consider increasing incentive (15% → 20%)
Error Handling
No discount codes found:
📭 No Discount Codes Found
**Possible reasons:**
- No codes created yet
- All codes expired/deleted
- API key lacks discount read permissions
**Next steps:**
1. Create first discount code: `/create-discount-code`
2. Verify API key has "Read discounts" permission
3. Check Lemon Squeezy dashboard: https://app.lemonsqueezy.com/discounts
API Error:
❌ Cannot Fetch Discount Analytics
**API Error:** [Error message]
**Common causes:**
- API key lacks discount read permissions
- Network timeout
- Lemon Squeezy service issue
**Solutions:**
1. Verify API key has "Read discounts" scope
2. Retry in 1 minute
3. Check Lemon Squeezy status: https://status.lemonsqueezy.com
Advanced Analytics
Revenue Attribution Model
Full attribution:
// Order used LAUNCH50 (50% off $15 = $7.50 paid)
{
gross_revenue: 15.00, // What order would have been
discount_amount: 7.50, // Amount discounted
actual_revenue: 7.50, // What you received
attribution: "LAUNCH50", // Marketing channel
profit_margin: "50%", // Actual revenue / gross revenue
}
Lifetime Value (LTV) tracking:
// Customer acquired via LAUNCH50, then purchased again at full price
{
acquisition_code: "LAUNCH50",
first_order: 7.50,
repeat_orders: 15.00,
total_ltv: 22.50,
acquisition_cost: 7.50, // Discount given
ltv_to_cac_ratio: 3.0, // Excellent (3:1)
}
Cohort Analysis
By acquisition channel:
| Code | Customers | Repeat Rate | Avg LTV | Best Channel? |
|------|-----------|-------------|---------|---------------|
| LAUNCH50 | 45 | 8% | $8.10 | No (low repeat) |
| EMAIL25 | 18 | 22% | $13.75 | Yes (high repeat) |
| PODCAST30 | 23 | 17% | $12.30 | Good |
**Insight:** EMAIL25 customers more loyal (lower discount → higher perceived value)
A/B Test Results
Test: 30% vs 50% discount
| Metric | 30% Discount | 50% Discount | Winner |
|--------|--------------|--------------|--------|
| Redemptions | 23 | 45 | 50% |
| Revenue | $241.50 | $337.50 | 50% |
| Margin | 70% | 50% | 30% |
| Avg Order | $10.50 | $7.50 | 30% |
**Conclusion:** 50% drives more volume, 30% drives better margins
**Recommendation:** Use 50% for launch, 30% for ongoing
Automation Opportunities
Auto-alerts:
- Code reaching 80% of max redemptions → "LAUNCH50 almost full!"
- Code expiring in 48 hours → "LAUNCH50 expires soon, extend?"
- Code with 0 redemptions after 7 days → "PODCAST30 unused, promote?"
- High-performing code → "EMAIL25 converting well, increase budget?"
Auto-optimization:
- If code >90% redeemed → Auto-create successor code
- If code <5% redeemed after 1 week → Auto-suggest discount increase
- If code driving high repeat purchases → Auto-suggest similar codes
Related Skills
/create-discount-code- Create new codes based on analytics/sales-dashboard- Overall revenue metrics/customer-lookup- See which codes specific customers used
API Documentation
Lemon Squeezy Discounts API:
- List discounts: https://docs.lemonsqueezy.com/api/discounts#list-all-discounts
- Get discount: https://docs.lemonsqueezy.com/api/discounts#retrieve-a-discount
- Discount usage: Calculated from orders API
Export Options
CSV export:
Code,Redemptions,Max Redemptions,Revenue,Discount Given,Status,Expires
LAUNCH50,45,100,$337.50,$337.50,Active,2026-01-12
PODCAST30,23,,-,$241.50,$103.50,Active,-
EMAIL25,18,,-,$202.50,$67.50,Active,-
JSON export:
{
"generated_at": "2026-01-06T10:00:00Z",
"summary": {
"total_codes": 5,
"total_redemptions": 112,
"total_revenue": 892.00
},
"codes": [
{
"code": "LAUNCH50",
"redemptions": 45,
"revenue": 337.50,
"status": "active"
}
]
}
Performance Benchmarks
Industry standards (digital products):
- Redemption rate: 3-8% (percentage of visitors who use code)
- Average discount: 20-30%
- Launch codes: 40-50% typical
- Ongoing codes: 15-25% typical
- 100% codes: Use sparingly (goodwill only)
Your performance:
- LAUNCH50: 45% redemption rate (excellent)
- PODCAST30: 30% discount, 23 redemptions (strong)
- EMAIL25: 25% discount, 18 redemptions (good)
Recommendations:
- You're in the optimal range
- LAUNCH50 drove urgency effectively
- 30% sweet spot for ongoing codes
- Consider testing 20% for higher margins