Prompt Almanac

Create intermediate Works with: Any AI

Marketing Budget Planner With ROI Tracking

Table output

Plan marketing spend and compare it to results.

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.

Plan marketing spend and compare it to results. Business and goals: [BUSINESS_AND_GOALS]. Total budget and period: [BUDGET_AND_PERIOD]. Channels: [CHANNELS]. Past results by channel: [PAST_RESULTS]. Margins and customer value: [MARGINS_AND_CUSTOMER_VALUE]. Spreadsheet app: [SPREADSHEET_APP].

Return the workbook design as tables:
1. Inputs: Variable | Value | Source (budget, average order value, gross margin, conversion assumptions, customer lifetime value).
2. Budget plan: Channel | Monthly spend | Expected clicks or leads (assumption) | Conversion rate (assumption) | Expected customers | Expected revenue | Expected gross profit | Return on spend | Notes.
3. Actuals tracker: Month | Channel | Spend | Leads | Customers | Revenue | Cost per lead | Cost per customer | Return on ad spend | Gross-profit return.
4. Formulas for each calculated column, written for my app, plus payback period.
5. Variance view: plan versus actual with flags.
6. Reallocation rule: move budget from channels below the return threshold to above, with a test budget and a limit on change per month.
7. Attribution notes: mention double counting and delays between spend and revenue.
8. Dashboard layout and a monthly review checklist.

Provide sample numbers with results, and mark all assumptions. ROI should use gross profit, not revenue alone.

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