Someone asks whether your content is paying off, and the honest answer is a shrug. You can see likes and follower counts. You have a vague sense that 2 clients mentioned a post, and you've spent 3 to 6 hours a week on it for a year.
Buyers of expert services often take a winding route. They read 4 posts, forget you, hear your name from a peer, then book. A tracker that forces every sale into 1 tidy source will mislead you in whichever direction suits your mood that week.
This article sets up records you can keep in a spreadsheet in 15 minutes a week: organic entry pages, resource leads, held calls, customers and collected revenue, with unknown and assisted sources left in plain view. It ends with an illustrative contribution calculation that keeps owner time apart from cash, and a rule for choosing your next test.
Jump to the free Personal Brand Results Tracker
Define the outcome and cost period for personal branding ROI
Personal branding ROI needs 2 definitions before any numbers: the outcome you count and the period you count it over. For most service businesses, that outcome is collected revenue from new customers. Measure a 90-day cohort of leads, list cash costs and owner hours separately, and keep counting the cohort's revenue for 1 sales cycle after the window closes.
Choose the outcome
Collected revenue is cash that has arrived from customers whose first contact falls inside the window. Signed contracts and open proposals get their own columns; they matter, and they can still change. Repeat work from existing clients stays out unless you're measuring retention on purpose.
Separate cash costs and owner hours
Cash costs are what you pay for during the window: an editor, design and scheduling tools, boosted posts, a share of website hosting. Owner hours are your writing, recording, replying and call time. Keep them in 2 columns that never add together, and bring an hourly value for your time into the decision later, beside the cash figure.
Contribution, in this tracker, is collected revenue minus the cash cost of delivering the work sold and minus the content's cash costs. Owner hours sit beside that figure, never inside it.
Set the close window
If deals take 6 weeks from first call to payment, a 90-day lead window needs at least another 6 weeks before you total revenue. Judge too early and slow-closing content leads look like failures.
This article stays on commercial results. Production measures such as editing time and defects per draft belong in a separate review of your AI content engine.
Record sources, calls, sales and uncertain attribution
Record every new lead as 1 row with 3 source fields: what the person says brought them, what your tracking shows, and any other touch you know about. When those fields disagree or sit empty, mark the lead assisted or unknown and keep the row. Deleting messy rows makes content look either worthless or miraculous.
Tab 1: entry pages, monthly
Once a month, open the Landing page report in Google Analytics (Reports, then Engagement, then Landing page), add the secondary dimension Session source / medium, and copy the sessions on rows whose medium is organic (google / organic, bing / organic). A session that starts on a page is an entrance to it, so those are your organic entrances. Beside each page, record the resource leads and inquiries it produced. When each article offers its own download, the download tells you the page; when downloads are shared, record the page in a hidden form field.
Search Console clicks won't match those entrances. Google's comparison of the 2 tools explains that clicks and sessions are calculated differently, so use Search Console for search visibility and Analytics for what visitors do once they arrive.
Tab 2: leads, 1 row each
| Column | What goes in it | Where it comes from |
|---|---|---|
| First contact date | The day they wrote in or downloaded | Form or inbox |
| Self-reported source | Their answer to "How did you first hear about me?" | Form field and first call |
| Tracked source | UTM tag or referrer | Analytics, hidden form fields |
| Other touches | Posts, emails, referrals or events they mention | Call notes |
| Source status | Content, Assisted, Other or Unknown | The rules below |
| Resource lead | Which download, if any | Form |
| Call held | Date, or blank | Calendar |
| Signed or proposed | Value of a signed contract or open proposal | Proposals and contracts |
| Collected revenue | Cash received to date, and the offer bought | Invoices |
Ask the source question twice, as an open text field on every form and again on the call, and write the answer in their words. Tag every link you post so tracked source isn't blank by default; Google says to always include utm_source, utm_medium and utm_campaign.
Source status rules
- Content: the person names a post, article, video or download (or your tracking shows one when they give no answer), and nothing else came first.
- Assisted: content appears among the touches, and a referral or event came first.
- Other: no content touch at all.
- Unknown: no answer and no tracking. These rows stay in every total.
Use the results to decide the next test
When the close window ends, total each source status and calculate contribution for content-sourced revenue, with assisted revenue shown as a separate range. Set the result beside your owner hours. Then find the stage where the cohort dropped most (entrances, leads, held calls or customers) and choose 1 test for the next 90 days.
Pick the test from the biggest drop
| Biggest drop | What it suggests | Test for the next 90 days |
|---|---|---|
| Few organic entrances | Pages don't match what buyers search | Retitle 2 pages around queries Search Console shows |
| Entrances but few leads | The download doesn't fit the page | Offer a page-specific download on the top 2 entry pages |
| Leads but few held calls | A follow-up gap | Add an email after each download that invites a reply |
| Held calls but few customers | Fit, offer or price | Review qualification questions and the offer on calls |
When the drop sits before the lead, the diagnosis for content that gets views but few inquiries goes further. The Business Outcome score in the KPI Quartet reads from these same records.
Worked example: Nadia Ferreira's first cohort
Nadia Ferreira (fictional) runs a 1-person pricing consultancy for independent veterinary clinics. Her main offer is a 6-week pricing review at $6,000, and a fee audit sells for $1,500. The lead window ran July 1 to September 30, and she counted that cohort's revenue through December 31; every figure is invented to show the arithmetic.
Her 6 articles drew 1,240 organic entrances over the window, and their 3 downloads produced 22 resource leads. Her form records the page each download came from, so Tab 1 reads like this:
| Entry page | Organic entrances | Resource leads | Inquiries naming it |
|---|---|---|---|
| Pricing dental cleanings at an independent clinic | 520 | 11 | 2 |
| Raising exam fees without losing clients | 340 | 7 | 1 |
| The other 4 articles combined | 380 | 4 | 1 |
| Total | 1,240 | 22 | 4 |
At the close of the window, her Tab 2 rows totaled like this:
| Source status | Leads | Held calls | Customers | Collected revenue |
|---|---|---|---|---|
| Content | 26 | 5 | 2 | $7,500 |
| Assisted | 6 | 3 | 2 | $7,500 |
| Other | 7 | 5 | 3 | $13,500 |
| Unknown | 5 | 1 | 0 | $0 |
| Total | 44 | 14 | 7 | $28,500 |
Content's 26 leads are the 22 downloads plus 4 direct inquiries that named an article. Its 2 customers bought 1 pricing review and 1 fee audit, and so did the 2 assisted customers.
For the window, cash costs were an editor at $400 a month ($1,200), tools at $70 a month ($210) and a $60 share of hosting, for $1,470. Delivery costs $600 per review and $100 per fee audit. Owner time was 4 hours a week on content for 13 weeks plus about 4 hours on the 8 calls with content and assisted leads, so 56 hours.
| Line | Amount |
|---|---|
| Content-sourced revenue | $7,500 |
| Delivery for 1 review and 1 fee audit | -$700 |
| Content cash costs | -$1,470 |
| Cash contribution, content only | $5,330 |
| Assisted contribution ($7,500 minus $700 delivery) | $6,800 |
| Cash contribution range | $5,330 to $12,130 |
| Owner hours, kept separate | 56 |
Divided by the 56 hours, that's about $95 per owner hour on the content-only figure and about $217 at the top of the range. Both figures leave out the hours Nadia spends delivering the work she sold, so they'd flatter content if set beside her $150 billing rate, which has to pay for delivery time. The fair comparison is the same sum for her next cohort, with the range reported each time so both readings stay visible.
The 5 unknown leads stay in the table. One of them held a call, and if a later answer traces it to an article, the content figure moves.
With 7 customers, this cohort shows direction and little more. Its clearest drop sits between download and conversation: 2 of 22 resource leads held a call, against 3 of 4 direct inquiries. Her next test adds an email 2 days after each download that asks 1 question about the clinic's fee schedule and offers a 20-minute call, with a target of 1 held call per 5 downloads in the next cohort.
Set up the 2 tabs this week and add the source question to every form before the next lead arrives. Then back-fill the last 90 days from your inbox and calendar, mark anything you can't trace as unknown, and put the close-window date in your calendar. If you want the system behind the numbers, the personal brand content strategy guide sets out what to publish and why.