Cac By Month Tracker

Name: Cac By Month Tracker
Author: akhilkannur

ASecurity

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?').

4 stars
0 votes
0 copies
1 view
Added May 28, 2026

ai-agentsgo

Security analysis

A100/100

Scanned May 28, 2026

npx -y skills add akhilkannur/marketing-agent-blueprints --skill cac-by-month-tracker --agent claude-code

Installs into .claude/skills of the current project.

Are you the author of Cac By Month Tracker?

Add the live security badge to your README. It updates with every re-scan.

Security grade badge for Cac By Month Tracker

[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/akhilkannur-cac-by-month-tracker/badge)](https://www.skillsdirectory.com/skills/akhilkannur-cac-by-month-tracker)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro

SKILL.md

--- 
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)*