[mblevin]

That's precisely why we price on a per-user basis at Indicative (https://www.indicative.com) and not on a per event basis.

What you described is a lot of work to build and maintain and very brittle. We've had quite a few customers switch to our platform from Mixpanel that were doing the same thing - aggregating data or sampling.

The problem with either is that you basically blow up your user-level data (e.g. John Smith doesn't have the right activity history), you will miss potentially important trends that are statistically significant that only appear over time, and you limit the type of analysis you do by "property stuffing", particularly around cohorts and retention.