Marketing Campaign Performance Dashboard

Executive Intelligence  |  Marketing Campaign Performance Review  |  Jan – Dec 2024  |  Built by Girish Shenoy

Revenue ₹1.22 Cr
Profit ₹83.73L
Overall ROI 219.3%
Health Score 82
Risk Level Low
📈 Spend, Revenue & ROI
🌍 Regional & Audience
⚙️ Efficiency & Funnel
📋 Executive Strategy
Showing 104 of 104 Campaigns
All Campaigns
₹38.27L
Target: ≤ ₹40.0L  |  Gap: -₹1.73L  |  On Track
₹1.22 Cr
Target: ≥ ₹1.10 Cr  |  Gap: +₹12.4L  |  On Track
₹83.73L
Target: ≥ ₹80.0L  |  Gap: +₹3.73L  |  On Track
219.3%
Target: ≥ 200%  |  Gap: +19.3%  |  On Track
29 / 104
Target: ≤ 0  |  Gap: +29  |  Risk

Which platform gives the best return on spend?


💡 Instagram delivers 324% ROI on ₹6.73L spend — most efficient platform. Reallocate budget here.

Which campaign type should we double down on — and which should we kill?


💡 Awareness campaigns return -35% ROI — every rupee spent here loses 35 paise. Stop or redesign this category.

Where is the funnel leaking the most?


💡 Click-through is the biggest leak at 2.89% — creative and targeting need the most attention, not bottom-funnel conversion (already strong at 21.92%)

Funnel Efficiency
82%
Revenue Leakage
₹14.8L
Recoverable Revenue Opportunity
₹32.5L

How did spend and revenue trend month over month?


💡 July generated ₹18.3L revenue on ₹4.86L spend — highest revenue efficiency month. Study what campaigns ran then.

Which are our top 10 highest-revenue campaigns?


💡 Top 3 campaigns are ALL on Instagram/Facebook/Email in Asia Pacific — pattern worth replicating elsewhere

Key Insights — Spend, Revenue & ROI


Risk

Pause or redesign campaigns immediately to prevent losses.

Opportunity

Scale high-performing platform spend to maximize yield.

Recommended Action

Reallocate budget from underperforming segments to high-margin channels.

Asia Pacific
↑ 541% average ROI
North America
↓ -35.3% average ROI
45-54 Age Group
↑ 731% average ROI
₹325.63
⚠ Flag if segment CAC exceeds ₹500

Strategic Audience Insights

Revenue Leader
35–44 Age Group

Scale this segment for aggressive top-line revenue growth.

Profit Leader
45–54 Age Group

Scale this segment for bottom-line profit optimization (highest average ROI).

Which region should get more budget next quarter?


💡 North America is burning budget at -35.3% ROI. Asia Pacific returns 541%. Reallocate immediately.

Which audience segment is most cost-efficient to acquire?


💡 Acquiring an 18-24 customer costs ₹798.75 — 15x more than a 45-54 customer at ₹51.65. Reconsider targeting strategy for this segment.

Which segment generates the most revenue per rupee spent?


💡 Bubble size = ROI%. Bubbles above the diagonal = profitable; below = losing money. 18-24 cluster sits closest to the loss zone.

Which audience segment drives the most revenue?


💡 35-44 age group generates ₹61.3L — by far the largest revenue contributor, also the highest-ROI segment after 45-54

Strategic Capital Allocation Summary

Increase Budget Latin America, Asia Pacific, Instagram, 45–54 Segment

Scale channels and segments showing optimal ROI yield.

Maintain Budget Europe

Stable return profiles; maintain standard budget baseline.

Monitor / Optimize Middle East & Africa

Watch performance closely; optimize targeting creatives.

Reduce Spend / Pause North America, 18–24 Segment

Severe margin erosion. Defund or restructure immediately.

Regional Platform Performance Matrix

Compare ROI, Revenue, Profit, and Spend across regions and channels.


💡 Asia Pacific + Instagram is the strongest combination at 748.5% ROI. North America shows negative ROI across every platform — a regional problem, not a platform problem.

Region Email Facebook Google Ads Instagram LinkedIn YouTube Region ROI Region Rev Region Profit Status Action

Key Insights — Regional & Audience Intelligence


Risk

Reduce North America spend immediately.

Opportunity

Reallocate underperforming regional budgets to Asia Pacific.

Recommended Action

Reallocate budget to Asia Pacific and Instagram conversion campaigns.

3.25%
⚠ Flag if below 2%
₹2.08
Across all platforms
₹63.54
Per 1,000 impressions
18.26%
Leads → conversions

Which platform is most cost-efficient on clicks?


💡 LinkedIn costs 2x more per click than Email — but check if LinkedIn leads convert at a higher rate before cutting spend

How does conversion rate vary by campaign type?


💡 Retention (31.1%) and Conversion (30.9%) campaigns convert leads best. Awareness campaigns convert at only 8.1% — they need a different success metric, not conversion volume.

Are our worst-performing campaigns concentrated in one campaign type?


💡 100% of our 10 worst campaigns are Awareness type. This is a strategy problem, not a one-off failure.

Campaigns to Pause Immediately


Campaigns to Pause 10
Potential Savings ₹2.72L
Portfolio Impact High
Campaign Name Platform Spend Revenue Net Loss Loss / ₹1 Spent Rec. Action

Key Insights — Campaign Efficiency & Funnel


Risk

Pause or redesign underperforming campaigns.

Opportunity

Optimize creative and targeting to address click-through rate leaks.

Recommended Action

Pause worst-performing campaigns to prevent net losses.

Executive Decision Snapshot
Revenue Impact +₹0
Cost Savings +₹0
Profit Impact +₹0
Risk Level Low
Priority Action Pause bottom campaigns

Executive Recommendations Impact Projection


Estimated annual benefits projected if all boardroom recommendations are successfully executed.

Revenue Impact +₹0
Cost Savings +₹0
ROI Improvement +0.0%
Profit Impact +₹0

Prescriptive Budget Reallocation


Transfer budget away from low-performing channels.

Recommended Action
Move ₹5L from Awareness Campaigns to Instagram Conversion Campaigns.
Action:
Revenue Impact
+₹0

Forward-Looking Forecasting


Projections based on filters and rolling campaign cycles.

Revenue
₹0 +9.8%
ROI
0% +11.0%
Conversions
0 +10.2%
Confidence
0%

Executive Marketing Health Score

82 Out of 100

Excellent Performance

Based on weighted factors: ROI, campaign profitability ratio, CAC efficiency, and CTR strength.

Previous Score: 89  |  Current Score: 93  |  Trend: +4
Growth: High
ROI Strength: Optimal
Profitable: 72%
CAC Efficiency: High

Target Benchmark Comparison


Measures current performance against company board targets.

ROI (Target: 200%) 219.3%
CAC (Target: ≤ ₹150) ₹325.63
CTR (Target: ≥ 3.0%) 3.25%

Executive Risk Assessment


Analysis of portfolio risk exposure and forecast confidence.

Portfolio Risk Level Low
Forecast Confidence 92%
Key Risk Driver North America (ROI: -35%)
Estimated Risk Exposure ₹0

Consolidated Executive Action Summary

Boardroom intelligence recommendations prioritized by segment ROI and portfolio waste reduction.
Critical

Pause bottom low-performing campaigns immediately to save net portfolio loss.

Growth

Increase budget allocation for top performing platform.

Cost Saving

Reduce spend on underperforming campaigns and reallocate.

Strategic

Focus targeting targeting on the highly cost-efficient audience segment.

Scale

Scale campaign formats returning high ROI.