Drill (Advanced segmentation)


Countly Drill is advanced segmentation feature, available with Enterprise Edition. Drill can be very powerful when it comes to understanding segmented data.

Before giving specific examples, it’s important to understand how Drill works. Here is a Drill screen.

  1. Here you select data type you are going to segment: either session, event or errors. Your selection of different data types will affect overall graph.
  2. You can define granularity (monthly/weekly/hourly/daily, depending on the selected time), or change what graph shows (e.g visitors, times or times/visitors).
  3. Here’s the part where you can select a filter based on User Properties (e.g First Seen, City, Device, Platform, Name), Custom Properties (e.g Facebook Login, Twitter name, Has Apple Watch OS etc), Campaign Properties (e.g Campaign Name).
  4. You can view the table that corresponds to the graph here.
  5. You can set a bookmark and then reach your previous historical bookmarks here.

Now, on (1), when you select Sessions, Events, or Errors, then you’ll see that Select a Filter part in (3) will change. All changes are depicted below:

When you select “Sessions”, you’ll see:

  • User Properties (e.g First Seen, City, Device, Platform, Name)
  • Custom Properties if set (e.g Facebook Login, Twitter name, Has Apple Watch OS etc)
  • Campaign Properties (e.g Campaign Name)

When you select “Events” and then an event name, you’ll see:

  • Event Segments (e.g Level, Mode, Difficulty)
  • Event Properties (e.g Sum, Duration)
  • Plus everything you see when you select “Sessions” (see list above)

When you select “Crashes”, you’ll see

  • Error Segments (e.g Manufacturer, CPU, Fatal/non-fatal, current RAM, total disk etc)
  • Plus everything you see when you select “Sessions” (see list above)

Query input types

In drill, when you click on a drop down menu as you segment your data, there are different input types, based on what kind of data has been collected in the specified property:

  • Incoming data can be number. In this case, input can be any arbitrary number.
  • Incoming data can be date. In this case, input would be calendar time.
  • Incoming data can be string. In this case, input would be a dropdown with all provided values up to a limit (defined in configuration). By default it is 100 entries.If this limit is reached, then depending on configuration, it either switches to plain arbitrary input string, or a searchable list.

Note that if you have only dropdown with selectable values (e.g without any option to insert arbitrary values), it means that this property have not yet reached the limit of unique values and all those unique values are listed in the dropdown.

<, >, = and similar operators are available for comparing only dates and numbers, and not strings.

Drill by examples

Before we start to get more into how to drill down data, we need to make sure you understand all about Countly custom events (which has been around for more than a year) since Countly Drill is all about custom events.

In the custom event system Countly lets you keep track of your own metrics in a pretty simple way by sending event data like this;

		"key": "Ride",
		"count": 1,
		"sum": 15.99,
    "duration": 500,
		"segmentation": {
			"Car Type": "Luxury",
			"Time of Day": "15:00",
			"Coupon Used": "CLYROCKS"

Here we are tracking Ride event for our made up app that has segmentation properties called Car Type, Time of Day, and Coupon Used which lets us keep track of various occurrences of the same event. We use the sum property to store the amount paid for the ride.

We normally get a report that looks like below for our Ride event. Which is a great way to see a high level overview of how things are going and performing single level segmentations on our data.

Using Countly Drill we will be able to;

  • Perform advanced segmentations on our data by applying AND, OR and BY filters to our segmentation properties as well as user properties such as Device, App Version, Platform, Platform Version, Session Count, Session Duration, First Session, Last Session, Country, City and Carrier
  • View data on a line, pie or bar chart, whichever makes more sense for the current data
  • Change the time bucket displayed on the chart and table to hourly, daily, weekly or monthly
  • View how many times the event occurred as well as how many users performed this event and an average (times/users)

Without further due we want to show you some of these highlights using real reports for our custom event Ride;

  1. Show Ride events with "Car Type": "Luxury"
  1. Show Ride events with "Car Type": "Luxury" that has a Duration higher than 600 (seconds) and show the report segmented by Coupon. And please show this on a pie chart
  1. Show Ride events with "Car Type": "Luxury" or "Car Type": "Basic" that has a "Coupon Used": "CLYROCKS" and show the report segmented by Country
  1. This is all great but will I define these filters every time I need to see a report? No - we have bookmarks for that. Just add to a bookmark, and then reach all bookmarks at once and run previously saved queries again.

Session drill

Session Drill is an extension to popular Countly Drill which provides the same awesomeness for your session data. You don't need to do anything extra to take advantage of Session Drill.

Every view under analytics menu now has a Drill button as shown below which takes you to Drill view and applies the related filter for you.

For this particular case when you click the Drill button under Devices view, you will automatically be navigated to Drill with a BY filter on Device. You can continue to drill down this data by applying more filters.

Currently you can apply any combination of AND, OR, BY filters to below user properties;

  • App Version
  • Carrier
  • Country
  • City
  • First Session
  • Last Payment (available only if Revenue Analytics is active)
  • Last Session
  • Platform
  • Platform Version
  • Resolution
  • Session Count
  • Total Session Duration

Here is another example that shows session data for our app versions 3.2 and 2.0 segmented by platform.

We could have added thousand more items to this list but we believe you are ready to see it for yourself at this point :) Go on and sign up for a free Countly Enterprise Edition account and experience the magic!

Was this article helpful?
0 out of 0 found this helpful

Looking for help?