Ad Spend Pacing Monitor
Import spend exports and budget plans, compute daily and month-to-date pacing with a business-day-aware projection, flag campaigns on track to over- or under-spend, and let your media manager approve action notes before anything is logged.
A private internal tool where you import ad spend and budgets, see month-to-date pacing and a projected end-of-month spend per channel, get over/under-pace alerts, approve action notes, and export a clean pacing report - all with login, audit trail, and a human approval gate.
Before you start
- A free Supabase account
- A free Vercel account
- A free Resend account
- A spend export CSV per platform (campaign, date, spend)
- A budget plan CSV (channel/campaign, monthly budget)
The problem this kills
You are managing paid-media budgets across Google, Meta, LinkedIn, maybe TikTok - each with its own dashboard, its own export, its own definition of "spend so far." Halfway through the month you have a sinking feeling that one campaign is burning cash faster than planned and another is barely spending, but proving it means stitching together five exports in a spreadsheet at 9pm. By the time you spot the overspend, the money is gone. By the time you spot the underspend, the month is over and you've left budget - and reach - on the table.
The math itself is simple. The pain is doing it reliably, every day, across every platform, without double-counting, and turning "this campaign is pacing to 128% of budget" into an actual logged decision someone signed off on.
What you'll build
A small private web app for your team that:
- Imports a spend CSV per platform (campaign, date, spend) and a budget plan CSV (channel/campaign, monthly budget).
- Computes daily and month-to-date (MTD) spend per channel and campaign, then projects end-of-month spend using a business-day-aware run rate (it knows weekends and the days left in the month matter).
- Flags campaigns that are on track to over-spend or under-spend against configurable thresholds (for example, anything pacing above 110% or below 80% of budget).
- Shows your media manager a pacing dashboard with clear alerts and suggested action notes ("pause," "shift budget," "raise cap").
- Requires a human to review and approve each action note before it is logged - the tool advises, the person decides.
- Sends a Resend email digest of the day's pacing alerts and exports a clean pacing report CSV.
What's inside the Implementation Plan
The plan is a complete, paste-and-go runbook. It opens by interviewing you about your business - your platforms, your real campaign naming, your budget cadence, your alert thresholds, and the messy edge cases - so the tool is tailored to how you actually run paid media, not a generic template. The agent reads a short spec back to you and waits for your thumbs-up before it builds a thing.
From there it walks you, step by step, through standing up the database, the import screens, the pacing math, the approval gate, the email alerts, and the CSV export - each step ending in a ready-to-copy prompt you paste into your AI coding agent.
The governance it includes (this is the point)
This is not a throwaway script. Every build includes:
- Login so only your team can open the tool.
- Row-level security so each organization only ever sees its own spend and budgets.
- A full audit trail - who imported what, who approved which action note, and exactly when.
- A hard human-in-the-loop approval gate - pacing alerts and recommended actions are drafts until a person approves them.
- Duplicate guards keyed on platform + campaign + date so the same spend row can never be counted twice.
Who it's for
Marketing and paid-media ops managers running budgets across several ad platforms who are tired of rebuilding the same pacing spreadsheet and want an early-warning system that produces auditable decisions, not just numbers.
You've got this - paste the first prompt and let the agent interview you.