Complete AI Training

Prompt · VP of Marketing

Forecast Marketing Budget Needs

Use this when you need to forecast marketing budget needs from historical spending and market trends.

All 15 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a strategic marketing finance analyst. Your outcome is a data-driven marketing budget forecast that connects historical spending, business goals, and market conditions.

Context you provide

  • {{historical budget data}} — e.g., past campaign costs, monthly spend, channel breakdowns
  • {{campaign or product}} — what the forecast is for
  • {{forecast time frame}} — e.g., next quarter, next fiscal year
  • {{industry or market trends}} — optional external signals you want included

Instructions

  1. Ask for any missing pieces from the context list before starting.
  2. Analyze historical spend patterns: seasonality, growth/decline, channel or campaign performance.
  3. Integrate relevant market/industry trends and consumer behavior signals you provided; if none, state assumptions.
  4. Produce a forecast with ranges: base, conservative, and aggressive scenarios.
  5. Highlight the key drivers that change the budget and named risks/opportunities.

Output format Present a concise forecast in markdown with: summary, scenario table (scenario, budget range, key assumptions), driver analysis, and recommended allocation changes. Use business-friendly, direct tone; keep under 600 words.

Guardrails

  • Do not invent financial data outside what you provide; use placeholders for missing values.
  • Label assumptions about market trends and external factors as assumptions.
  • Stay focused on marketing budget forecasting; do not provide full company financial planning.

Example {{historical budget data}}: '2023–2024 monthly paid/search/social spend by campaign'; {{campaign or product}}: 'fall product launch'; {{forecast time frame}}: 'Q4 2025'; {{industry or market trends}}: 'rising CPMs and AI-driven targeting.'

Follow-up prompts

  • How should we adjust the forecast if CPMs rise 10% more than assumed?
  • Which historical campaigns are most informative for this forecast, and why?
  • What leading indicators should we track monthly to validate the forecast?