--- title: "Drill: event segmentation and analysis without SQL · Countly" description: "Drill queries every raw event your apps send, with every property attached. No SQL, no export to a warehouse, and the data stays in an environment that’s yours." url: https://countly.com/feature/drill last_modified: 2026-11-11 --- Drill # Ask the question no dashboard was built for Drill queries every raw event your apps send, with every property attached. No SQL, no export to a warehouse, and the data stays in an environment that’s yours. In this demo car app, one question asked five ways at once: how sessions differ for drivers with and without a home charger, against the period before. Part of analytics ## Reports answer the questions someone planned for Every product team has questions no report was built for. Drill answers them from the events themselves, so the answer doesn’t wait in a queue for the data team. - Break any metric down Split any event by a profile property, an event property or a cohort. One line per group shows which one moved. - Turn two counts into a rate Divide one event by another. The rate is computed per day and per group, with both inputs beside it. - Slice freely in Explore Branch any row by another property, split the columns, exclude a value. The table re-runs as you go. - Ask Cee what happened, and why Cee runs its own follow-up queries, then answers with a verdict that cites every one of them. In practice ## Questions teams answer in Drill every day Product, growth, support and engineering all ask different things. They all get the answer from the same events, without writing SQL or waiting for the data team. - Which app version crashes most? - Do Android users buy more than iOS users? - How many people tried the new feature? - Which countries grew this month? - What share of sessions end in a purchase? - Did the release change sign-ups? - Which campaign brought the most sign-ups? - What time of day is the app busiest? - How much revenue does a web session bring? - Who are the users behind this spike? - How big is our trial cohort today? - Which screen do tablet users open most? - How many users came back this week? - Which OS version has the most errors? - How many push messages were opened? - Which languages do our users read in? - What do premium users do more of? - Which survey answer comes up most? - How long is a session on iOS? - How many orders used the new checkout? - Which device models are most common? - Did the price change affect upgrades? - Which cities are growing fastest? - Where do new users come from? What you can ask about ## Every event, every app, every person A question is only as good as the data it can reach. Drill reaches all of it: everything your apps send, across all of them, down to a single person. - Whatever your apps send Every event Sessions, screens, custom events, crashes, push, surveys and journeys Nothing is reserved for a separate report. A crash, a purchase and a survey answer sit in the same query, each with every property it was sent with and the profile it came from. - Across platforms All your apps One query over several projects at once Pick more than one project as the source, and iOS, Android and web answer the same question side by side, or split by project to see which one moved. - For every team 0 lines of SQL Pick what to count, how to split it and over what time Product, marketing and support ask their own questions instead of filing a ticket and waiting for the data team. The data team keeps its time for the questions that need it. - All the way down One person From a total to the people behind it A number is where a question starts, not where it ends. Open the profiles behind any count, see what one of them did, and save the group as a cohort to reach them. Works with ## Drill, with the rest of Countly Every feature reads the same live data, so an answer in Drill doesn’t stop there. These are the handoffs built in. [All features](https://countly.com/platform/features) Profiles Open the profiles behind any count in a panel. From a profile, open everything that person did in Drill. Open [(Profiles Open the profiles behind any count in a panel. From a profile, open ev](https://countly.com/feature/profiles) Cohorts Save the people behind a number as a cohort in one click, or open what a cohort’s members actually do. Open [(Cohorts Save the people behind a number as a cohort in one click, or open what ](https://countly.com/feature/cohorts) Dashboards Add any result to a dashboard as a chart or a table, straight from its menu. Open [(Dashboards Add any result to a dashboard as a chart or a table, straight from i](https://countly.com/feature/dashboards) AI Agent Cee Ask in plain language and Cee builds the query. Or hand Cee a result to summarize or investigate. Open [(AI Agent Cee Ask in plain language and Cee builds the query. Or hand Cee a resu](https://countly.com/feature/ai-agent-cee) Views Continue in Drill from Views, Sessions or Events, with the selection you were looking at. Open [(Views Continue in Drill from Views, Sessions or Events, with the selection you ](https://countly.com/feature/views) AI Analytics Every prompt your AI features send is an event, so Drill can break AI use down like anything else. Open [(AI Analytics Every prompt your AI features send is an event, so Drill can break](https://countly.com/feature/ai-analytics) MCP Server Your team’s AI assistants run Drill queries and saved queries, within each person’s projects. Open [(MCP Server Your team’s AI assistants run Drill queries and saved queries, withi](https://countly.com/feature/mcp) Activity Map The Activity Map counts the same raw events as Drill, with the same filters, on a map. Open [(Activity Map The Activity Map counts the same raw events as Drill, with the sam](https://countly.com/feature/activity-map) Data ownership ## The most detailed data you hold, in an environment that’s yours Drill reads raw events with every property attached, the most detailed record you hold of how people use your product. Where that record lives decides who else can read it. [Data privacy](https://countly.com/platform/data-privacy) ### Self-hosted, or dedicated Run Countly in your own cloud, your data center or an air-gapped network. Or let us run a single-tenant instance in the Google Cloud region you choose. ### Nothing to export Queries run where the events are stored. No copy to a third-party warehouse to answer a question. ### No default vendor access On Enterprise, Countly has no access unless you grant it. On Flex, access is limited, granted by you and logged. ISO 27001 Certified ISO 27017 Certified ISO 27018 Certified SOC 2 Type II examined TISAX® Participant* *Countly Ltd. is a TISAX® Participant. TISAX® is a registered trademark of and governed by ENX Association. Learn more at [enx.com/tisax](https://enx.com/tisax)