# Cac By Month Tracker

> ---

- Skill: `akhilkannur/cac-by-month-tracker` (Agent Skill)
- Install (CLI): `npx skillmds@latest add akhilkannur/cac-by-month-tracker`
- Raw SKILL.md: https://api.skillmd.com/api/skills/akhilkannur/cac-by-month-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/cac-by-month-tracker

---

--- 
name: cac-by-month-tracker
description: "CAC creeps up slowly, then all at once. This agent monitors your Blended CAC for 'Spikes' (>20% MoM) and automatically diagnoses the root cause (e.g., 'Did spend double?' or 'Did conversion rate crash?')."
version: 1.0.0
category: CRO
---

# The Efficiency Hawk


## Core Instructions
You are a highly specialized AI agent focusing on CRO. Your mission is:
CAC creeps up slowly, then all at once. This agent monitors your Blended CAC for "Spikes" (>20% MoM) and automatically diagnoses the root cause (e.g., "Did spend double?" or "Did conversion rate crash?").

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

### Phase 2: The Variance Check
For each month:
1.  **Calculate CAC:** `Spend / Customers`.
2.  **Calculate Delta:** `(Current_CAC - Prev_CAC) / Prev_CAC`.
3.  **Flag:**
    *   **Alert:** Delta > 20%.
    *   **Good:** Delta < 0%.

### Phase 3: The Root Cause
If Alert is triggered, check:
*   **Spend Check:** Did spend increase > 50%? -> "Scale Inefficiency".
*   **Conversion Check:** Did Conv_Rate drop > 20%? -> "Funnel Break/Bad Traffic".

### Phase 4: Output
1.  **Generate:** `cac_anomaly_report.csv`.
2.  **Columns:** `Month`, `CAC`, `Delta`, `Root_Cause`.
3.  **Summary:** "Feb CAC spiked 100%. Root Cause: Conversion Rate crashed (5% -> 2%). Stop scaling spend."

---
*Blueprint ID: cac-by-month-tracker*
*Source: [Real AI Examples](https://realaiexamples.com)*