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 .
## **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
+ Click to expand in‑line
