How to track revenue from social media without losing your mind
You don't need a tech stack. You need three columns, one question, and a 15-minute weekly ritual
Last week’s audit ended on revenue tracking. This week we go deep on it.
Most founders avoid revenue tracking because they think it requires UTM codes, a CRM, and a weekend they don’t have. It doesn’t. The reason your tracking is broken isn’t a technology problem. It’s a discipline problem. Three columns and one weekly habit will outperform every analytics tool you don’t actually open.
Here’s the system.
The lie of attribution
Big brands track conversions with code. Pixels. UTMs. Multi-touch attribution models. None of that is built for the way service businesses, coaches, and operators actually sell.
When someone is going to hire you for $2,000 to $20,000 or more, they don’t click a UTM and convert in 30 seconds. They sit on your content for six months. They subscribe to your newsletter. They lurk. They DM their friend about you. They watch a podcast episode. Then they fill out your discovery call form.
UTM codes will tell you what they did at the very end. They will not tell you what made them book the call.
This is why most founders give up on tracking. They try to run an enterprise attribution model on a relationship-driven business. Drop it. You don’t need it.
The three-column system
You need three columns. That’s the whole spreadsheet.
Column 1: Lead source. Where did this person first find me?
Column 2: Discovery call booked. Yes or no, with the date.
Column 3: Closed revenue. Yes or no, with the amount.
That’s it. The tool doesn’t matter. Notion, Google Sheets, your CRM, an Apple Note. The discipline matters.
The lead source field gets populated by one question on your discovery call form: “Where did you first hear about my work?”
That single question, asked of every lead, replaces every UTM code in your stack. It’s manual, it’s qualitative, and it tells you the truth.
The weekly ritual
Once a week, fifteen minutes, you do this:
Add new leads from the past week
Update which discovery calls happened
Update which calls converted to closed revenue
Look at the lead source column
After eight weeks of doing this, patterns emerge. One channel will be producing 40 percent of your closed revenue while only producing 10 percent of your follower growth. That’s the channel to feed. Another channel will produce 50 percent of your follower growth and 5 percent of your revenue. That’s the channel to deprioritize.
You don’t need fancy attribution. You need a weekly habit and the patience to let the data accumulate. Eight weeks. That’s the threshold where the picture sharpens.
Four mistakes founders make
I see the same four mistakes constantly when founders try to build this.
Mistake one: tracking too early. If you’re not running discovery calls yet, you don’t have a tracking problem. You have a funnel problem. Fix the funnel before you build the spreadsheet.
Mistake two: tracking too many channels. If you’re posting on six platforms, you can’t track six sources reliably. The data is too thin. Cut your active channels to two or three. Track those. Optimize.
Mistake three: mistaking views for value. A platform with high views and low conversions is not a business channel. It’s a brand channel. They serve different functions and you should treat them differently. The math is different.
Mistake four: not asking the question. This is the most common mistake. Founders skip the “where did you first hear about my work” question because it feels intrusive or unprofessional. It’s not. It’s the most useful data point in your entire business. Add it today.
What to actually change
After eight weeks of tracking, you’ll have a clear picture of which channels are producing revenue. The point of having the data is to give you permission to act on it.
Triple down on the producing channel. If LinkedIn is producing 40 percent of your closed revenue and your podcast is producing 4 percent, your time allocation should reflect that. Most founders’ time allocation has nothing to do with their revenue allocation. Fix that.
Cut effort on the non-producing channel. This is the part founders resist. They want to maintain presence everywhere because they’re afraid of missing something. That fear is a tax on your strategy. The data is permission to focus.
Resist the urge to be everywhere. Most founders try to maintain presence on every platform because someone told them to be omnipresent. Omnipresent is a brand strategy, not a revenue strategy. They’re different things.
The point of tracking isn’t to feel busy. It’s to give you permission to focus.
What this looks like in practice
Here’s a real example of what changes when this system is in place.
Before tracking, a founder posts on Instagram, TikTok, LinkedIn, and Substack. Spends roughly equal time on each. Books inconsistent calls. Can’t tell what’s working. Feels exhausted.
After eight weeks of the three-column system, the founder sees:
LinkedIn is producing the majority of closed revenue
Substack is producing high-quality leads who close at premium rates
Instagram is producing high engagement and follower growth but very few buyers
TikTok is producing reach with no measurable revenue
The founder cuts TikTok. Reduces Instagram to maintenance. Doubles down on LinkedIn and Substack. Books more calls. Closes higher-value clients. Works fewer hours.
This is what the data actually does. It doesn’t tell you to post more. It tells you what to stop.
Closing
Tracking revenue from social isn’t an analytics problem. It’s a discipline problem. Three columns, one question, fifteen minutes a week. That’s the system.
If you want help setting up the tracking, the weekly ritual, and the strategy decisions that come out of it, that’s exactly what my 1:1 coaching is built for. Most clients have an attribution gap inside the first month, and we close it together. Then the rest of the strategy work has data to point at.
If you’d rather hand off the production side and run the tracking yourself, my Custom Content Packages handle the script writing, content production, and platform-specific build, so your time goes to the offer and operations work that the spreadsheet keeps surfacing.
Both start with a 30-minute discovery call.
Next week: why content pillars are over and what to use instead.