A UTM taxonomy spreadsheet
A UTM taxonomy spreadsheet is the operational backbone of consistent campaign tracking: it lists the approved values for each parameter, defines naming rules, and logs every link the team builds. It turns governance from a wiki page into something teams actually consult, reducing casing drift and duplicate channels.
Tabs that make it usable
Structure the workbook so it is both a reference and a log. A typical layout: an Allowed Values tab listing approved utm_source and utm_medium values with definitions; a Naming Rules tab stating casing (lowercase), the separator, and date format; and a Link Log tab where each built link's parameters, full URL, owner, and date are recorded.
The Allowed Values list is the single source of truth your builder and your audits both point at, so a channel has exactly one spelling.
- Allowed Values: approved source/medium with definitions
- Naming Rules: casing, separator, date format
- Link Log: parameters, full URL, owner, date per link
Keeping it honest
A taxonomy only works if links are actually built from it. Pair the spreadsheet with a builder that enforces the allowed lists (a dropdown rather than a free-text box), and run periodic audits that compare arriving values against the Allowed Values tab.
There is no vendor-published standard for a UTM taxonomy spreadsheet — it is an operational convention — so this entry is marked not yet verified against a primary source. Adapt the structure to your team and keep a changelog when you add or retire a value.
How it appears in analytics and logs
When campaign reports show many near-duplicate values, the taxonomy is not being followed. A maintained spreadsheet is the reference your analytics filters and audits check against to catch off-list or mis-cased values.
Diagnostic use case
Give a team one place to look up approved utm_source, utm_medium, and utm_campaign values and to register new links, so tagging stays consistent across people and tools.
What WebmasterID can help detect
WebmasterID surfaces the source, medium, and campaign values actually arriving server-side, so you can diff real traffic against your taxonomy spreadsheet and find values that escaped governance.
Common mistakes
- Treating the spreadsheet as documentation no one consults when building links.
- Allowing free-text entry instead of choosing from the approved lists.
- Never auditing arriving values against the taxonomy.
- Adding or retiring values without a changelog.
Privacy and accuracy notes
A taxonomy records campaign metadata only. Do not store personal data in example values or in the link log. The spreadsheet governs structure, not who clicked.
Frequently asked questions
- Is there an official UTM taxonomy template?
- No. UTM is a query-string convention with no vendor-published taxonomy template. A taxonomy spreadsheet is an operational practice: define allowed values, naming rules, and a link log, then enforce them through your builder and audits.
Related pages
- UTM naming conventions that survive reporting
Most UTM data problems are naming problems. Because tools treat utm_source=Reddit and reddit as different values, inconsistent casing and spelling fragment one campaign across many rows. This page gives a convention — lowercase, hyphenated, documented allow-list — that keeps reports clean.
- UTM governance and templates
UTM data degrades when everyone builds links by hand. This page covers the governance that prevents it: a shared builder or spreadsheet, documented allow-lists for source and medium, and a review step so new values are deliberate rather than ad-hoc.
- UTM builder tools and workflows
A UTM builder is a tool that assembles a tagged URL from your source, medium, campaign, and optional content/term values, so people do not hand-edit query strings and introduce typos. Builders range from Google's free Campaign URL Builder to spreadsheet templates and governed internal tools that lock taxonomy. This page covers the builder spectrum and how a builder enforces consistency at the point of creation.
- Campaign links docs
Diff arriving values against your taxonomy spreadsheet.
Sources and verification notes
- Google Analytics Help — Collect campaign data with custom URLsDefines the UTM parameters a taxonomy governs; no official template exists.
Last reviewed 2026-06-24. Facts are checked against primary/official sources where available; uncertain specifics are marked “Data not yet verified” rather than guessed.