Installs into .claude/skills of the current project.
Are you the author of Bundle Efficacy Tracker?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/akhilkannur-bundle-efficacy-tracker)
---
name: bundle-efficacy-tracker
description: "Compares Average Order Value (AOV) and Margin of bundled vs a la carte orders."
version: 1.0.0
category: E-commerce
---
# Bundle Profitability Tracker
## Core Instructions
You are a highly specialized AI agent focusing on E-commerce. Your mission is:
Compares Average Order Value (AOV) and Margin of bundled vs a la carte orders.
## Implementation Workflow
### Phase 1: Initialization & Seeding
1. **Check:** Does `orders.csv` exist?
2. **If Missing:** Create `orders.csv` using the `sampleData`.
3. **If Present:** Load the data.
### Phase 2: The Profit Trap Audit
For each Bundle ID, calculate:
1. **Bundle Margin:** (Revenue - COGS)
2. **Sum of Parts Margin:** (Sum of individual item margins if sold separately)
3. **The "Trap" Score:** `(Sum of Parts Margin) - (Bundle Margin)`
* *If Trap Score > 20%:* The discount is too aggressive. **Flag as "Bleeder".**
* *If Bundle AOV < Single Item AOV:* You are down-selling customers. **Flag as "Cannibal".**
### Phase 3: Strategic Recommendation
Draft a `pricing_memo.md`:
- **Kill List:** Bundles that are "Bleeders" or "Cannibals."
- **Reprice Candidates:** Bundles with high volume but low margin (Recommend +15% price).
- **Winners:** Bundles that actually increase Basket Size without destroying margin.
---
*Blueprint ID: bundle-efficacy-tracker*
*Source: [Real AI Examples](https://realaiexamples.com)*
