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
Check: Does orders.csv exist?
If Missing: Create orders.csv using the sampleData.
If Present: Load the data.
Phase 2: The Profit Trap Audit
For each Bundle ID, calculate:
Bundle Margin: (Revenue - COGS)
Sum of Parts Margin: (Sum of individual item margins if sold separately)
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.
1---2name: bundle-efficacy-tracker3description: ---4---5--- 6name: bundle-efficacy-tracker7description: "Compares Average Order Value (AOV) and Margin of bundled vs a la carte orders."8version: 1.0.09category: E-commerce10---1112# Bundle Profitability Tracker131415## Core Instructions16You are a highly specialized AI agent focusing on E-commerce. Your mission is:17Compares Average Order Value (AOV) and Margin of bundled vs a la carte orders.1819## Implementation Workflow20### Phase 1: Initialization & Seeding211. **Check:** Does `orders.csv` exist?222. **If Missing:** Create `orders.csv` using the `sampleData`.233. **If Present:** Load the data.2425### Phase 2: The Profit Trap Audit26For each Bundle ID, calculate:271. **Bundle Margin:** (Revenue - COGS)282. **Sum of Parts Margin:** (Sum of individual item margins if sold separately)293. **The "Trap" Score:** `(Sum of Parts Margin) - (Bundle Margin)`30 * *If Trap Score > 20%:* The discount is too aggressive. **Flag as "Bleeder".**31 * *If Bundle AOV < Single Item AOV:* You are down-selling customers. **Flag as "Cannibal".**3233### Phase 3: Strategic Recommendation34Draft a `pricing_memo.md`:35- **Kill List:** Bundles that are "Bleeders" or "Cannibals."36- **Reprice Candidates:** Bundles with high volume but low margin (Recommend +15% price).37- **Winners:** Bundles that actually increase Basket Size without destroying margin.3839---40*Blueprint ID: bundle-efficacy-tracker*41*Source: [Real AI Examples](https://realaiexamples.com)*42
Run npx skillmds@latest add akhilkannur/bundle-efficacy-tracker in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.
--- It is listed under Coding & Dev Tools on SkillMD.
This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.
This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.
Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.
akhilkannur (@akhilkannur) published this skill. Their other Agent Skills are listed on their SkillMD profile.
akhilkannur