Sampling Users for Effective Mixpanel Analysis
How to do sampling on the volume of Users on a project in order to have a representative sample in Mixpanel ?
How to do sampling on the volume of Users on a project in order to have a representative sample in Mixpanel ?
Hi Sara E., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đ
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Mixpanel offers query time sampling which allows you to query a subset of users to reduce report loading times while still getting representative results. This feature is particularly useful for enterprise customers with large data volumes.
Query Time Sampling in Mixpanel
Query time sampling is available to enterprise customers with over 5 million Monthly Tracked Users (MTUs) or over 2 billion monthly events. The feature works by: 1. Selecting a uniformly random sample of 10% of your total user population 2. Generating reports using this subset 3. Up-sampling the data by multiplying by the inverse of the sampling factor for appropriate metricsThis approach preserves data integrity since Mixpanel doesn't drop events at ingestion - all data is stored, and sampling only happens when querying. This means you can toggle sampling on and off depending on your needs.
How to Enable Query Time Sampling
To enable sampling in a report: 1. Navigate to the report where you want to use sampling (Insights, Funnels, Retention, or Flows) 2. Click the lightning bolt icon in the upper right corner of the query builder 3. When enabled, the lightning bolt turns blue and shows the percentage of data being sampledTo disable sampling, simply click the lightning bolt again, and it will turn grey.Mixpanel Documentation: Query Time Sampling
Important Notes About Sampling
- When you save a report that uses query time sampling, Mixpanel saves a version without sampling to ensure Boards and saved reports use the entire dataset for high fidelity.
- Functions like totals and uniques are up-sampled, while metrics that don't scale with users (average, min, max) are not up-sampled.
- This sampling method works better as the number of users increases, particularly for customers with more than 5 million users.If you're implementing the SDK, you can also configure sampling at the collection level using the recordSessionsPercent parameter, which is particularly useful for Session Replay features.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.