The Drill Agent is your conversational interface to Countly’s Drill feature. Drill allows you to perform advanced, granular analysis on your raw event data with filters, groupings, and aggregations. It can answer questions like “how many users did X and Y” or “what are the top values of property Z for events of type Y”, etc. Normally, you’d use the Drill UI to set up filters and charts step by step. With Cee, you can simply ask your question in plain language, and the Drill Agent will construct the query for you.
- Automatic Query Construction: Under the hood, the Drill Agent will use the metadata of your events and user properties to build the query. It will identify the event name, the segmentation or property to group by, any filters if applicable.
-
Executing the Query: Once Cee sets up the query, you will see the Drill interface populated with the chosen event and filters. The result will be displayed as usual (perhaps as a chart or table in the UI, depending on what you’re measuring). Keep in mind that Drill queries can take a moment if a lot of data is being processed, but Cee will indicate if it’s waiting for results.
- Complex Queries and Clarifications: If the Drill Agent isn’t sure about something you asked, it will ask clarifying questions. Similarly, if you use a term that doesn’t match any event or property, Cee will let you know and perhaps suggest the closest match or ask you to rephrase.
- Viewing the Query Definition: Just like with cohorts and funnels, an advanced user can click the “JSON”/details button after a Drill query is built to see the raw query steps (in MongoDB aggregation format, which is what Countly uses under the hood for Drill).