Something went wrong!
Hang in there while we get back on track
Six-Campaign Portfolio with Hidden Costs
Comprehensive analysis of 6 campaigns across multiple channels including content costs, team time allocation, and shared overhead. Shows full cost allocation methodology and phased implementation recommendations.
Input
What you provide to the skill
Analyze 6 campaigns: Email ($500 spend, $20000 revenue), Google Search ($8000, $45000), Instagram ($6000, $18000), Facebook Retargeting ($4000, $32000), Blog Ads ($2000, $8000), and Influencer ($5000, $25000). Include $3000 content, 80 team hours at $85/hr, $2200 shared tools/overhead monthly.
Output
What the skill generates for you
Campaign ROI Analysis - Executive Summary
Portfolio Overview
- Total Investment: $34,700/month
- Ad Spend: $25,500
- Content: $3,000
- Team Time: $6,800 (80 hours @ $85/hr)
- Shared Costs: $2,200 (tools and overhead, allocated proportionally)
- Total Revenue: $148,000
- Blended ROI: 327%
- Total Profit: $113,300
- Campaigns Analyzed: 6
Campaign Performance Detail
Complete Rankings
| Rank | Campaign | Channel | True ROI | Investment | Revenue | Profit | ROAS | Profit Margin |
|---|---|---|---|---|---|---|---|---|
| 1 | Facebook Retargeting | 655% | $4,238 | $32,000 | $27,762 | 8.00 | 86.8% | |
| 2 | 569% | $2,987 | $20,000 | $16,713 | 40.00 | 83.6% | ||
| 3 | Influencer | Influencer | 340% | $5,681 | $25,000 | $19,319 | 5.00 | 77.3% |
| 4 | Google Search | 244% | $13,076 | $45,000 | $31,924 | 5.63 | 71.0% | |
| 5 | 104% | $8,818 | $18,000 | $9,182 | 3.00 | 51.0% | ||
| 6 | Blog Ads | Blog Ads | 176% | $2,900 | $8,000 | $5,100 | 4.00 | 63.8% |
Allocation Method: Shared costs ($2,200) allocated proportionally based on direct costs (ad spend + content + team time).
Top 3 Performers
1. Facebook Retargeting - Best Performer
- True ROI: 655%
- Investment: $4,238 (Ad: $4,000 + Shared: $238)
- Revenue: $32,000
- Profit: $27,762
- ROAS: 8.00
- Profit Margin: 86.8%
- Why it wins: Exceptional efficiency targeting warm audiences. Every dollar invested returns $7.55 in pure profit. Highest ROAS demonstrates minimal waste and strong conversion from retargeted visitors.
2. Email - Strong Performer
- True ROI: 569%
- Investment: $2,987 (Ad: $500 + Content: $3,000 + Shared: $187)
- Revenue: $20,000
- Profit: $16,713
- ROAS: 40.00
- Profit Margin: 83.6%
- Why it wins: Extraordinarily low ad spend with high conversion rate. Content investment yields massive returns. Owned channel with minimal ongoing costs creates sustainable profit engine.
3. Influencer - Solid Performer
- True ROI: 340%
- Investment: $5,681 (Ad: $5,000 + Shared: $681)
- Revenue: $25,000
- Profit: $19,319
- ROAS: 5.00
- Profit Margin: 77.3%
- Why it wins: Strong returns with authentic reach. Partnership delivers consistent results with healthy profit margins. Good balance of reach and conversion efficiency.
Bottom 2 Performers
5. Instagram - Underperforming
- True ROI: 104%
- Investment: $8,818 (Ad: $6,000 + Shared: $818)
- Revenue: $18,000
- Profit: $9,182
- ROAS: 3.00
- Profit Margin: 51.0%
- Problem: While profitable, ROI significantly lags top performers (655% vs 104%). Large ad spend relative to returns suggests targeting issues, creative fatigue, or audience mismatch. Needs optimization or budget reduction.
6. Blog Ads - Underperforming
- True ROI: 176%
- Investment: $2,900 (Ad: $2,000 + Shared: $900)
- Revenue: $8,000
- Profit: $5,100
- ROAS: 4.00
- Profit Margin: 63.8%
- Problem: Profitable but lowest absolute profit contribution ($5,100). Small scale limits impact. While ROI is respectable, opportunity cost suggests reallocating to higher-performing channels.
Optimization Recommendations
Immediate Actions (Month 1)
-
SCALE Facebook Retargeting by 100% → Add $4,238/month
- 655% ROI with proven audience warmth
- Expected: +$27,762/month profit
- Risk: Moderate - retargeting pool may have capacity constraints
-
SCALE Email by 75% → Add $2,240/month
- 569% ROI with owned channel advantage
- Expected: +$12,535/month profit
- Risk: Low - list capacity and engagement permitting
-
REDUCE Instagram by 50% → Save $4,409/month
- 104% ROI underperforms portfolio average (327%)
- Test smaller budget while optimizing creative and targeting
- Expected impact: -$4,591/month profit (opportunity cost offset by reallocation)
-
TEST Blog Ads at current level → No change
- 176% ROI is profitable but watch closely
- Consider small-scale A/B tests for improvement
- If no improvement in 60 days, reallocate to top performers
Net Impact
- Budget Shift: +$2,069/month (6% increase)
- Projected Profit Increase: +$35,706/month (+32%)
- New Blended ROI: 406%
- New Total Investment: $36,769
- New Total Revenue: $186,297
- New Total Profit: $149,006
Conservative Scenario (50% scaling)
If market constraints exist:
- SCALE Facebook Retargeting by 50% → Add $2,119/month (+$13,881 profit)
- SCALE Email by 50% → Add $1,494/month (+$8,503 profit)
- REDUCE Instagram by 25% → Save $2,205/month (-$2,296 profit)
- Net Impact: +$20,088/month profit (+18%), New Blended ROI: 377%
Channel Performance Summary
- Facebook: 655% ROI, $32,000 revenue - Dominant performer
- Email: 569% ROI, $20,000 revenue - High-efficiency owned channel
- Influencer: 340% ROI, $25,000 revenue - Solid partnership value
- Google Search: 244% ROI, $45,000 revenue - Largest revenue contributor, good ROI
- Instagram: 104% ROI, $18,000 revenue - Needs optimization
- Blog Ads: 176% ROI, $8,000 revenue - Smallest contributor, monitor closely
Best performing channel: Facebook Retargeting (655% ROI)
Highest revenue generator: Google Search ($45,000)
Most efficient spend: Email (40.00 ROAS)
Key Insights
-
Retargeting dominates profitability - Facebook Retargeting’s 655% ROI proves warm audiences convert at exceptional rates. Scaling this should be priority #1.
-
Owned channels deliver outsized returns - Email’s 569% ROI with 40:1 ROAS demonstrates power of owned audience. Content investment ($3,000) yields massive returns when distributed through owned channels vs. paid placements.
-
Scale vs. efficiency tradeoff - Google Search generates most revenue ($45,000) but moderate ROI (244%). Instagram shows inverse pattern: decent spend but weak returns (104%). This suggests opportunity to shift budget from Instagram to proven channels.
-
Content allocation matters - $3,000 content budget drives Email success but weighs on other channels. Consider dedicating more content resources to Email given 569% ROI.
-
Portfolio concentration opportunity - Top 3 campaigns (Facebook Retargeting, Email, Influencer) deliver 67% of profit on 37% of investment. Strong case for concentrating budget in proven winners.
-
Team time is hidden cost - 80 hours @ $85/hr = $6,800 (20% of total investment). Ensure team focus aligns with highest-ROI campaigns.
About This Skill
Calculate true ROI across all marketing campaigns accounting for hidden costs (team time, tools, overhead). Get budget reallocation recommendations with projected profit impact.
View Skill DetailsMore Examples
Simple Two-Campaign ROI Analysis
Basic ROI calculation for two campaigns (Google Ads and Facebook) with ad spend, revenue, and conversions. Demonstrates core ROI formula application and scaling recommendations.
Underperforming Portfolio Turnaround Strategy
Edge case analysis of 4 campaigns with negative or marginal ROI. Demonstrates diagnostic approach, root cause investigation recommendations, and conservative reallocation strategy for struggling portfolios.