Countly Documentation

Countly Resources

Here you'll find comprehensive guides to help you start working with Countly as quickly as possible.

也有简体中文版文档.

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)

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!

Drill (Advanced segmentation)