Creating UTM parameters (also known as UTM tags, UTM tracking codes, or or Urchin Tracking Module parameters ) is a very, very important part of digital marketing – mostly because it allows you to measure everything you do and optimize along the way, at a very granular level.

If you do it the right way, every single action you take for your online marketing efforts can be quantified.

Creating UTM codes to track your campaigns on Google Analytics takes only two minutes, and the high-level overview behind it is the following:

  • The goal: to easily create and keep a database of all the UTM URLs for the different campaigns you are executing and which drive traffic back to your website.
  • The ideal outcome: consistent usage of UTM parameters across your team, across platforms, and across campaigns, which makes it very easy to understand the actual impact of the campaigns you are executing in a third-party tool like Google Analytics.
  • The importance of this action: this will allow you to assess how effective your marketing is. It’s often very difficult to find consistent usage for UTM URLs, but if you do it the right way, it makes measurement super-easy.
  • Where this is done: in your UTM Campaign Builder spreadsheet—available for download in this post. This is a freebie we’re offering for you to fill out with your own information.
  • When this is done: an UTM link is needed any time you plan to link to your site as part of an individual campaign.
    • Remember: some believe that you only have to do this for paid campaigns – however, this is something you should be doing any time you’re trying to drive traffic back to your website and you want to measure it, as well as any time you are running A/B testing for your marketing campaigns. Or, in other words, any time you are doing campaign tracking.
  • Who does this: Whoever is responsible for the execution of the campaign.

Get This Entire Walkthrough and All the Resources in This Post

Understanding the UTM Campaign URL Builder Spreadsheet

Before I dive into the UTM Builder spreadsheet and show you how I filled it out for the purpose of this example, it is important to learn a bit about how this works and what are the best practices to keep in mind:

UTM Builder Template
  • Fill out the campaign parameters first: Your campaign name, the base URL, the source, the medium (i.e which of the marketing channels you are using: social media, PPC ads, etc.), and maybe the content as well.
  • Stay away from special characters – use only numbers and letters. It just makes it easier for everyone.
  • The spreadsheet will automatically generate a website URL that always uses lowercase. Google Analytics UTM tags are case sensitive, so you don’t wanna miss any data by not knowing if your case is right with a certain campaign.
  • The URL generated by the spreadsheet will not use spaces – you can use them in the cells of the sheet, but they will be eventually changed in the final website URL. In the digital marketing world, URLs dashes and hyphens are spaces. This gets mixed up especially by programmers because they use underscores – but remember, you want to use hyphens in all situations (spaces will just get encoded in a weird way, with a “%20”).

You might also want to implement a rule in your organization regarding the use of hyphens, so that everything is consistent. With this spreadsheet, you couldn’t do anything wrong like this in any way, precisely because the spreadsheet will not allow you to do anything like this.

  • The spreadsheet will also add the current date automatically, when the website URL is generated. This is super-helpful because you want to keep a time reference of your tags both inside Google Analytics and within your UTM log. This way, when you will be analyzing big time periods, you will be able to quickly get a general idea of the period when that specific URL was promoted.
  • The date is also generated in a way that allows you to sort by the date, inside Google Analytics, by sorting it by a name inside the platform.
utm campaign sorting ads by name
  • This spreadsheet will also let you select your source, mediums, and placements from the list. This is important because you want to make sure everyone in your organization tags those parameters in the same way. For example, if one teammate uses UTM source equals “FB” and another one uses UTM source equals “Facebook”, this can cause problems. You want everyone to have this consistent pattern. It makes for way easier measurement later on.
  • Some of the columns in the spreadsheet have preset drop-down menus you can select according to your particular situation. If you don’t need all of these, or if you need to add other options in the dropdown menus, you can edit them (add or remove lines to the columns) in the “Settings: Source/Medium/Placements” tab in the spreadsheet.

Filling Out UTM Campaign Builder spreadsheet

Okay, so here’s how I filled this out – use the following as an example and apply it to your particular business needs:

  1. Created by: Tommy G.
  2. Base URL: https://www.clickminded.com
  3. Date: This will be automatically generated
  4. Source: Facebook (selected from the drop-down menu)
  5. Medium: Social (selected from the drop-down menu)
  6. Campaign: Fall Sale 2020 Campaign
  7. Term (AdSet/ Keyword): This is very specific for the campaign – so you might not always need it. I left it blank for now.
  8. Facebook Ad Placement: Feed
  9. Content: Fall Sale Infographic
  10. Final URL: https://www.clickminded.com?utm_source=facebook&utm_medium=social&utm_campaign=fall-sale-2020-campaign&utm_content=20180316-feed-fall-sale-infographic
    As you will see, this URL will be automatically generated by the spreadsheet, as you go along and fill out each of the columns.

Test Your UTM Parameter URL

Now that the final URL has been generated, it’s time to test it out and see if it actually works. Do this by following these steps:

  1. Go ahead and install the Google Tag Assistant Chrome Plug-in.
  2. Click on the URL you have just generated using the spreadsheet.
  3. Click on the Google Tag Assistant Chrome Plug-in.
  4. Make sure it’s enabled, then click “Record” (on right-hand side).
testing a utm parameter url
  1. Refresh the page.
  2. Go back to the Google Tag Assistant Chrome Plug-in and click “Stop Recording”.
result of tag analysis
  1. Click “Show full report” (blue button) → “Google Analytics Report”.
analysis report gtm - show full report
recording summary gtm
  1. On the report, you will see all the parameters of your campaign. If they all appear there, your UTM parameter URL worked.
working urm parameter url
  • If you are not seeing any results (no analytics found, no information found, no data found, etc.), check to see if you’re not using an AdBlocker or some type of Google Analytics opt-out (that blocks your own traffic from Google Analytics). Disable that and try to test your UTM parameter URL again.

That’s it! You’ve learned how to build UTM URLs using our builder template and you’ve tested that your URLs are working properly—now you’re ready to start tracking all your marketing efforts in Google Analytics.

More ClickMinded Resources

Double Conversions With Laser-Focused Google Analytics

Get the 2018 Ultimate Guide to Perfect Google Analytics Tracking sent to your inbox.

136 Shares
Share136
Tweet
Share