A year of doing my own reporting

A year ago I stopped waiting for a dashboard to tell me how my business was doing and started building the reports myself. Not because I distrust tools. I still use plenty of them. I did it because every time a number looked strange, the tool couldn’t tell me why, and I was tired of guessing. This is a review of that year: what I actually track, what each metric can and can’t tell you, and what changed once I started doing this on a weekly cadence instead of glancing at a dashboard once a month.

Why I started tracking this myself

The trigger was small. I noticed my monthly revenue number had dropped, panicked for about ten minutes, then realized it was a billing date quirk, not a real decline. That’s a cheap mistake if you catch it in ten minutes. It’s an expensive one if you make a decision based on it. Doing my own reporting means I know exactly how each number is built, which means when something looks off I can trace it back to a cause instead of a vibe.

The metrics I actually check every week

I keep the list short on purpose. Every week I look at churn, MRR, a rough CLV estimate, and conversion rate through the main funnel. That’s it. I used to track a dozen things and ended up checking none of them properly. A smaller list you actually read beats a long one you scroll past.

Churn taught me to pay attention to the wrong questions

Churn is just the percentage of customers or subscribers who leave in a given period. Simple to define, harder to interpret. Early on I treated a single bad month as a crisis. Then I started separating churn by cohort, meaning I grouped customers by the month they signed up and watched each group over time. That showed me something a single monthly number hides: some cohorts churned fast in month one and then stabilized, while others looked fine at first and fell apart in month three. A single churn rate averages all of that into one misleading figure. The lesson wasn’t “reduce churn.” It was “know which churn you’re looking at before you react to it.”

MRR is a mood, not a fact

Monthly recurring revenue gets treated like a scoreboard, and I get why. It’s one number, it goes up or down, and it feels like proof. But MRR is really a snapshot of active subscriptions multiplied by price, and it moves for reasons that have nothing to do with whether the business is healthy. A pricing change, a batch of annual plans converting to monthly, a currency shift if you sell internationally, any of these can move MRR without a single customer changing their mind about your product. I still track it every week. I just stopped treating it as a verdict and started treating it as one input among several.

CLV is a guess dressed up as a number

Customer lifetime value is supposed to tell you how much a customer is worth over the life of the relationship. In practice, for a small operation without years of stable history, it’s a projection built on assumptions: average retention length, average spend, maybe a discount rate if you’re being formal about it. I calculate a rough CLV because it’s useful for deciding how much I’m willing to spend to acquire a customer. But I don’t quote it to anyone as a hard fact, and I don’t let it justify spending I can’t actually afford if the projection turns out to be optimistic. It’s a planning tool, not a promise.

Conversion and funnels: where the leaks actually are

Conversion rate is the percentage of people who take the next step you want them to take, whether that’s signing up, checking out, or replying to an email. On its own it’s just a percentage. What made it useful for me was building it into a funnel: how many people saw the offer, how many clicked, how many started checkout, how many finished. Each stage has its own conversion rate, and the drop between two specific stages tells you where to look. I found one stage in my own checkout that was losing more people than the rest combined, and it turned out to be a form field that didn’t work properly on mobile. No amount of staring at the overall conversion number would have shown me that. Only breaking it into stages did.

Cohorts changed how I read every chart

Once I started grouping data by cohort, meaning by the time period someone joined or the channel they came from, a lot of charts that used to look like noise started making sense. A rising trend line can hide a shrinking best cohort and a growing weaker one. Cohort views don’t make the data prettier. They make it more honest, because they stop you from averaging away exactly the differences you need to see.

A/B testing on a small list is harder than it looks

I ran a handful of A/B tests this year, mostly on email subject lines and one landing page headline. The honest takeaway is that with the traffic and list size a one-person business actually has, most tests don’t reach a result you can be confident in within a reasonable time. I still run them, because directional signal is better than none, but I stopped treating a test that ran for four days on a few hundred visitors as settled science. A method being rigorous in theory doesn’t mean a small sample gives you a rigorous answer. Judgment still has to fill the gap.

Attribution: picking one honest story, not the perfect one

Attribution is about deciding which marketing touchpoint gets credit when someone converts. If I’m honest, there’s no clean answer here for a business my size. I don’t have the volume of touchpoints or the tooling to do proper multi-touch attribution, so I settled on last-touch attribution and I say that out loud whenever I share a number that depends on it. It’s not the most accurate model. It’s the one I can actually explain and reproduce, and a number I understand the limits of is more useful than one I can’t explain at all.

Where AI tools actually saved me time

The place AI tools earned their keep this year wasn’t in deciding anything. It was in the grunt work: cleaning up messy exports, writing the first draft of a weekly summary from a table of numbers, catching formatting inconsistencies across spreadsheets before they turned into wrong totals. I still read every summary and check every number before I act on it. The tools compressed the time between “I have the data” and “I have something readable,” they didn’t replace the part where I decide what the data means.

Data quality is the boring part that matters most

None of the metrics above mean anything if the underlying data is wrong, and this was the least glamorous lesson of the year. I found duplicate customer records, a tracking pixel that had been double-firing for two months, and a spreadsheet formula that silently excluded the last row every time someone added new data. Each of these quietly distorted a metric I was checking every week, and none of them showed up as an error. They just showed up as numbers that were a little bit wrong in a way that was easy to miss. Governance for a one-person business doesn’t mean a formal process. It means periodically asking where a number actually comes from and checking that the answer still holds.

What a year of this actually changed

I don’t have a bigger business because I started doing my own reporting. That’s not what this was for, and I’m not going to pretend it is. What changed is that I trust the numbers I look at, because I know how they’re built and where they can mislead me. I catch billing quirks before they become panic. I know which cohort is actually struggling instead of reacting to an average. And I’ve gotten more comfortable saying “I don’t know” about a number instead of presenting a guess as certainty. That’s a smaller win than a growth chart, but it’s the one that’s held up.

If you want more of this kind of walkthrough, plain-English explanations of the metrics and methods behind running a small business on real numbers, you can find the rest of what we’ve written over at Data Research Analysis Collection.

Get new guides and videos first — join the Telegram channel.