Econometric Marketing Mix Modeling Allocation Report

Role: Principal Econometrician & Marketing Science Director

Context

• Target Organisation: {{brand_name}}
• Active Media Channels: {{target_channels}}
• Empirical Spend & Attribution Inputs: {{historical_spend_data}}
• Performance & Conversion Metrics: {{conversion_metrics}}
• Capital Constraints & Flexibility: {{budget_headroom}}
• Analysis Window: {{reporting_timeframe}}

Task

Produce an econometric marketing mix modeling (MMM) evaluation report that mathematically models channel saturation curves, calculates marginal return on ad spend (mROAS), and delivers an optimal capital reallocation schedule for {{brand_name}}.

Method

1. Standardize and inspect {{historical_spend_data}} across all {{target_channels}} for the duration of {{reporting_timeframe}}.
2. Quantify adstock carryover rates and decay half-lives for each channel based on baseline sales versus promotional spikes.
3. Derive non-linear Hill functions or diminishing marginal return curves to identify the inflection point of saturation for each media vehicle.
4. Correlate spend fluctuations against {{conversion_metrics}} to compute baseline lift versus channel-induced incremental revenue.
5. Apply Karush-Kuhn-Tucker (KKT) optimization conditions against {{budget_headroom}} to compute the mathematically optimal budget redistribution.
6. Conduct sensitivity stress-testing against market volatility, variance in channel efficiency, and competitive bidding shifts.
7. Formulate a phased deployment schedule that mitigates conversion risk while shifting dollars to high-marginal-yield channels.

Constraints

• MUST express all marginal return assertions with explicit mathematical logic or ratio benchmarks.
• MUST NOT recommend budget shifts exceeding {{budget_headroom}} without quantifying confidence intervals.
• Recommendations must isolate organic baseline growth from paid marketing incrementality.
• All channel comparisons must use normalized, annualized unit economics.

Output format

Deliver a formal statistical marketing report structured in four sections:

1. Executive Summary & Marginal Efficiency Matrix (table with channels, spend, current ROAS, and modeled mROAS)
2. Diminishing Returns & Saturation Curve Analysis (narrative breakdown per channel with saturation thresholds)
3. Constrained Budget Optimization Schedule (reallocation table with delta percentages and projected incremental lift)
4. Risk Sensitivity & Model Limitations (confidence levels, adstock assumptions, and testing roadmap) Total length must be between 600 and 900 words.

Self-review

• Did I verify that total recommended spend aligns strictly with {{budget_headroom}}?
• Are adstock decay and diminishing returns explicitly addressed for all channels in {{target_channels}}?
• Is baseline incrementality separated clearly from organic run-rate across {{reporting_timeframe}}?