The Ecomm Analyst

Tool vendors will tell you that you needed their product six months ago. The truth is that a spreadsheet runs a measurement function far longer than anyone selling software wants to admit. Plenty of stores doing a few million a year manage their numbers in a sheet and make better decisions than brands paying for platforms they barely open. The question is not whether the spreadsheet is embarrassing. It is whether it has started costing you more than it saves.

The spreadsheet works for longer than you think

A weekly sheet that pulls ad spend from each platform, blended revenue from Shopify, and computes MER and contribution margin is a completely legitimate measurement system. It forces you to touch the numbers, which builds an instinct no dashboard gives you. It costs nothing. And for a store with a handful of channels and one person doing the analysis, it is often faster than logging into a tool and waiting for it to load. If your sheet takes twenty minutes on Monday morning and you trust the output, you do not have a problem worth spending money on yet.

The three signs you’ve actually outgrown it

The first sign is that the manual pull has become a real time sink. When reconciling the sheet eats half a day a week, the math has flipped and the tool is now cheaper than your time. The second is that you have stopped trusting it. Copy-paste errors, a formula someone broke three months ago, channels that do not reconcile against the platforms, and you find yourself second-guessing your own numbers before every decision. The third is that the questions you want to ask have outgrown what a sheet can answer. New versus returning customer economics, cohort behavior over time, channel-level contribution after shipping and fees, the kind of cut that takes you an hour to build by hand and is stale the moment you finish.

What you’re actually buying when you move

You are not buying better math. The formulas in your sheet are probably fine. You are buying the data pipeline, the part that connects to every platform, dedupes, and refreshes without you touching it, and you are buying the ability to ask a question and get an answer in seconds instead of an afternoon. That is the real upgrade. Anyone who pitches you a tool primarily on its attribution model is selling you the least important part. The plumbing is what saves you.

The trigger isn’t an ad-spend number

The advice you usually hear is to move once you cross some spend threshold, fifty thousand a month, a hundred thousand, whatever number the post was written to sell. That framing is backwards. I have seen stores at thirty thousand a month that needed real tooling because their channel mix was genuinely complex, and stores well past six figures that were fine on a sheet because they ran two channels cleanly. The actual trigger is the moment you start caring about measurement accuracy enough that being wrong costs you real money. That is when a tool earns its keep, and it is why I run client stores on ThoughtMetric once measurement accuracy becomes the thing standing between them and a confident budget decision. Disclosure, since I am naming it, I work with ThoughtMetric and have a stake in it, so read that as the biased recommendation it is. The setup is fast, minutes rather than an afternoon, which matters precisely because the spreadsheet you are replacing was valued on the time it ate.

Making the call

• If the sheet is fast, trusted, and answers your questions, keep it. Spend is not a reason to switch on its own.
• If you are losing hours to the manual pull, do the math on your own time. That number usually settles the question.
• If you have quietly stopped trusting your own numbers, move. A measurement system you second-guess is worse than no system, because it gives you false confidence.
• Judge tools on the data pipeline and how fast you get an answer, not on the attribution model in the sales deck.

There is no shame in a spreadsheet and no virtue in buying software early. Move when the sheet starts costing you more than it gives back, and not a month before.