How Long Should You Keep Closed Deal Data in Your CRM?

The short answer: keep the deal record forever, but archive the activity log after 24 months.

I build and customize CRM software for a living, and this is one of those questions that sounds simple until you actually try to set the policy in a real system. I've watched clients lose deals because they purged "old" data, and I've watched other clients drown in a database so cluttered they couldn't find anything useful. There's a middle path.

What to keep forever

The deal record itself - the contact, the company, the close date, the amount, the products or services sold, and a short summary of what closed and why - should stay in your CRM indefinitely. That's the data you'll need for renewals, referrals, win-loss analysis, lifetime value calculations, and the inevitable moment three years from now when that customer comes back and says "remember us?"

Deleting it costs you almost nothing in storage and costs you a fortune in lost context.

What goes stale

The activity log is the part that bloats. Every email thread, every call recording, every meeting note, every form fill, every automation trigger. I had a client hit 50 form fills in a couple months, and even at that modest volume the activity history piles up fast.

After about 24 months, almost nobody opens those old logs. They're not making decisions off a sales call from 2023. They're making decisions off the deal summary and the relationship.

My rule of thumb: archive activity older than 24 months out of the active CRM, but don't delete it. Move it to cold storage. Cheap, searchable, recoverable if you ever need it.

Archiving means the data still exists, just not in your day-to-day view. In my own builds I do this with a separate database table or an exported flat file (JSON, CSV, whatever your stack likes) that you can query if a legal or sales situation calls for it. Your sales team isn't scrolling through it. Your reports aren't pulling from it. But it's there.

Deleting means it's gone. And in most industries, you don't actually want gone.

The legal side

Depending on what you sell and where you operate, you may have minimum retention requirements that override your preferences. Financial services, healthcare, anything HIPAA-adjacent, anything with government contracts - those industries can require 7 to 10 years of records, sometimes longer. The IRS alone wants you holding onto certain business records for 7 years.

On the flip side, GDPR and CCPA give consumers the right to request deletion, and you have to honor that on a contact-by-contact basis. So your retention policy has to do two things at once: hold data long enough to satisfy regulators, and delete specific records on request without breaking the rest of your system.

The practical setup

Here's what I use for clients:

- Deal records live forever in the active CRM

- Activity logs auto-archive at 24 months to cold storage

- PII gets a deletion workflow tied to a request form, so when someone invokes their right to erasure, you can scrub them everywhere in one motion instead of hunting through five places

- Document the policy in writing. Review it once a year.

The mistake I see most often isn't keeping too much data. It's keeping all of it in the active database, then panic-deleting everything when the system slows down or someone gets nervous about compliance. That's how you lose deal history you needed.

The bottom line

Deals forever. Activity archives at 24 months. Deletion is reserved for actual compliance requests. And the policy lives in a document somewhere before you ever need it.

I wrote a longer breakdown of the real costs and tradeoffs of managing your own CRM data here: https://seedlycrm.com/blog/self-hosted-crm-real-numbers-from-an-agency-owner

If you're dealing with a specific industry's retention rules, drop a comment - this question comes up a lot and the answer shifts depending on what you sell.


Comments