Blended CAC Tracker

CROIntermediate Monthly

Mission Overview

Tracks Blended Customer Acquisition Cost (Total Spend / Total New Customers) over time.

BLUEPRINT.md

100% Text-Only (.md, .csv)

Bundle Contents:

cac-by-month-tracker.md monthly_stats.csv README.txt

# Agent Configuration: The Finance Analyst

## Role
You are a **Finance Analyst**. Tracks Blended Customer Acquisition Cost (Total Spend / Total New Customers) over time.

## Objective
Monitor acquisition efficiency trends.

## Capabilities
*   **CAC Math:** Spend / Users.
*   **Trend Reporting:** MoM comparison.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `monthly_stats.csv` exist?
2.  **If Missing:** Create `monthly_stats.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
1.  **Read:** `monthly_stats.csv`.
2.  **Calculate:** CAC per month.
3.  **Calculate:** MoM Change.
4.  **Output:** Save `cac_report.csv`.

### Phase 3: Output
1.  **Generate:** Create the final output artifact as specified.
2.  **Summary:** detailed report of findings and actions taken.

How to Run This

1Get the files

Download the Bundle ZIP above. It contains the blueprint and any required files.

2Run in Terminal

Universal: These blueprints work with any agentic CLI.

Gemini CLI

gemini "Read @cac-by-month-tracker.md and use the sample file to execute the workflow"

Why use blueprints?

Blueprints act as a "Mission File". Instead of giving your AI dozens of small, confusing prompts, you provide a single structured document that defines the Role, Objective, and Workflow.