| name | discount-analytics |
| description | Track promotional code performance and marketing attribution. Shows redemptions, revenue, conversion rates, and ROI by discount code. Identifies which marketing channels drive sales. Triggers on "discount analytics", "promo code performance", "which codes work", "marketing attribution", or similar queries. |
| allowed-tools | Bash, Read |
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
Step 3: Calculate Metrics
Per-code metrics:
const metrics = {
code: "LAUNCH50",
redemptions: 45,
redemption_rate: "45%",
total_revenue: 337.50,
gross_revenue: 675.00,
discount_amount: 337.50,
average_order: 7.50,
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:
{
gross_revenue: 15.00,
discount_amount: 7.50,
actual_revenue: 7.50,
attribution: "LAUNCH50",
profit_margin: "50%",
}
Lifetime Value (LTV) tracking:
{
acquisition_code: "LAUNCH50",
first_order: 7.50,
repeat_orders: 15.00,
total_ltv: 22.50,
acquisition_cost: 7.50,
ltv_to_cac_ratio: 3.0,
}
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:
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
