Campaign Retrospective & Results Tracker

The problem this kills

Your team runs campaign after campaign. Email blasts, paid social, webinars, launches. And when each one wraps, everybody is already sprinting toward the next thing. The results live in someone's inbox, a slide deck nobody opens again, or a spreadsheet tab named "final FINAL v3."

So the same mistakes come back. You repeat the subject line that flopped. You set the same unrealistic goal. You forget the channel that quietly crushed it last quarter. There's no memory. There's no place to ask "what did we learn last time we ran this?"

This tool gives your campaigns a memory. Every finished campaign gets a short, structured retrospective. Results imported, goal-vs-actual measured, wins and misses captured, and a "next time" note written while it's still fresh, then filed where anyone on the team can search it.

What you'll build

A small web app, just for your team, that does this:

• A campaign ends, and you import its results (sends, clicks, conversions) from a CSV.
• The AI drafts a clean retro summary, including the goal-vs-actual delta and ROI where you have cost data.
• The campaign owner edits the draft. They fix the numbers, add the real story, write the honest "what we'd do differently."
• The marketing lead reviews and approves it. Nothing gets filed until a human signs off.
• The approved retro lands in a searchable library, tagged by channel and theme, so the team can find past lessons in seconds.
• You can export every retro to CSV anytime.

What's inside the Implementation Plan

The plan is a runbook you paste into an AI coding agent (Claude Code). It builds the whole thing with you, step by step, no coding required on your part.

The best part: it does not hand you a generic template. The plan opens by interviewing you about your business: how you run campaigns today, what a campaign is called in your world, the exact columns in your results files, your channels and themes, your goal-setting rules, and your messy edge cases. Then it tailors the data model, the fields, and every later step to your actual answers. You confirm a short spec before anything gets built.

After that, it walks through setting up the database, the login, the import, the AI draft, the approval gate, the searchable library, and the CSV export, with a ready-to-paste prompt at the end of every step.

The governance it includes (this is the point)

This isn't a toy. The plan builds in real controls from the start:

• Login so only your team can get in.
• Row-level security so people only ever see your organization's data, never anyone else's.
• A human approval gate: the AI drafts and the owner edits, but nothing is filed until the marketing lead approves it. The AI never writes a final record on its own.
• A full audit trail: who drafted, who edited, who approved, and exactly when.
• A duplicate guard: each campaign has one retro of record, keyed by campaign ID, so the same campaign can't be retro'd twice by accident.

Who it's for

Marketing ops people and marketing managers who run a lot of campaigns and never seem to document the outcomes. If you've ever thought "we definitely learned this lesson before," this is for you. No engineering team required.

You've got this. Paste the first prompt and let the agent interview you.