UTM builder spreadsheet for Google Sheets
Use this UTM builder to create and manage your campaign tracking. You can generate tagged URLs for your Google Ads, Facebook, LinkedIn, Twitter, etc. campaigns in seconds.
About this tool
This spreadsheet template helps you create and organize all your campaign URLs with tracking information. This Google Sheet uses a formula to build your UTM tags, following the standard Google Analytics Campaign URL builder logic.
The benefit of using the spreadsheet is that you can keep track of all your campaigns (past and present) in a single Google Sheets spreadsheet and easily share with your team.
This tool is created by Alex Zagoumenov, a digital marketing campaign manager and educator with 20+ years of experience, to help you improve your digital marketing campaign tracking.
Let us know what you think about this UTM generator spreadsheet. Is it helpful? Does it require an improvement? Just send us a note.
Why it matters
UTM tags are the industry standard for tracking digital marketing campaigns. Creating UTM tags and managing them requires different tools (many of those are paid). This spreadsheet lets you do both in a Google Sheet (which is free).
How to use this spreadsheet for UTM tracking?
- Open the UTM builder spreadsheet
- Make a copy of this spreadsheet (File > Make a copy) and save it on your Google Drive (see this short video for a quick instruction on the best way to make this UTM tracking sheet yours).
- Start using the UTM generator for your awesome campaigns!
I pre-populated the spreadsheet with some dummy data. Feel free to remove. Just make sure to keep the last column (column F) with resulting URL in-tact, there’s a formula there.
Here’s a quick video explainer on how to make this spreadsheet 100% yours by making a copy of it in your Google Drive.
Frequenty Asked Questions
What is a UTM tag?
A UTM tag passes your digital marketing campaign information to your analytics tool. Consistent use of UTM tags across your campaigns (search marketing, social media, etc.) helps you track your marketing campaigns.
How to use UTM tags?
UTM tags are a great way to keep your analytics reports organized. Start by generating a UTM tag using this UTM builder template. Then, use the tagged landing page URL in your ads when you build your campaign. Finally view your organized campaign tracking in your Campaigns report in Google Analytics.
What is UTM builder?
A UTM builder or UTM generator is a tool that allows you to build campaign URLs to better track your digital marketing efforts. There are many UTM tools on the market, both free and paid.
How to generate UTM codes?
Start by picking the UTM tool, free or paid. Then insert your campaign source, medium, campaign and content variables for each landing page URL you’d like to track. Generate UTM tagged URL to use the resulting URL when you build ads in Google, Facebook, Twitter, etc.