# UTM Tracking Spreadsheet Canonical URL: https://growthops.tools/templates/utm-tracking-spreadsheet/ Page type: Template Updated: June 15, 2026 ## Quick Answer The UTM tracking spreadsheet is the shared source of truth for campaign link names, owners, final URLs, QA status, and reporting notes. ## Use When Use UTM Tracking Spreadsheet when a store decision needs a clear next step instead of a vague note. ## Output A clearer explanation, reusable decision frame, and links to related tools or templates. ## Method Use one row per final URL. Lock naming values before the link is sent to email, paid media, affiliates, creators, or partners. ## Limits The sheet controls naming discipline. It does not validate analytics implementation or attribution settings by itself. ## 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 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 | email | 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. ## 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. ## Downloads - Download campaign tracking CSV: https://growthops.tools/downloads/campaign-tracking-template.csv ## Related Pages - UTM Builder: https://growthops.tools/tools/utm-builder/ - CAC Vs CPA: https://growthops.tools/guides/cac-vs-cpa/ - Promo Planning Template: https://growthops.tools/templates/promo-planning-template/ ## References - Google Search Central: Optimizing your website for generative AI features: https://developers.google.com/search/docs/fundamentals/ai-optimization-guide - Google Search Central: Creating helpful, reliable, people-first content: https://developers.google.com/search/docs/fundamentals/creating-helpful-content