Predictive Campaign Budget Allocator

Analyze marketing performance data and create a predictive budget allocation for [CAMPAIGN GOAL] with [TOTAL BUDGET]. **Input Data Required:** - Historical channel performance (last 6-12 months) - Channel list: [CHANNELS - e.g., Google Ads, Meta Ads, Email, Content, Influencer] - Previous budget splits and resulting ROI per channel - Seasonality factors for your industry - Upcoming campaign dates and goals **Part 1: Historical Performance Analysis** For each channel, calculate: - Cost per acquisition (CPA) trend - Return on ad spend (ROAS) average - Conversion rate by campaign type - Customer lifetime value from each source - Attribution model performance (first-touch vs multi-touch) **Part 2: Predictive Modeling** Based on historical data, project: - Expected CPA for next [TIMEFRAME] - Diminishing returns threshold per channel - Optimal spend level before efficiency drops - Seasonal adjustment factors to apply **Part 3: Budget Allocation Matrix** Create allocation recommendation: | Channel | Current % | Recommended % | Rationale | Expected ROAS | Prioritize channels with: - Lowest CPA and highest scalability - Strong historical performance - Alignment with campaign goal type **Part 4: Scenario Planning** Provide 3 budget scenarios: 1. Conservative (minimize risk, maximize proven channels) 2. Balanced (optimize for efficiency) 3. Aggressive (test emerging channels, scale winners) **Part 5: Monitoring Triggers** Set reallocation triggers: - If CPA exceeds [X%] of target, reduce spend - If ROAS drops below [X], pause and investigate - Weekly review checkpoints - Mid-campaign rebalancing rules Output: Spreadsheet-ready budget allocation with rationale and monitoring framework.