We are excited to announce our $20M Series A led by Bessemer Venture Partners!
↗
Back to all prompts
Odin prompt library

Channel and Campaign Performance Analysis

One prompt analyzes 4 quarters of spend vs outcomes to rank channels, flag ROI shifts, and recommend precise budget changes with reasoning and strategy notes.

For most marketing teams, understanding which channels and campaigns are truly driving revenue is an exhausting quarterly exercise. You’re piecing together data from multiple dashboards, running manual comparisons, and trying to connect spend to results across different timeframes... all while the next budget cycle looms.

Odin changes that. Because HockeyStack has visibility into your spend, pipeline, revenue, and lift data for the past four quarters, with this prompt you’ll instantly get a clear, data-backed analysis of which channels are accelerating growth, which are stalling, and exactly where to shift budget for maximum impact.

The result is not only a performance report, but also, it’s also a decision-making tool. You’ll see quarter-over-quarter trends, ROI shifts, and the true relationship between spend and outcomes, so you can make confident, proactive budget moves instead of reactive guesses.

HockeyStack Customers: Log in and copy and paste this prompt into your instance.
Visitors: Copy and paste this prompt into our interactive demo.
Prompt 

## **CHANNEL & CAMPAIGN PERFORMANCE ANALYSIS — LLM EXECUTION INSTRUCTIONS**
---
### **INPUT DATA (you will be need to pull this)**
1. Spend, Closed Won $, Pipeline $, Closed Won Lift, Pipeline Lift for each channel in Q3 2024
2. Spend, Closed Won $, Pipeline $, Closed Won Lift, Pipeline Lift for each channel in Q4 2024
3. Spend, Closed Won $, Pipeline $, Closed Won Lift, Pipeline Lift for each channel in Q1 2025
4. Spend, Closed Won $, Pipeline $, Closed Won Lift, Pipeline Lift for each channel in Q2 2025
---
### **PROCESSING STEPS**
Perform the following in order.
**Do not skip steps** even if some data is missing — note "Data missing" when needed.
---
#### **STEP 1 — Organize the data**
Create a table for each channel showing the provided metrics for:
* Q3 2024
* Q4 2024
* Q1 2025
* Q2 2025
---
#### **STEP 2 — Identify spend changes**
For each channel:
* Calculate **absolute change in spend** from quarter to quarter (Q3→Q4, Q4→Q1, Q1→Q2).
* Calculate **percentage change** for each transition.
---
#### **STEP 3 — Identify outcome changes**
For each channel:
* Calculate the quarter-to-quarter change for:
  * Closed Won $ (absolute and % change)
  * Pipeline $ (absolute and % change)
  * Closed Won Lift (absolute and % change)
  * Pipeline Lift (absolute and % change)
---
#### **STEP 4 — Link spend to outcomes**
For each channel:
* Determine if changes in spend **positively**, **negatively**, or **inconclusively** affected outcomes.
  * **Positive:** Spend ↑ and key outcomes ↑ OR spend ↓ and key outcomes ↓
  * **Negative:** Spend ↑ and outcomes ↓ OR spend ↓ and outcomes ↑
  * **Inconclusive:** Mixed or no clear relationship
---
#### **STEP 5 — Budget recommendations**
For each channel:
1. Decide one of:
   * **Increase budget**
   * **Decrease budget**
   * **Keep budget same**
   * **Inconclusive**
2. Suggest **$ amount change** or percentage change recommendation.
3. Base the decision on **both**:
   * Lift metrics (Closed Won Lift + Pipeline Lift)
   * Attributed $ (Closed Won $ + Pipeline $)
4. Provide a **clear, data-backed reason** (e.g., "+32% Pipeline $, +0.2x Lift after 15% spend increase — ROI improving").
---
#### **STEP 6 — Strategy notes**
For each channel, include:
* Any strategic recommendation (e.g., "Shift spend to retargeting campaigns").
* Reason backed by quarter-over-quarter data trends.
---
### **FINAL OUTPUT FORMAT**
Produce the report in the following structure:
---
#### **Intro and Approach**
Briefly summarize:
* Timeframe (Q3 2024 – Q2 2025)
* Method used (steps above)
* Goal: Provide budget recommendations based on performance trends.
---
#### **Channel 1 – [Channel Name]**
**Data Table:**
| Quarter | Spend | Closed Won $ | Pipeline $ | Closed Won Lift | Pipeline Lift |
| ------- | ----- | ------------- | ----------- | --------------- | ------------- |
| Q3 2024 | ...   | ...           | ...         | ...             | ...           |
| Q4 2024 | ...   | ...           | ...         | ...             | ...           |
| Q1 2025 | ...   | ...           | ...         | ...             | ...           |
| Q2 2025 | ...   | ...           | ...         | ...             | ...           |
**Spend Changes:** …
**Outcome Changes:** …
**Impact of Spend Changes:** Positive / Negative / Inconclusive
**Recommendation:** Increase / Decrease / Keep / Inconclusive — by $X or X%
**Reasoning:** …
**Strategy Notes:** …
---
#### **(Repeat Channel Analysis for ALL channels with spend)**
---
#### **Summary Recommendations Table**
| Channel | Current Trend | Q1+Q2 Budget ($) | Budget Change ($) | New Budget ($) | Reason |
| ------- | ------------- | ------------------ | ------------------ | --------------- | ------ |
| …       | …             | …                  | …                  | …               | …      |
**SUM Total New Budget:** 
---
#### **Overall Strategy Recommendations**
Summarize key themes:
* Which channels to prioritize
* Any cross-channel strategy shifts
* Notable risks or data limitations
Channel and Campaign Performance Analysis

More from The Odin Prompt Library

What are the key touchpoints driving enterprise deals?

Ask Odin to uncover which channels are driving your enterprise deals.
View prompt

Which campaigns are most impactful for driving conversions at each stage of the funnel?

Ask Odin to identify the top campaigns driving conversions through your funnel.
View prompt

Where should I cut $100k in budget from?

Ask Odin where to cut spend to minimize impact on performance.
View prompt