# Bundle Efficacy Tracker

> ---

- Skill: `akhilkannur/bundle-efficacy-tracker` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/bundle-efficacy-tracker`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/bundle-efficacy-tracker/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: akhilkannur (https://skillmd.com/u/akhilkannur)
- Updated: 2026-09-17
- Page: https://skillmd.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)*