Use UTM Tracking Spreadsheet when a store decision needs a clear next step instead of a vague note.
Ecommerce template
UTM Tracking Spreadsheet
Keep UTM naming consistent across paid, email, creator, affiliate, and launch campaigns.
Quick answer
The UTM tracking spreadsheet is the shared source of truth for campaign link names, owners, final URLs, QA status, and reporting notes.
Topic, affected product or campaign, current issue, and the decision the team needs to make
A clearer explanation, reusable decision frame, and links to related tools or templates.
Why this sheet prevents reporting cleanup
UTM problems rarely feel urgent during campaign planning. They become painful later, when a launch has already gone live and the team discovers that the same campaign appears under several names. By then, the campaign has sent traffic, screenshots have been shared, and nobody wants to rebuild links in the middle of a promotion.
The spreadsheet is a small control that prevents that mess. It gives the team one place to approve the final URL, the naming convention, the owner, and the QA state before links leave the building. That matters most when creators, agencies, affiliates, and lifecycle tools are all building links around the same campaign.
How to use the artifact
Launch workflow
For a product launch, the lifecycle owner might add email links first, the paid media owner might add Meta and Google links, and the partnerships owner might add creator links. The sheet keeps those links consistent without forcing every person to remember the naming rules.
A row should not move to ready until the tagged URL loads, the source and medium match the reporting convention, and analytics receives the values as expected. That small pause is cheaper than cleaning up a broken report after launch week.
Spreadsheet columns
| Column | Purpose |
|---|---|
| Final URL | The landing page before UTM parameters. |
| Tagged URL | The generated URL after campaign parameters are added. |
| Source | Platform or sender. |
| Medium | Channel grouping. |
| Campaign | Launch, promo, or lifecycle campaign. |
| Content | Creative or placement variant. |
| Launch date | When the link is expected to go live. |
| Status | Draft, ready, live, paused, or retired. |
| Owner | Person responsible for link quality. |
| QA status | Clicked, loaded, and confirmed in analytics. |
Rule
Do not let every agency, creator, and lifecycle tool invent its own UTM naming scheme. The sheet is the shared source of truth.
QA checklist
- Click the final URL before launch.
- Confirm it lands on the right page without redirect errors.
- Check that parameters are lowercase and match the sheet.
- Confirm analytics receives source, medium, and campaign as expected.
- Lock the campaign name before links are sent to partners or creators.
Filled tracking rows
| Final URL | Tagged URL | Source | Medium | Campaign | Content | Launch date | Status | Owner | QA status |
|---|---|---|---|---|---|---|---|---|---|
| https://store.com/products/bundle | https://store.com/products/bundle?utm_source=klaviyo&utm_medium=email&utm_campaign=spring_bundle&utm_content=hero_cta | klaviyo | spring_bundle | hero_cta | 2026-06-20 | Ready | Lifecycle | Confirmed | |
| https://store.com/collections/sale | https://store.com/collections/sale?utm_source=meta&utm_medium=paid_social&utm_campaign=june_clearance&utm_content=video_01 | meta | paid_social | june_clearance | video_01 | 2026-06-22 | Draft | Paid media | Needs analytics check |
| https://store.com/products/kit | https://store.com/products/kit?utm_source=creator_jane&utm_medium=influencer&utm_campaign=starter_kit_launch&utm_content=story_link | creator_jane | influencer | starter_kit_launch | story_link | 2026-06-25 | Live | Partnerships | Clicked only |
| Draft |
Validation rules
- Source, medium, campaign, and content must be lowercase.
- Campaign values must match the approved campaign name exactly.
- Tagged URL must load without redirect errors before status moves to ready.
- Status should move to retired when a link is no longer used in reporting.
- Do not publish partner or creator links until owner and QA status are filled.
Methodology and limits
Use one row per final URL. Lock naming values before the link is sent to email, paid media, affiliates, creators, or partners.
The sheet controls naming discipline. It does not validate analytics implementation or attribution settings by itself.
Reusable download
Use the related CSV as a working file for the calculation, checklist, or planning step covered on this page.
Common questions
Who owns the sheet?
The person accountable for reporting quality should own the naming rules, even if agencies or creators build links.
Should campaign names include dates?
Use dates only if they help reporting. Stable launch names are often easier to reuse across channels.
What should QA status include?
Clicked, loaded, parameters confirmed, analytics confirmed, and owner approved.