FREE - UTM Campaign Tracking Google Sheet

oddmorten • 21 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. 🙌


How to Do Marketing Without a Clear Business Strategy - The MOps Matrix by PlayMOps
by Odd Morten Sørensen 22 June 2025
Struggling to run marketing without a clear business strategy? Discover actionable steps to create focus, align your team, and drive results, even when company direction is missing.
The MOps Matrix by PlayMOps
by Odd Morten Sørensen 20 June 2025
Over the past year, I’ve spent more than 60 hours developing and refining the MOps Matrix, a framework designed to help marketing teams cut through complexity..
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..