UTM URL Builder Google Sheet for Tracking

“Quick Overview” Online marketing campaigns are only effective when you can measure their performance accurately. UTM parameters provide a simple and powerful way to track the success of your marketing efforts. In this step-by-step guide, we’ll show you how to create UTM parameters in Google Sheets, enabling you to monitor and analyze your campaigns with precision.

Step 1: Setting Up Your Google Sheets Document

• Go to Google Sheets
• Create a new spreadsheet

Step 2: Defining Your UTM Parameters

• You can enter as many parameters or dimensions including Date, Website URL, Source, Medium, Campaign, Term, Content, and Final URL.
• These headers will serve as labels for your UTM values.

Step 3: Filling in UTM Values

• Start entering your UTM values row by row.
• In the “Source” column, specify the traffic source (e.g., Facebook, Google Ads).
• In the “Medium” column, indicate the marketing medium (e.g., CPC, social, email).
• In the “Campaign” column, name your campaign for better organization.
• The “Term” column is often used for keyword tracking in paid search campaigns.
• The “Content” column can be used for differentiating ads or content variations.

Step 4: Generating UTM URLs

• Create a new column for “URLs.”
• Use the CONCATENATE function (or ‘&’ symbol) to combine your website URL with the UTM parameters.
• For example: =IF(OR(B2=“”,C2=“”,D2=“”),“”,B2&IF(ISNUMBER(FIND(“?”,B2)),“&”,“?”)&“utm_source=”&lower(C2)&“&utm_medium=”&lower(D2)&IF(E2<>“”,“&utm_campaign=”&lower(E2),“”)&IF(F2<>“”,“&utm_term=”&lower(F2),“”)&IF(G2<>“”,“&utm_content=”&lower(G2),“”))

Step 5: Copy and Use UTM URLs

• Copy the generated UTM URL and use it in your marketing campaigns.
• Share these UTM-tagged URLs in your email newsletters, social media posts, and ads.

Watch the Step by Step Guide Video