Sample at Query-Time

Query-time sampling allows you to query a subset of users and shorten the time it takes for a report to load results. Insights is the only report that currently supports sampling at query time.

This feature is available to enterprise customers with over 5 million MTUs.

Enable or Disable Query Time Sampling

Navigate to the report where you would like to enable or disable sampling at time of query.

Enable Sampling

From the report in which you would like to use sampling, click the lightning bolt in the upper right corner of the query builder.

Enable_QTS.png

This will enable sampling on the report, and will be indicated by the lightning bolt symbol turning blue. The percentage of the total that is included in the query calculations will be indicated in the top right corner of the query builder.QTS_Enabled.png

Disable Sampling

To turn off sampling, click the lightning bolt symbol in the upper right corner of the query builder.

Disable_QTS.png

The lightning bolt symbol will turn grey to indicate that sampling is disabled.

Query Time Sampling Calculation and Presentation

Mixpanel will not sample, or drop, events at ingestion. Instead, Mixpanel will ingest all event data and sample at query time. This prevents the loss of important data, and therefore allows you to toggle sampling on and off depending on need.

For example, if you have a need for iterative querying, then sampling will greatly speed up this process. When the you build the proper query, you can turn off sampling and query the entire dataset.

The following occurs when sampling is enabled:

    1. Mixpanel selects a uniformly random sample of users on which to run the analysis.
    2. The sample size is 10% of the total population.
    3. The report is generated using that subset of users.
    4. Mixpanel up-samples the data by multiplying by the inverse of the sampling factor. This is done for functions such as totals and uniques. Functions that do not scale with users (average, min, max) will not be up-sampled.
    5. The effect is that numbers should closely approximate results seen without sampling enabled. This works better as the number of users increases, particularly for customers with more than 5 million users.
    6. Mixpanel adds an annotation such as “Sampled on 10% of users” to reports.

Saved Reports with Query Time Sampling

If you save a report that uses query time sampling, then a version of the report without sampling is saved. This ensures that dashboards and saved reports are computed on the entire dataset for high fidelity.

Is this article helpful?

Comments

0 comments

Please sign in to leave a comment.