UTM Builder Template

Do you know what UTM stands for? It's Urchin Tracking Module.

Simply put, it is the code marketers add to URLs to track website traffic and marketing campaigns.

Even when marketing teams use this method, they often lack a consistent way of generating the UTM parameter URLs.

This leads to ineffective marketing attribution because URLs use all different structures and nomenclatures.

That's why we built this UTM Builder Template for Google Sheets. No more random URLs. Only clear, consistent, repeatable UTM parameters. Add UTM parameters to all of your digital marketing campaigns.

All you need to do is enter in your destination URL, the channel, sub-channel, campaign name and any additional parameters.

Then voila! You will have URLs with UTMs built consistently for all of your marketing channels.

Click "Add to Cart" on the right to access the Google Sheet Template with the UTM URL Builder.

When you checkout, I'll send you a link to make a copy of the Google Sheet. Here is what you'll find inside:

• UTM Parameter Definitions & Guide: I want you to fully understand how UTM content works. I include a detailed guide and definitions to start.
• ‍UTM Builder: This tab enables you to input your landing page URL and campaign level details. Then the campaign URL builder formula generates your trackable link. I recommend using drop down selectors for your Medium and Source fields. That way, when your team uses this builder, everyone is picking from a consistent pick list. Once your UTM URL is generated, you can simply copy and paste it for use in your marketing campaign.
• Bulk UTM Builder Template: Similar to the prior tab, this will allow you to generate unique campaign URLs in bulk. Rather than creating one at a time, you can quickly produce dozens of links for more comprehensive campaigns that spans multiple marketing channels and pieces of UTM content. This is blank so that you can make a copy of the Google Sheet and customize for your own campaigns.
• Example: Here I show you what using the bulk utm builder template may actually look like for a SaaS marketing campaign. Channels include email, social media, paid, organic and more. Use as inspiration! 
• AI Prompt: If you are still confused or just want extra help, I always recommend leveraging the power of AI to refine your strategies and tactics. Use this AI prompt to develop your own custom UTM Parameter framework for all of your marketing campaigns.

Here's the step by step process I recommend you take to get better marketing attribution with this UTM Builder for Google Sheets.

1. Review all tabs to familiarize yourself with the content.
2. Study the UTM parameter definitions.
3. Document your primary channels and sub-channels within dropdowns under the Medium and Source columns. You can use our Marketing Attribution Template to help. (Use the AI prompt I provide for assistance here).
4. Train your entire marketing team on how to use this UTM builder, so that the process is standardized.
5. For your next campaign, generate the UTM URL, then use that link for your campaign to track the performance of it.
6. Analyze the campaign performance data within Google Analytics or whichever reporting tool your use.

While this is a simple framework to use, you will noticed it has a massive impact on your ability to understand what's working vs. not.

You can download the UTM Builder Template now. Click "Add to Cart"  and checkout. I'll send you a link to the Google Sheet that you can copy.

You can get all of the marketing templates I use to run our marketing team within the VP of Marketing Playbook below.