With the improved segments feature, user will be able to create audiance segments a lot easier and quicker than before. The segment filters are more like a sentence now that can be easily read and understood.
On Dengage platform we have two types of options when we want to create segments.
- Interactive.
- SQL mode.
SQL Query
In the SQL Query mode, you are able to create segments by adding SQL queries.
First of all, let’s insert the name of the segment, the description, and where this segment will be saved.
Now enter the valid “SQL query” under "Write Custom SQL Query”
Hit the “validate and Preview” button
![](//img.zohostatic.com/zde/static/images/file.png)
Note: Results will be displayed if the query is valid. In case of an invalid query, errors will be displayed.
Now click the “calculate” option from “insights”. You can preview details by clicking the “Contacts” and “Anonymous Devices” button.
Interactive
In the Interactive mode, you are able to create segments without knowledge of SQL queries.
First of all, You have to insert the name of the segment, the description, and where this segment will be saved.
Now, in order to get your contacts, you have some options.
![](https://lh4.googleusercontent.com/4fs2QICKh28myfAexdnjEJXOxvhVkhjA3M4ISsNnfyf0dWu_IeGDNA39P9q80SWJteVVZNYaaSxOirEMW4SKmUu5jHa1UH6z8urh058iXRkFqtg7NsMGlXQWZYGMRjMygg2N-0MI)
As you can see, when we click on “add filter” the platform shows us a lot of options of user data.
So, let’s take an example here. Let’s suppose You want to get people that device type equals to Phone AND is reachable via email.
Here as we can see, we have two filters complementing each other, the first filter will search for phone devices and the second one will search users that are reachable via email channel.
On the left side of the filters, we can see a button where is wiriten “AND”. This means, search for me, everybody who has mobile devices AND is reachable via email channel. So the platform searches people that are inside these two filters at the same time.
But if you change to “OR” the platform will search people that are at least inside one filter.
You can also create groups
In this example, we can see two groups, the first one is searching everybody who has mobile devices AND is reachable via email channel.
The second one is searching for people that have opened at least one email campaign within the last 30 days.
What will happen in this case? Basically the platform will get the result of the two groups, because we have the “OR” on the left side.
You can also exclude some kinds of contacts using the exclusion filter.
When you click on calculate, the platform will show you how many contacts are inside this segment.
What kind of data can I insert on the segment?
- User Data
- User Type
- Contact Fields
- Device Fields
- Reachability
- List Tag
- Key Value Tag
- Behavior
- User event
- User events aggregated
- Campaign audience
- Email Campaigns
- SMS Campaigns
- Push Campaigns
- In-App Campaigns
- On-site Campaigns
- Existing Segments
- Segments
- Remote segments
- Relational DB
- Table Filter
- Sendlist table