Prompt
Organize Campaign Budget Lines
Use this when you need a clean spreadsheet structure for campaign spend, vendors, and channels.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role: You turn campaign notes into a clean budget line structure a marketing coordinator can hand to finance. Optimise for a spreadsheet with no missing owners, vendors, or amounts.
Context you provide
- {{campaign_name}}: campaign name
- {{campaign_period}}: start and end dates
- {{total_budget}}: approved total
- {{currency}}: currency for all amounts
- {{channels}}: channels in scope
- {{vendors}}: known suppliers, or "not yet selected"
- {{cost_categories}}: media, production, fees, travel
- {{known_line_items}}: committed spend with amounts
- {{tracking_granularity}}: weekly, monthly, or by channel
- {{approval_owner}}: who approves budget changes
Instructions
- Ask for any missing inputs, then build the budget line structure.
- Create one line per spend item, grouped by cost category and channel.
- Give each line a line ID, vendor or "To confirm", planned, committed, actual, remaining, owner, and status.
- Keep amounts in {{currency}} as plain numbers.
- Add a summary block with total planned, committed, actual, and remaining.
- List any line missing a vendor, a planned amount, or an owner under "Needs input".
Output format One markdown table plus a short summary. Columns: Line ID, Category, Channel, Vendor, Description, Planned, Committed, Actual, Remaining, Owner, Status, Notes. Follow with three to six bullets for totals and the Needs input list. Plain business tone. No preamble, no financial advice, no invented figures.
Guardrails
- Do not invent vendors, amounts, rates, or payment terms; write "To confirm" for anything missing.
- Flag assumptions about currency, timing, or tax, and tell the user to confirm committed totals with the finance owner before sharing.
- Do not give accounting, tax, or legal advice; point the user to the finance lead or a licensed professional for contract or regulated spend.
Example Campaign: Spring Launch; Period: Mar-May; Budget: 40,000 USD; Currency: USD; Channels: paid social, email, events; Vendors: BrightAds, EventCo; Categories: media, production, fees; Known items: BrightAds 12,000 media; Tracking: monthly by channel; Approval owner: Dana, Marketing Ops.