Drill is a simple, ad-hoc query builder for exploring your raw Countly data. Pick a data type, add filters with AND/OR, and group results with BY.
Use Drill when you need answers like:
- Which users did event X with segment Y, and how does that vary by user property Z?
- How did sessions change for cohort X versus cohort Y in the last 30 or 60 days?
- Which platforms are used by users with low NPS, and what else correlates with that?
To get the most from Drill, track clean, consistent data with the Countly SDKs:
- Events with meaningful segment values (for example, plan, category, or level).
- User properties you want to filter by (for example, account type, region, or device).
- Views, crashes, and feedback data if you plan to analyze those in Drill.
- Numeric event fields (sum or duration) when you want ranges or thresholds.
After running a query, you can open matching User Profiles, send a push notification, save the query to Report Manager, or bookmark it for later. For frequent questions, add the query to a Dashboard. Very large queries may run in the background and finish later.
You can reach the full feature specifications of this feature from our User Guide documentation: