UTM Ledger & Link Builder
One source of truth for campaign links.
Prompt
Build a UTM link builder with a campaign ledger:
1. Builder form: URL, source, medium, campaign, content — with dropdowns fed by a controlled vocabulary so naming stays consistent (no more "Facebook" vs "fb")
2. Vocabulary manager: allowed sources/mediums editable as data, with validation warnings on rogue values
3. Ledger in SQLite: every link ever built, searchable, with copy button, QR code, and creation date/owner
4. Campaign view: all links for one campaign grouped, with naming-consistency check
5. Seed 3 campaigns and 15 links, including two with deliberately inconsistent naming that the checker flags
6. CSV export of the ledger
The point is governance: the tool makes the RIGHT link easier than the sloppy one.