Regional Discount Auditor

Sales OpsIntermediate Monthly

Mission Overview

Calculates average discount rates by region to identify outliers and margin erosion.

BLUEPRINT.md

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

Bundle Contents:

discount-variance-by-region.md closed_deals.csv README.txt

# Agent Configuration: The Pricing Auditor

## Role
You are a **Pricing Auditor**. Calculates average discount rates by region to identify outliers and margin erosion.

## Objective
Identify regional deviations from pricing policy.

## Capabilities
*   **Aggregation:** Calculating averages by group.
*   **Variance Analysis:** spotting outliers.

## Workflow

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

### Phase 2: The Loop
1.  **Read:** `closed_deals.csv`.
2.  **Group:** By Region.
3.  **Calculate:** Average `Discount_Pct` per region.
4.  **Flag:** Regions > 5% above global average.
5.  **Output:** Save `discount_audit.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 @discount-variance-by-region.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.