Optimize Marketing Budgets for Maximum ROI

Plans and optimizes multi-channel marketing budgets - allocating spend across performance, brand, operations, and testing categories, tracking channel efficiency, and reallocating budget based on ROAS performance.

Use this skill when building an annual or quarterly marketing budget from scratch, deciding how to split spend across performance vs. brand channels, setting per-channel minimum spend for a new campaign, reallocating budget toward top-performing channels, or building a multi-touch attribution query to measure ROI. Not a fit for setting individual campaign creative strategy or for financial planning outside of marketing spend.

Core planning principles include the 70-20-10 rule (70% proven channels, 20% promising channels, 10% experimental tactics) and a four-way budget allocation framework: performance marketing (40-60%: paid search, paid social, display/programmatic), brand marketing (20-30%: content, PR/events, brand campaigns), marketing operations (10-15%: tech stack, analytics, team/agency costs), and testing/innovation (5-10%: new channels, creative testing, technology pilots).

Provides a quarterly annual budget planning template (CSV) with per-channel budget, expected ROAS, and expected revenue columns, and a Python MarketingBudgetTracker class that computes ROAS, CPA, budget utilization, and a weighted efficiency score (40% ROAS, 30% budget utilization, 30% conversion volume) per channel.

Channel-specific guidance gives concrete minimum daily spend thresholds (Google Ads $50-100/day, Facebook Ads $20-50/day per ad set, LinkedIn Ads $100+/day) and content/brand budget shares (content creation 15-20% of total, video allocated 30-40% more than static, brand campaigns planned over 3-6 month periods). A JavaScript budget reallocation function sorts channels by ROAS, increases the top 60% of performers by 20% (capped at 40% of total budget), and decreases underperformers by 15% (floored at 5% of total).

Seasonal adjustment guidance covers Q4 holiday scaling (+25-40%), B2B seasonal patterns, and consumer seasonal peaks. A SQL multi-touch attribution query aggregates revenue, spend, ROAS, CPA, and ROI percentage per channel/campaign over a rolling 30-day window. Risk management guidance includes a 10-15% opportunity buffer, minimum ROAS performance floors, and a 40%-of-budget cap on any single channel. Advanced guidance includes an LTV-based budget allocation function using a 3:1 LTV:CAC ratio and payback-period-based scaling multipliers, plus cross-channel synergy rules (upper-funnel brand lift of 15-25% on lower-funnel efficiency, 20-30% of acquisition budget to retargeting, 1:10 email-to-paid spend ratio).

Provides implementation patterns in Python (budget tracking and LTV allocation), JavaScript (reallocation logic), SQL (attribution queries), and CSV (budget templates) rather than a specific marketing platform integration.

Marketing leaders and finance-adjacent marketing operations staff building or optimizing a multi-channel budget who need concrete allocation percentages, reallocation logic, and attribution queries rather than generic budgeting advice.

def calculate_ltv_budget_allocation(customer_ltv, acquisition_cost, payback_period):
    max_cpa = customer_ltv / 3