# UTM link builder Excel (free) + campaign naming

> Free Excel UTM builder: enter the link, source, medium and campaign to get a lowercase UTM link and a structured campaign name, with duplicate and…

Source: https://softwiro.com/blog/ads-utm-naming-builder-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# UTM link builder and campaign naming in Excel (free): consistent links and structured names

Enter the link, source, medium and campaign once and get a clean UTM link and a structured campaign name, with warnings for duplicates.

13 November 2026 6 min read

## In short

- Enter the link, source, medium and campaign once per row.
- A full UTM link in consistent lowercase, plus a campaign name by one convention.
- Flags missing fields, unregistered sources and duplicate links.
- Links per source and medium. It does not shorten links or connect to platforms.

Ad data usually gets lost for the simplest reason: one person writes a link with a capital letter and another in lowercase, and a campaign is called "Friday offer" in Facebook and "black friday" in Google, so the numbers of one channel are scattered across the reports. The free [UTM link builder and campaign naming sheet](https://softwiro.com/templates/ads-utm-naming-builder) builds the full link and the campaign name by a fixed rule, and warns you about problems before you publish the ad.

## The problem it solves

A shop owner or ad marketer launches ads on Facebook, Instagram, Google, TikTok and more, and wants to know in Google Analytics which channel, campaign and ad brought the visits and orders. That works when every link carries UTM parameters written in one system. When each person writes them their own way, Facebook, facebook and fb show up as three sources and comparison is lost. Here you enter the link inputs once and the sheet normalises and builds.

## Steps from opening the file to a ready link

1. Settings: edit the lists of allowed sources and mediums, and pick the separator between the parts of the campaign name and their order: "Source first" or "Date first".
2. Links: in each row write the destination page link (starting with http), then pick the source and medium from the two lists.
3. Write the campaign name in any form (such as Black Friday 2026) and, if you like, the content (utm_content), term (utm_term) and date.
4. Copy the link from the Full link column into the ad, and use the Campaign name by convention column to name the campaign in the platform.
5. Check the Note and Duplicate columns: fix any missing field and avoid publishing two identical links.
6. Open Summary to see the number of links per source and medium and the number of duplicate or incomplete rows.

## Worked example (sample data)

The following figures are sample data for a demo shop (shop-demo.example.com) with 29 rows, from which the sheet built **27 ready links**, **25 of them with no note**:

- Facebook: the page /offers, source facebook, medium paid_social, campaign "Black Friday 2026" and content "Video A" gives …/offers?utm_source=facebook&utm_medium=paid_social&utm_campaign=black-friday-2026&utm_content=video-a, with the campaign name facebook_paid_social_black-friday-2026_202611 (the month comes from the date 1 November 2026).
- Google with a term: a search ad with content "RSA 1" and term "Winter Jackets" gives utm_content=rsa-1&utm_term=winter-jackets, named google_cpc_black-friday-2026_202611.
- A link that already has a ?: the page /products?cat=shoes continues with & so the link becomes …/products?cat=shoes&utm_source=google&utm_medium=cpc&utm_campaign=shoes-search…, named google_cpc_shoes-search_202610.
- Space clean-up: the content "Story Poll" (two spaces) becomes story-poll.
- A row with no date: the google "Winter Sale" ad with no date gets the name google_cpc_winter-sale, without the year-and-month part.
- Duplicates: two rows identical after normalising (the google "RSA 1" ad for /offers entered twice) show "Duplicate" and the Summary shows rows with a duplicate link = 2.
- 4 rows with a note: "unregistered source" (pinterest, whose link is still built), "medium missing" (TikTok with no medium, so no link is built), "campaign name missing" (a Facebook ad with no campaign, so none is built) and "link does not start with http" (shop-demo.example.com/winter without a protocol).
- By source: google 6, facebook 5, instagram 3, tiktok 3, newsletter 3, snapchat 2, youtube 2, whatsapp 2, linkedin 1 and x 1, which is 28 rows with a registered source (the twenty-ninth, pinterest, is unregistered).
- By medium: paid_social 15, cpc 5, email 3, influencer 2, whatsapp 2 and display 1, plus one row with no medium.
- "Date first" order: the name becomes 202611_facebook_paid_social_black-friday-2026.

## How the numbers are worked out

- Normalising a value: remove extra spaces, replace spaces with a hyphen, then convert to lowercase.
- Full link = page + ? (or & if there is already a ?) + utm_source + utm_medium + utm_campaign, then utm_content and utm_term if entered. It is built only when the page, source, medium and campaign are all filled.
- Campaign name by convention = source, medium and campaign joined by the separator you chose, then the year and month as 202611 if a date is entered.
- Duplicates: counted on the full link after normalising, so two links are duplicates if everything matches even if the capitalisation differed.

## Tracking basics you need

- The five parameters: source (where from), medium (channel type, such as cpc, paid_social and email), campaign, content (which ad) and term (which keyword). The first three are the core.
- Channel grouping in GA4: Google Analytics sorts visits into channels such as Paid Search, Paid Social and Email from the source and medium, so choosing a well-known medium helps the visit land in the expected channel. Grouping rules can change, so test a link and check the acquisition report.
- Auto-tagging: Google adds the click ID gclid and Meta usually adds fbclid, but that does not replace using your own structured names. Each platform's method (its URL-parameters field and macros) changes, so check its guide.
- Common mistakes: a capital letter in one place and lowercase in another, spaces in values, a second ?, parameters after #, UTM on your own site's internal links (it starts a new session and loses the original source), and customer data in the link.

## Limits and tips

- The sheet does not shorten links, check that the page works or connect to ad platforms. Shorten the link after it is built with a tool you trust, and test the link yourself.
- It holds 400 links, 10 sources and 8 mediums. The source and medium names in the sample are examples, not a standard from any platform, so edit them to suit you.
- Arabic names in the campaign work but show encoded in the link; Latin letters are better.
- Links containing # need your review because the parameters must come before the #.
- The sheet warns you if a source or medium is outside the lists but does not stop you typing it. Do not delete a cell from the middle of the lists, and do not type in the hidden "Key" column, which is used for the calculations.
- Platform interfaces, policies and figures change, and the sheet promises no results or benchmarks; performance differs from one business to another.

## Try it

[Open the sheet and try it online, or download it for Excel](https://softwiro.com/templates/ads-utm-naming-builder). If you want an app that standardises campaign names for your team and pulls their results from the platforms, [ask for it here](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: UTM links and campaign naming (1/4)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-1.jpg)[![Cheat sheet: UTM links and campaign naming (2/4)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-2.jpg)[![Cheat sheet: UTM links and campaign naming (3/4)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-3.jpg)[![Cheat sheet: UTM links and campaign naming (4/4)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-4.jpg)](https://softwiro.com/uploads/cheatsheets/ads-utm-naming-builder/en-4.jpg)

0 downloads · 4 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I build a UTM link in Excel?

Enter the page link, source, medium and campaign name on the Links sheet and the sheet adds utm_source, utm_medium and utm_campaign, then utm_content and utm_term if you entered them, after a ? (or an & if the link already contains a ?). The result appears in the Full link column for you to copy.

### Why are UTM values written in lowercase?

Because most analytics tools treat Facebook and facebook as two different sources, scattering the numbers of one channel. The sheet converts every value to lowercase and replaces spaces with a hyphen, so "Black Friday 2026" becomes black-friday-2026.

### Do I need UTM if the platform adds auto-tagging?

It depends on the platform and your settings. Google, for example, adds the click ID gclid through auto-tagging, and Meta usually adds the click ID fbclid, but UTM is what gives analytics tools the source, medium and campaign under your own names. Platform policies and interfaces change, so test one click and check the report before relying on it.

### Does the sheet shorten links or connect to ad platforms?

No. The sheet only builds the link and the name; it does not shorten links, check that the page works or read ad data from the platforms. The source and medium names in the sample are examples, not a standard from any platform.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
