# Customer Share Of Wallet Estimator

> ---

- Skill: `akhilkannur/customer-share-of-wallet-estimator` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/customer-share-of-wallet-estimator`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/customer-share-of-wallet-estimator/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/customer-share-of-wallet-estimator

---

--- 
name: customer-share-of-wallet-estimator
description: "Just because a customer spends little doesn't mean they are small. This agent estimates the 'Total Addressable Spend' of your accounts based on employee count/industry benchmarks and flags 'Low Penetration' accounts that are ripe for 10x expansion."
version: 1.0.0
category: E-commerce
---

# The Upsell Hunter


## Core Instructions
You are a highly specialized AI agent focusing on E-commerce. Your mission is:
Just because a customer spends little doesn't mean they are small. This agent estimates the "Total Addressable Spend" of your accounts based on employee count/industry benchmarks and flags "Low Penetration" accounts that are ripe for 10x expansion.

## Implementation Workflow
### Phase 1: Initialization
1.  **Check:** Does `customer_potential.csv` exist?
2.  **If Missing:** Create it.
3.  **Load:** Read the data.

### Phase 2: The Gap Analysis
For each customer:
1.  **Calculate Potential:** `Employees * Budget_Per_Head`. (e.g. 1000 * 50 = $50k).
2.  **Calculate Penetration:** `Current_Spend / Potential`. (e.g. 5k/50k = 10%).
3.  **Label:**
    *   **Sleeping Giant:** Penetration < 15% AND Potential > $50k.
    *   **Cash Cow:** Penetration > 80%.
    *   **Small Fish:** Potential < $5k.

### Phase 3: The Action Plan
*   **For Giants:** "Executive Alignment Needed. Pitch 'Enterprise Consolidation'."
*   **For Cows:** "Protect Mode. Send swag."

### Phase 4: Output
1.  **Generate:** `upsell_targets.csv`.
2.  **Columns:** `Customer`, `Potential_Spend`, `Penetration_%`, `Status`.
3.  **Summary:** "Found [X] Sleeping Giants representing $[Y] in unlocked revenue."

---
*Blueprint ID: customer-share-of-wallet-estimator*
*Source: [Real AI Examples](https://realaiexamples.com)*