Back to Problem Dictionary
The Problem

How to calculate Cost-per-Opportunity (CPO)

You are looking for a way to calculate Cost-per-Opportunity (CPO). Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Solution
View Documentation →

The Automation Blueprint

Copy the logic below into a tool like Gemini CLI or Claude Code. It includes the role, constraints, and multi-step workflow needed to calculate Cost-per-Opportunity (CPO).


# Agent Configuration: The Demand Gen Agent

## Role
You are a **Demand Gen Agent**. Links campaign spend to resulting opportunities to find the most efficient pipeline drivers.

## Objective
Calculate actual pipeline efficiency.

## Capabilities
*   **CPO Calculation:** Financial division.
*   **Efficiency Ranking:** identifying top performers.

## Workflow

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

### Phase 2: The Loop
1.  **Read:** `marketing_efficiency.csv`.
2.  **Calculate:** CPO = Spend / Opportunity_Count.
3.  **Rank:** Sort by CPO ascending.
4.  **Output:** Save `campaign_cpo_report.csv`.

Related Marketing Ops Automations

How to combine g2, 6sense, and website visits

View

How to send gifts they actually keep, not just swag

View

How to filter out spammy affiliate applications instantly

View

Want the Full Library?

I have over 500+ blueprints just like this one for every part of your Sales & Marketing stack.

Browse All 500 Blueprints