Deciding what data to throw away

Every solo operator I know has a hard drive, a database, or a spreadsheet folder that has never had anything deleted from it. Every click event since 2021. Every draft invoice. Every version of a customer list that got exported “just in case.” Nobody decided to keep all of it. It just accumulated because deleting felt riskier than keeping.

I want to walk through how I actually think about this, because “how long to keep business data” doesn’t have one answer. It depends on what the data is, why you collected it, and what it’s costing you to keep it around.

Why keeping everything feels safe (and usually isn’t)

The instinct to keep data forever comes from a reasonable fear: what if I need it later and it’s gone. That fear is real. But it quietly ignores a second cost, which is that data you never clean out doesn’t just sit there for free.

It sits in a database that gets slower to query as it grows. It sits in exports that make your customer list harder to trust, because you can’t tell which rows are current and which are three migrations old. It sits in analytics tools where old, half-broken tracking events pollute your funnel numbers and cohort charts, so when you go to check “what’s our actual conversion rate this month,” you’re wading through years of dead test events, abandoned product lines, and one-off imports to get a clean number.

Storage itself is cheap. The real cost is confidence. Every extra year of unreviewed data is another place a bad number can hide.

Start with why you kept it in the first place

Before deciding whether to delete something, ask what job it was doing. Most business data falls into a small number of buckets, and each one has a different natural shelf life.

Operational data is what you need to run the business today: current customer contact info, open orders, active subscriptions. This stays as long as the relationship is active, full stop.

Financial records are invoices, receipts, payroll data, and anything tied to tax filings. This is the one category where “how long” isn’t really your call to make freely. Tax authorities and accounting rules typically set minimum retention windows for this kind of record, and they vary by country and by record type. I’m not going to tell you a specific number of years here, because that’s a question for your accountant or a licensed tax professional, not a YouTube channel about metrics. What I will say is: don’t apply your “clean up old data” instinct to this bucket without checking the actual requirement first. This is the one place where deleting too early can cost you real money.

Analytics and event data is clickstream data, pageviews, funnel events, A/B test logs. This is the stuff most of us over-collect, and it’s the safest category to prune, because its value decays fast. A raw click event from three years ago on a page that no longer exists isn’t telling you anything true about your business today.

Marketing and CRM history sits in between. Old email campaign data, past cohort assignments, historical churn records. This has some long-term value for trend analysis, but the individual raw records matter a lot less than the summary.

Raw data decays faster than summaries

This is the distinction that actually does most of the work when you’re deciding what to cut.

Say you run a small subscription business and you’ve been tracking monthly recurring revenue. You don’t need to keep every individual transaction record forever to know what your MRR trend looked like over the last three years. You need the monthly rollup: MRR by month, new vs. churned vs. expansion revenue by month. That rollup takes up almost no space and answers almost every question you’ll actually ask later, like “was Q3 2024 better than Q3 2023” or “did churn spike after that price change.”

The raw transaction log, meanwhile, is only useful for a narrower set of jobs: reconciling a specific customer dispute, debugging a billing bug, or recomputing a metric because you realize your old rollup logic had an error in it. Those are real reasons to keep raw data around, but they don’t require keeping it forever. They usually require keeping it for a defined window, like the current fiscal year plus one, after which you archive it to cold storage or let it go.

The same logic applies to A/B test data. Once a test concludes and you’ve recorded the result (which variant won, by how much, over what window), you don’t need every individual visitor’s raw event stream anymore. The conclusion is the durable artifact. The raw log was scaffolding to get there.

A simple test before you delete anything

I use three questions before clearing anything out. None of them are clever, but running through all three catches most of the mistakes.

Can I still answer my normal business questions without it? If deleting the raw event data still leaves you with monthly cohort tables, MRR history, and funnel conversion rates by period, you’re probably fine. If deleting it means you lose the ability to see churn broken out by acquisition channel, that’s a sign the summary you kept wasn’t detailed enough, and the fix might be to build a better rollup before deleting the raw data, not to keep the raw data forever.

Is there a legal, tax, or contractual reason this needs to exist for a set period? This covers financial records, but also things like signed contracts, data processing agreements, or anything a customer explicitly asked you to retain. If you’re not sure, that uncertainty is itself the answer: don’t delete it yet, and ask someone qualified.

Would I trust a number built from this data a year from now? This is the quality check. If a table has known gaps, duplicate rows from a broken sync, or events from before you fixed a tracking bug, keeping it doesn’t preserve information, it preserves a landmine. I’d rather delete a messy dataset and note in a doc that “data before March 2024 is unreliable due to a tracking bug” than keep it and risk someone building a report off it later without knowing.

What I actually delete on a schedule

In practice, I’ve settled into a rhythm that isn’t scientific but works for a one-person operation. Raw analytics events older than the current plus prior year get rolled up into monthly summaries and then dropped. Draft or abandoned customer records that never converted get purged after a defined window rather than sitting in the CRM forever diluting search results. Old A/B test raw logs get deleted once the test is closed and the result is written down somewhere durable, like a decision log. Financial records I leave alone entirely and defer to my accountant on retention length.

The one thing I never do is delete something because it’s inconvenient to look at. If a cohort chart looks bad because of a real churn spike, that’s not a reason to trim the data range until it looks better. Data governance isn’t about making the numbers flattering. It’s about making sure the numbers you keep are the ones you can actually trust and act on, and that everything else isn’t sitting around adding noise, cost, and confusion for no benefit.

None of this replaces professional advice on the financial and legal side, and it isn’t a promise that any particular retention approach will keep you fully compliant or protect you from every scenario. It’s just how I think about the tradeoff between “might need it” and “it’s actively making my data harder to trust.”

If you want more on how we think about metrics, governance, and the tools that help a one-person business keep its numbers honest, you can find the rest of our writing on the Data Research Analysis Collection home page.

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