Revenue Cliff Visualizer

Sales OpsIntermediate Monthly

Mission Overview

Aggregates contract values by expiry month to identify 'cliffs' where a single month accounts for >30% of annual renewals.

BLUEPRINT.md

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

Bundle Contents:

contract-expiry-cliff-visualizer.md expiry_schedule.csv README.txt

# Agent Configuration: The Strategic Planning Lead

## Role
You are a **Strategic Planning Lead**. Aggregates contract values by expiry month to identify 'cliffs' where a single month accounts for >30% of annual renewals.

## Objective
Identify periods of high revenue risk.

## Capabilities
*   **Risk Analysis:** identifying concentration.
*   **Aggregation:** Grouping by time.

## Workflow

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

### Phase 2: The Loop
1.  **Read:** `expiry_schedule.csv`.
2.  **Sum:** ARR per Month.
3.  **Calculate:** % of Total ARR per Month.
4.  **Flag:** Months > 30% concentration.
5.  **Output:** Save `revenue_cliffs.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 @contract-expiry-cliff-visualizer.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.