Free UTM Tracking Spreadsheet Template
A ready-to-use CSV with the right columns and three worked example rows. Open it in Google Sheets or Excel and start tracking campaign links in the next two minutes — no email gate, no signup.
11 columns · 3 example rows · imports cleanly into Google Sheets, Excel, and Numbers.
How to use it
- Download the CSV and import it into Google Sheets (File → Import) or open it directly in Excel.
- Review the three example rows — an email send, a paid-social campaign, and a paid-search campaign — then delete them or keep them as reference.
- Add data-validation dropdowns to the
utm_sourceandutm_mediumcolumns using the taxonomies from our UTM naming conventions guide. This is the single best thing you can do to keep a spreadsheet honest. - Rebuild the Full URL column as a formula so links are always assembled from the parameter columns, for example:=B2&"?utm_source="&C2&"&utm_medium="&D2&"&utm_campaign="&E2
- Share one copy with the whole team, and agree that links only ship if they have a row in the sheet.
What each column is for
| Column | What it's for |
|---|---|
| Campaign Name | A human-readable label for the campaign — what you'd call it in a meeting. Not sent to analytics. |
| Landing Page URL | The destination page, without any UTM parameters. Keep it clean here so the Full URL column can assemble it. |
| utm_source | The platform sending the click: facebook, google, mailchimp, linkedin. Lowercase, no abbreviations. |
| utm_medium | The marketing channel type: email, cpc, paid-social, organic-social, qr. Keep this to a short fixed list. |
| utm_campaign | The campaign identifier, e.g. spring-sale-2026. Lowercase with hyphens, year included. |
| utm_term | Optional. Paid-search keyword, or audience identifier for other paid channels. |
| utm_content | Optional. Distinguishes creatives or placements within one campaign: header-cta, carousel-v1, footer-link. |
| Full URL | The assembled link you actually share. In Sheets/Excel, build it with a CONCATENATE formula from the columns above so it never drifts from the parts. |
| Owner | Who created the link — your only audit trail in a spreadsheet. |
| Date | When the link was created or the campaign launched (YYYY-MM-DD sorts correctly). |
| Notes | Audience, budget, test hypothesis — anything future-you will want to know. |
New to what the five utm_ parameters actually do? Read UTM Parameters Explained for a plain-English walkthrough with worked examples.
The honest part: where spreadsheet UTM tracking breaks down
We built this template carefully, and for a solo marketer or a small team launching a few campaigns a month, it genuinely works. But we would be lying by omission if we did not tell you how these spreadsheets fail — because they fail the same way at almost every company:
Nothing is enforced
A spreadsheet can suggest "facebook" via a dropdown, but it cannot stop someone typing Facebook, FB, fb-ads, or facebok in a hurry. Real-world sheets accumulate a dozen spellings of the same source, and every one becomes a separate row in GA4.
Formulas break silently
The Full URL column depends on a CONCATENATE formula. Someone sorts the sheet, pastes over a row, or drags a cell — and now links are assembled from the wrong rows. Nobody notices until the monthly report looks wrong.
Copies fork immediately
The paid team duplicates the sheet "just for our campaigns." An agency makes their own version. Six months later there are five sources of truth with five diverging conventions, and no way to merge them.
No click data
A spreadsheet records that a link exists — never whether anyone clicked it. You still have to cross-reference analytics manually to know which links are alive, dead, or mistagged.
No audit trail
When a bad UTM shows up in reports, a spreadsheet cannot tell you who created it, when it changed, or what it looked like before. The Owner column is only as accurate as people remember to make it.
It depends on discipline at the worst moment
UTMs get created five minutes before a campaign ships. That is exactly when nobody opens the spreadsheet, checks the conventions tab, and fills in eleven columns. The process fails precisely when it is needed most.
When you outgrow the spreadsheet, bring it with you
UTM Copilot's import wizard accepts this exact spreadsheet — or the messy, forked, twelve-spellings-of-facebook one you already have. Upload the CSV and AI maps your columns, cleans and normalizes the values, proposes governance conventions based on what it finds, and imports everything into a shared library with click tracking, version history, and a full audit trail. From then on, every new UTM is validated against your conventions at creation — no discipline required.
Free plan includes 50 UTMs/month. No credit card required.