What does this Google Sheets template do?
CSV template that generates consistent UTM-tagged URLs from base URL + campaign, source, medium, content, and term columns. Includes dropdown-friendly medium list (cpc, email, social, referral) and a validation column flagging spaces, missing campaign, or duplicate final URLs.
What's included
- 1× CSV with formula columns
- UTM naming convention cheat sheet (second tab when opened in Sheets)
- Example rows for paid social, email, and partner campaigns
Common use cases
- Paid media + organic alignment — One source of truth before links go into Meta, Google, and newsletter tools.
- Agency client handoff — Clients fill sheet; media team copies final URL column only.
How to import into Google Sheets
- 1
Download the file
Submit the form to receive your template link by email.
- 2
Open in your tool
Import or paste the file into Google Sheets following the template-specific notes below.
- 3
Customize copy and fields
Replace placeholder brand names, URLs, and merge tags with your values.
- 4
Test before launch
Send a test or run a dry-run import to confirm formatting and triggers.
How to customize for your stack
Add client-specific source taxonomy
Duplicate the conventions tab and lock medium values with data validation in Sheets.
Connect to Looker Studio
Publish sheet tab as data source for campaign link audit dashboard.
Compatibility & requirements
| Format | CSV (UTF-8) |
|---|---|
| Formulas | Google Sheets compatible; re-type in Excel if needed |
| GA4 | Uses standard utm_* parameters |
Operator note: Lock formula cells after setup — accidental column deletes break campaign reporting for the whole quarter.
Anton Chisliuk · AI Marketing Ops · Updated September 2026