This article will help you:
- Understand query time sampling
- Set query time sampling as the default for all new funnel charts
At times, querying large datasets can be time consuming, resource-heavy, and difficult to execute. Amplitude's query engine can use a technique called query time sampling to optimize performance and reduce execution time.
When query time sampling is enabled, Amplitude's query engine will select a representative subset of data—specifically, events based on a randomly-selected 10% sample of users—for analysis. It will then up-sample the results, using advanced statistical methods like inverse sampling to extrapolate them to the entire population.
NOTE: Up-sampling is done for functions that scale with the number of users, such as totals and uniques. It will not be used for those that do not scale in this way, like average, min, and max.
Feature availability
This feature is available to users on all Amplitude plans. See our pricing page for more details.
-
- Query time sampling is available for Event Segmentation and Funnel Analysis charts only.
Enable query time sampling
To enable query time sampling, follow these steps:
- From your Funnel Analysis, click
.
- The
.
To return to querying your full dataset, turn off query time sampling by clicking .
Set query time sampling as the default
Admin users can set query time sampling as the default for all new charts in a project. To do so, follow these steps:
- Click
to view your organizational settings.
- Click Projects.
- Choose the project you'd like to modify and switch the Query time sampling toggle to On.
Caveats
Query time sampling can be a useful way to streamline your workflow, but it's important to keep a few things in mind:
- It may not always be suitable for all types of analyses. These include queries with small datasets, queries that require a high level of granularity, or queries looking for property max, min, or count when the data is highly variable.
- The following features are unavailable when query time sampling is enabled in Amplitude Analytics: create cohorts, set monitors and alerts, scale sampling during data ingestion, and account analysis.
- Merge users are currently not supported yet, but will be supported soon. This means orgs with lots of merge users may see inaccurate results. Merged user support has been implemented for funnels.