How to track leads from social media with UTM links and a simple sheet
Short answer: To track leads from social media, put a UTM tag (a short piece of text added to the end of a web address that says where a visitor came from) on every link you post, record every enquiry in one sheet with the source filled in, and ask each new lead how they found you. Use lowercase, one naming rule and one sheet. Then test every link on every platform before you trust the numbers.
You post every week and enquiries arrive, but you cannot say which platform or which post sent them.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
Most small businesses can tell you how many likes a post got. Fewer can say which post led to a booked call. This guide gives you a naming standard for your links, a place to put each link on each platform, a lead sheet you can copy, a monthly report and a test plan to prove the links survive. It works with any scheduler. I also show where Blotato, a software subscription that writes, designs and schedules posts for up to 11 platforms, fits in. Nobody at Blur Studio has run Blotato, so treat the Blotato notes as vendor documentation and test them yourself.
This page may contain affiliate links from which Blur Studio earns commissions.
What a UTM tag is and what it can and cannot tell you
UTM stands for Urchin Tracking Module. In plain words, it is a set of labels you add after a question mark at the end of a link. Google Analytics 4, the free web traffic reporting tool from Google (called GA4 here), reads them and files each visit under the labels you chose. Google's help page lists these labels:
- utm_source: where the visitor came from, for example linkedin.
- utm_medium: the kind of channel, for example social.
- utm_campaign: the product, slogan or promotion, for example spring_audit.
- utm_content: tells two links in the same place apart, for example two buttons in one email.
- utm_id: a campaign ID, recommended by Google.
- utm_term: a paid keyword, which you will not need for organic posts.
Google says to always use source, medium and campaign. If you leave one out, reports show "(not set)". Google also says values are case sensitive, so "Meta" and "meta" count as two sources. That one fact is the reason for the whole naming standard below.
What UTM cannot do: it only sees people who click a tagged link and land on your website. It does not see someone who reads a post, then searches your name a week later. It does not see a phone call or a direct message (DM, a private message inside the app). So you need the sheet and a question as well, covered next.
Step 1: write a naming standard (copy this)
Decide once, write it on one page, and never improvise. Here is a standard that fits most small businesses.
| Label | Rule | Example |
|---|---|---|
| utm_source | The platform, lowercase, one word. Use the same word every time. | linkedin, instagram, facebook, x, tiktok, pinterest, youtube |
| utm_medium | Always the same for organic posts. | social |
| utm_campaign | The offer or theme, lowercase, underscores, no spaces, plus the month if the offer repeats. | free_audit_2026_11 |
| utm_content | The format and the post number from your sheet. | carousel_p014 |
Rules that stop most mess: lowercase only, underscores instead of spaces, no capital letters, no punctuation other than underscore, and one person owns the list of allowed campaign names. Google suggests using a distinct source for each sub-platform, so keep Facebook and Instagram as separate sources even though one company owns both.
A finished link looks like this:
https://yourdomain.com/free-audit?utm_source=linkedin&utm_medium=social&utm_campaign=free_audit_2026_11&utm_content=text_p014
Build links in a sheet with a formula that joins the parts, so nobody types them by hand. In Google Sheets, put the base address in column A, source in B, campaign in C and content in D, then use a formula in E such as: A2 & "?utm_source=" & B2 & "&utm_medium=social&utm_campaign=" & C2 & "&utm_content=" & D2. Copy the result into the post.
Step 2: where the link goes on each platform
A tagged link is only useful if people can click it. Platforms differ, and they change, so check each one's current rules. This is the pattern to plan for:
| Platform | Where to put the tagged link | Check before you rely on it |
|---|---|---|
| LinkedIn, the professional network | In the post text or the first comment. Blotato does not support the first comment on LinkedIn, per its help centre, so put the link in the post text. | Does the link show as clickable on desktop and phone? |
| X and Threads | In the post text. Blotato lists 280 characters for X and 500 for Threads, and a tagged link uses a good share of that. | Does the platform shorten the link, and does the tag survive? |
| Facebook Pages | In the post text, or in the first comment, which Blotato says it supports for Facebook and Instagram. | Does the link preview show the right page? |
| Instagram, the photo and video app from Meta | Links in captions are generally not clickable, so use the link in your bio. Blotato says link stickers are not supported on Stories through its tool. | Use one bio link page with tagged buttons, or one tagged link you change per campaign. |
| TikTok, the short video app | The bio link. Blotato says TikTok Shop product links are not supported. | Does the bio link field accept your tagged address? |
| The pin's destination link. Blotato lists a 2,048 character limit for it. | Open the pin and click through. | |
| YouTube | The top of the description. | Is it clickable in the first lines? |
For platforms where the link sits in your bio, the source is the platform but you lose the post level detail. Use a short code in the campaign name for the current push, and change the bio link only when the campaign changes. Write down the date of each change in the sheet so you can match visits to the right week.
Where a scheduler fits
A scheduler puts the same text in front of several platforms, which is exactly where a naming standard saves you. If you use a Blotato account, you paste a different tagged link into each platform's version of the post, because the source label must change per platform. As of November 2026 Blotato lists Starter at $29 a month, billed monthly, with a 7 day free trial that needs a card. See the free trial guide.
Be clear about what the tool measures. Blotato's analytics page shows posts published, views, comments, likes, publishing success rate, failed posts and top posts, and it covers only posts published through Blotato. It does not cover LinkedIn, Slack or Discord, and Blotato says numbers update on a schedule, not live. See what Blotato analytics shows and what is missing. Those are numbers about the post. They do not tell you who arrived on your site or who became a lead. UTM and your sheet fill that gap, and a scheduler is optional for it.
Step 3: the lead sheet (copy these columns)
Make one Google Sheets file with two tabs. Tab one is the post log. Tab two is the lead log.
Tab 1, Post log: Post ID (p001, p002), date, platform, format (text, carousel, video), topic, campaign name, full tagged link, hours spent.
Tab 2, Lead log:
| Column | What to enter |
|---|---|
| Date | The day the enquiry arrived |
| Name or ID | Initials or a code, not private details |
| How they contacted you | Form, call, DM, email, walk in |
| UTM source and campaign | Copied from your form or the analytics report, blank if none |
| Said they found you on | Their own words, from the question you ask |
| Final source | Your decision. UTM wins if present, otherwise what they said |
| Qualified (yes or no) | Fits your service and budget |
| Won (yes or no) and value | Money, in your own currency |
Two ways to capture the source automatically. First, a contact form with hidden fields that store the UTM values, which most form tools support, so each form entry carries its source. Second, a required "How did you hear about us?" question, with a pick list matching your platform names plus "referral", "search" and "other". The pick list matters. A free text box gives you "online" and "Instagram or maybe LinkedIn". For calls and DMs, ask in the first minute and type the answer straight into the lead log.
If you are in a country with strict rules on tracking visitors, such as the UK or the EU, check the rules for analytics cookies and consent on your site. This is information, not legal advice. Check your regulator's current guidance.
A worked example (made-up numbers)
A solo consultant posts 20 times in November: 10 on LinkedIn, 6 on Instagram, 4 on X. Every post links to one page with tagged links. These numbers are made up to show the method.
| Source | Posts | Hours spent | Visits (GA4) | Leads | Qualified | Won | Revenue |
|---|---|---|---|---|---|---|---|
| 10 | 6 | 140 | 7 | 4 | 1 | $1,500 | |
| 6 | 5 | 60 | 2 | 0 | 0 | $0 | |
| x | 4 | 1 | 15 | 0 | 0 | 0 | $0 |
| Total | 20 | 12 | 215 | 9 | 4 | 1 | $1,500 |
At a made-up value of $50 an hour for her time, 12 hours is $600. Cost per lead is $600 divided by 9, about $67. Cost per qualified lead is $150. LinkedIn used 6 of those 12 hours and produced all 4 qualified leads. One month is far too little to decide anything, so she does not drop Instagram yet. She keeps the sheet running for a full quarter, then compares.
Two Instagram leads and zero qualified ones is a small sample, not proof. Write "too early" in the notes column until a source has at least 20 leads. That is a rough rule of mine, not a statistical test.
Step 4: the one page monthly report
- Pull the visit counts by source and campaign from GA4 for the month.
- Count leads per final source from your lead log.
- Work out visits per post, leads per 100 visits, qualified share and revenue per hour spent.
- Write three lines: what source brought the best qualified leads, which campaign brought the most visits with the fewest leads, and one thing to change next month.
- Compare with last month only after you have three months of data.
Watch the gap between visits and leads. High visits and few leads usually means the landing page or the offer is weak, not the post. High leads and few visits means people are finding you another way, such as search or word of mouth, and the post only helped.
Step 5: the test plan, so you trust the links
Run this before you publish a campaign and again after any platform or website change. Use a test lead you create yourself.
| Test | How | Pass | Fail |
|---|---|---|---|
| Link survives the platform | Publish a private or draft version if the platform allows it, or a real post you delete after the test. Click the link on a phone and a laptop. | The page opens and the address bar still shows the tags | Tags missing, page error or redirect that drops them |
| Link appears in analytics | After the click, open the GA4 reports and look for the source and medium you used | Source shows as linkedin, medium as social | Shows as direct, other or (not set) |
| Form stores the source | Submit the form from a tagged link | Your lead log or form tool shows the UTM values | The fields are blank |
| Case and spelling | Check the report for twins such as Linkedin and linkedin | One row per source | Two rows for the same source |
| Bio link change | Change the bio link and note the time. Click it a day later | New tags appear | Old tags still appear |
Visits from some apps arrive without any source, even with tags, because certain in-app browsers hide where the click came from. That is why the "how did you hear about us" question stays even when UTM works. Expect UTM to miss some leads and treat the number as a floor.
Mistakes that ruin the data
- Capital letters. Google treats them as different values. Lowercase only.
- Tagging links on your own website. Tags are for links coming from outside. Tagging internal links can overwrite the real source.
- Reusing one link on every platform. You get one source for everything.
- Changing names mid-quarter. You cannot compare month one with month three.
- Counting likes as leads. A like is not an enquiry.
- Not asking. A tagged link misses calls, DMs and people who search your name later.
How this page was checked
The UTM labels and the case sensitivity rule come from Google's own Analytics help page. Blotato's limits, plan price, trial terms and analytics scope come from Blotato's pricing page and help centre. Last checked 21 November 2026, refreshed every 90 days. Blur Studio has not run Blotato itself, so use the 7 day trial or any scheduler you already own to run the test plan above. Platform rules on links change often, so check each platform's current help pages.
How I'd approach this
I would not buy anything to do this. A free sheet, GA4 and one question on your form are enough. Add a scheduler only if posting itself eats your week, and then try a trial of Blotato or a rival and measure first. For help with the weekly rhythm, see social media content for owners in two hours a week, and for a worked Dubai attribution case see lead source attribution and cost per lead. If you want a second pair of eyes on your setup, the free AI tools at /free or a free AI brainstorm call are open to you.
First week: day 1, write the naming standard on one page. Day 2, build the sheet with the link formula. Day 3, add the source question and hidden fields to your form. Day 4, run the five tests. Day 5, publish your next five posts with tagged links and log each in Tab 1. Day 6, log every enquiry so far, asking each person how they found you. Day 7, write the first one page report and mark every number "too early". Repeat for a quarter before you cut anything.
Questions people ask
What is a UTM link in simple words?
It is a normal web address with a few labels added at the end, such as utm_source=linkedin. When someone clicks it, Google Analytics reads the labels and files the visit under that source.
Do UTM links work on Instagram?
Links in Instagram captions are generally not clickable, so the working place for a tagged link is your bio link. Check Instagram's current rules, since they change. Blotato says link stickers on Stories are not supported through its tool.
Which UTM labels do I really need?
Google says to always use utm_source, utm_medium and utm_campaign. Add utm_content if you want to compare formats or individual posts. utm_term is for paid keywords.
Does Blotato track leads or clicks to my site?
Blotato's analytics page lists posts published, views, comments, likes, publishing success rate and top posts for posts sent through it. It does not describe tracking visitors or leads on your site, so use UTM tags and a lead sheet for that.
Why does Google Analytics show two rows for the same source?
Values are case sensitive, so Linkedin and linkedin are two sources. Use lowercase every time and fix old links to match the standard.
Can I track leads from DMs and calls?
Not with UTM. Ask each person how they found you and type the answer in the lead sheet. Use a pick list of platform names so the answers can be counted.
How many leads do I need before I trust the numbers?
There is no magic number. As a rough rule I wait for about 20 leads per source and a full quarter before cutting a channel. Read our weekly content plan for a lighter routine.
Do I need consent to use UTM tags?
The tags themselves are only labels on a link. Rules about analytics cookies and consent depend on where your visitors live, so check your regulator's current guidance. This is information, not legal advice.
More in this topic: Social media: growth, calendars and routines for solo owners (36 guides) →