FREE - UTM Campaign Tracking Google Sheet

oddmorten • 20 May 2025

I want to share with you a very helpful and easy tool that I’ve used to track my campaigns for over 17 years now. This is not groundbreaking stuff, there are many versions of this tracking sheet out there. But as this is one of my most used marketing tools over the years I want to share it with you.

About Campaign Tracking


Tracking marketing campaigns is crucial for understanding their effectiveness. It provides actionable insights about customer behaviors and interactions, informing strategy adjustments for improved ROI.


UTM parameters, or Urchin Tracking Module parameters, are simple codes added to URLs that communicate with Google Analytics to provide detailed performance metrics.


There are five types:


utm_source – Identifies the traffic source, e.g., Google, newsletter.


utm_medium – Describes the marketing medium, e.g., email, CPC.


utm_campaign – Names the specific effort or promotion, e.g., summer_sale.


utm_term – Used for paid search to identify keywords.


utm_content – Distinguishes similar content or links within the same ad.


These parameters provide granular data about traffic sources, effective keywords, successful campaigns, and more, thus supporting data-driven decision-making.


For example, if an email campaign (medium) from your July newsletter (source) promoting summer_sale (campaign) results in a high volume of traffic and conversions, you might replicate this successful strategy in future.


Also, underperforming campaigns could be revised or discontinued, optimizing marketing resources.


In essence, UTM parameters facilitate more precise, efficient marketing.


You can get your copy of my UTM Campaign Tracking Google sheet by clicking the link below.

It is totally free, just copy the google sheet to your own google drive and start using it.


If you find it useful, you are welcome to share it to whom you may please. 🙌


A woman is sitting at a desk in front of a computer.
by Odd Morten Sørensen 21 May 2025
Want A Career in Marketing Operations? Then this for you. The secret sauce to thrive in MOps lies in hands-on experience with marketing technology.
A black and white graph with arabic writing on a white background.
by Odd Morten Sørensen 19 May 2025
Because it is a crystal ball that tells you how much moolah a customer will drop in your coffers during their lifespan. Or in some other.. Read More »