UTM builder / UTM generator 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. Best of all, this UTM generator spreadsheet will allow you to track the entire list of your campaign URLs in a single Google Sheets spreadsheet.
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.
The problem
Just like me, you are running multiple campaigns that require tracking. Good campaign tracking is a major part of your success as a digital marketer. It’s great that there are tools like this by Google and this one by Facebook, that allow you to create UTM tags on the fly. However, what if you have multiple clients or multiple campaigns to track. Where do you organize all your campaign URLs?
The solution
The solution is simple. Why not build and manage all of your campaign URLs from a single Google Sheet? There’s nothing new or groundbreaking here. I’m just sharing one of my campaign UTM generator / builder templates that I’ve used over the years. I hope you find it useful too.
Use cases
This Google Sheet template for UTM tag management will help a number of user types including…
Digital marketers and agencies
You manage a great number of clients. Each client may have several campaigns at any given point in time. It’s convenient to keep all tracking URLs in a single place.
What if you need to create more UTM tags for a campaign you’ve just run? No problem. Use this UTM generator to drag the cells down the sheet and your campaign URLs will auto-populate.
Small business owners
You’re running a multi-channel campaign for your business. Yes, Google Auto-tagging does the trick for Google campaigns, but what if you’re driving traffic from Facebook and Twitter all at the same time and within one specific campaign?
Organizing all your tracking URLs in a single spreadsheet will help you keep your URLs organized. If you need to generate more UTM tags for future campaigns, just drag the cells.
Frequently 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.
Feedback
Let me know what you think about this UTM generator spreadsheet. Is it helpful? Does it require an improvement? Just send me a note.