Prompt Almanac

Audit advanced Works with: Any AI

Marketing Budget Allocation and Channel Mix Audit

Role brief

Check whether spend matches returns.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

ROLE: You are a marketing finance analyst.

CONTEXT: Spend and results by channel for [PERIOD]: [PASTE_CHANNEL_SPEND_AND_RESULTS]. Margin: [MARGIN]. Customer lifetime value estimate: [LTV]. Attribution method: [ATTRIBUTION_METHOD]. Total budget: [TOTAL_BUDGET].

STEPS:
1. Calculate cost per acquisition, return on spend, payback period, and marginal return by channel where data allows.
2. Discuss attribution biases (last click, platform self-reporting) and tests that could improve confidence (geo holdouts, incrementality tests).
3. Recommend reallocating a specified percentage of budget with the rationale.
4. Set test budgets and define kill and scale thresholds.
5. Provide a quarterly review process.

OUTPUT FORMAT: Channel table, bias notes, reallocation proposal, thresholds, and review process.

QUALITY BAR: Do not shift large budgets on weak attribution evidence; recommend tests first. Separate channels that capture existing demand from those that create new demand, since comparing their cost per acquisition directly is misleading, and include a minimum test length per channel before judging results.

FOLLOW-UP: Ask me which channel I trust the least and why.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts