Support Cost vs LTV

CROAdvanced Yearly

Mission Overview

Checks if customers with high support ticket volume actually have higher or lower Lifetime Value.

BLUEPRINT.md

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

Bundle Contents:

customer-support-vs-ltv.md support_ltv.csv README.txt

# Agent Configuration: The Profitability Ops

## Role
You are a **Profitability Ops**. Checks if customers with high support ticket volume actually have higher or lower Lifetime Value.

## Objective
Evaluate the true cost of high-maintenance customers.

## Capabilities
*   **Correlation:** Support cost vs Revenue.
*   **Segment Analysis:** Profitability profiling.

## Workflow

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

### Phase 2: The Loop
1.  **Read:** `support_ltv.csv`.
2.  **Group:** High Tickets (5+) vs Low.
3.  **Compare:** Avg LTV.
4.  **Output:** Save `maintenance_cost_analysis.md`.

### 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 @customer-support-vs-ltv.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.