To create a one-time or recurring campaign, you need to create a cohort as first step.
A Cohort is a collection or a segment of users created on a set of filters or a database query. This allows you to segment users based on any criteria and send targeted messages to them.
A few examples of filters include filtering by specific status, location, or sign-up date range. There are countless other possibilities that you can explore by using different combinations of filters or writing your own query.
Let’s have a look at how to create a cohort.
Filters and Query allow you to get the segment of users for certain conditions or factors.
A powerful visual builder using which you can apply a set of filters to the schema data to get the desired output. This builder consists of the following major components:
It is the most important component as it consists of the single condition or the filter that needs to be applied.
A rule is created by combining 3 things:
The “Key” is the column name or the object key from your schema. It is present as a dropdown menu with a list of column names or object keys from your schema.
The “Operator” is the operation or check that is to be performed between the key and the value. It is present as a dropdown menu with a pre-defined list of operators.
The “Value” is the data value that you input. The data type of this field will depend on the “Key” selected and will change as you change the selected “Key”.
Example of a rule:
Use the highlighted icon to instantly see all unique values in your selected column. This automatic detection saves time, especially when working with large datasets, by showing you all possible filter values in a convenient dropdown menu.
A group is a collection of rules that can be used to organize filters and create complex filters by combining multiple groups with different combinators.
Determine how 2 rules or groups will combine together in order to form a complete condition or a filter. It can have 2 values:
A simple code editor to write or paste your db queries and run it directly on the schema data to get the desired output. This editor gives you more freedom as you can write as complex a query as you can and also helps you reuse what you have already written someplace else.
It’s essential to use the appropriate query when working with different databases. For instance, MongoDB requires a JSON-formatted Aggregation Pipeline query which looks like this:
The Magic Query Generator is an innovative and powerful feature designed to simplify and streamline the process of creating database queries. With this, generating database queries is as simple as providing a prompt in plain English.
By eliminating the need to write queries manually, the Magic Query Generator empowers you to retrieve, filter, and manipulate data from the database with ease and efficiency.
Just write out what exactly you want the data to be comprised of with all the conditions, and hit the “Generate Query” button. The query will auto run after successfull generation and you can view the results.
Modify the query or the prompt until you get the desired output.
Give it a try!
To download cohort data, go to cohorts page and click ellipsis present at the end of each cohort. You will see the below options.
Click Download CSV option to download the cohort data.
