Exploring Cohorts

How to get the required insights from Cohorts?

When we select the required entity, the Cohort is created!

You can create detailed cohorts of your business entities using lookup consoles. Let's take a look at the various actions that can be taken here.

How can I change the service area or the city in Cohorts?

You can change the location of the cohort by clicking on the map icon at the top and selecting the desired location.

How can I change the time period for Cohorts?

In order to change the time period for cohorts, click on the calendar icon on the top left.

Once the window opens, the users can either:

Enter custom time periods (For example, Jan 16, 2020, to Jan 23, 2020)
Choose "Today", "Last 2 days", "Last 60 days" and so on.

How do I add more columns to Cohorts?

In order to add more columns to Cohorts, click on the "Add columns" option in the top right corner.

The users can add two types of columns to the entity consoles:

Entity Property

This allows users to add entity properties to the table. These could be the user id, amount, revenue, and so on.

Entity Metrics

This allows the users to create metrics to calculate the data of their entity. For example, if you want to understand average revenue per user, time taken for each trip by the user, orders of the users and so on.

How to add an entity property column on Cohorts?

In the top left corner, click the Add Column button.
Select the Entity Property option from the drop-down menu.
Select the desired properties. For example, user_id, user age, revenue and so on.
Click the Apply button.

How to add an entity metric column on Cohorts?

One of the most powerful aspects of Entity Consoles is the ability to create cross-entity metrics without having to worry about joins or writing a single line of SQL. Instead of joining tables across databases.

Locale's Entity Consoles assist you in gaining meaningful insights by creating cross entity metrics such as Orders per rider, Revenue per vehicle, Profit per User, and much more!

In the top left corner, click the Add Column button.
Select the Entity Metric option from the drop-down menu.
Select the desired metric type you want to create
Fill in the required fields and add the filters
Click the Apply button.

What are the various types of entity metric columns that can be added to the Cohorts?

The users can add three different types of metrics on the entity metric column console.

Entity Property Metric

This metric allows you to add entity properties (e.g.- user id, amount, average revenue per user) to the table.

For example, What is the count of the total km driven by the bike

Can I apply filters to different columns in Cohorts?

Yes, the users can dissect the lookup table with powerful filters on top of columns and drill down to entities with specific properties, metric values, or thresholds. You can then save these filters to represent user behaviours, vehicle properties or almost anything based on the properties or metrics as cohorts!

First click on the entity filters option
Next, click on add filter
Choose the column you want to add a filter for and set the values accordingly.

For example: user_age > 30, order_amount < $50, idle_time <40 hours and so on

Click on apply to complete the process.

How do I sort the columns in the entity console?

The entity console's columns can be sorted in either descending or ascending order. Select the Sort option from the drop-down menu after clicking on the column you want to sort.