M

Marketing Campaign ROI Dashboard

Capital Allocation & Diminishing Returns Engine • Authentic Facebook Ads Dataset

Assumed Order Value Assumed Parameter
Not in raw source data • Live recalibration
$30 $200
$100
Portfolio Gross Revenue
📈
$107,900
1,079 closed sales @ $100 assumed order value
$58,705
Total Spend (1,143 ads)
$49,195
Baseline Profit
Recommended Reallocation ⚡
+$6,127
+12.5% net profit increase
Saves $3,706 in ad budget
1.84x
Blended Portfolio ROAS
Breakeven CPA: $100.00
View-Through Attribution
🎯
76 Purchases
Across 207 zero-click ads: 212 inquiries (204 ads) resulted in 76 approved purchases (71 ads) with $0 spend.
Zero-Click Inquiries
212 Leads
488k Impressions

Demographic Tiering

Revenue concentration by cohort tier
3-Tier Rings
Portfolio Gross Revenue
$107,900
Across 1,079 orders @ $100 assumed value
Total Portfolio Gross
$107,900 (100%)
Top 3 Cohorts (30–39)
$60,600 (56%)
Men 30–34 (Hero Cohort)
$29,900 (28%)
Top Cohort Unit Cost
Men 30-34 CPA: $25.55
-53% vs Avg CPA
Generates 6.82% conversion rate at lowest CPA in the portfolio ($25.55 vs $54.41 portfolio average).
Independent lenses on same $58.7k budget (not additive)
Empirical Significance Confirmed χ² = 331.97 (df = 7, p < 0.001)
Pearson's χ² Test of Independence & Wilson Score 95% CIs

Chi-square test of independence confirms conversion differences across segments are statistically confirmed, not random variation (p = 8.89×10⁻⁶⁸). Recommended shifts are grounded in proven performance gaps—chasing signal, not noise. Statistically indistinguishable cohorts (Women 30–34 tied with Men 35–39; Women 35–39 tied with Men 45–49) are merged into shared reallocation tiers with equal shift percentages and unified rationales.

Segment ROAS vs Portfolio Benchmark (1.84x)
Recommended Reallocation Directives (Capped within ±30%)

Campaign 1178 Ad-Level Response Curve

Spend vs. Approved Conversions across 625 ads with OLS Regression
R² = 0.315 • p = 3.25e-53
Marginal Acquisition Cost 1.30x of Avg CPA
$82.89

Slope β₁ = +0.01206. Incremental orders cost $82.89 each vs. Campaign 1178's average CPA of $63.83.

1.21x Marginal ROAS

Because marginal CPA ($82.89) is below assumed order value ($100), returns are diminishing but still profitable. Strategic rule: Moderate growth, do not cut.

Demographic Statistical Validation p < 0.001
χ² = 331.97 (df = 7, n = 38,165)

Chi-square test of independence confirms conversion rate differences across demographic cohorts are real, not random sampling variation. Reallocation targets proven statistical gaps instead of chasing noise.

Analyzed Clicks: 38,165 Approved Sales: 1,003
Pilot Campaigns 916 & 936 Note Flat Slopes

Campaign 916 ($150 spend, p = 0.548) and Campaign 936 ($2.89k spend, p = 0.714) have statistically insignificant regression slopes. Ad spend was too low ($0-$20/ad) to support spend-scaling curves. Maintain as discovery sandboxes.