Examples of search filters

Sendinblue lets you segment your database by specific sociodemographic criteria (e.g., gender, city) or behavioral criteria (openers, clickers, etc.).

mceclip10.png

Filter contacts by attributes

You can apply a filter to select your contacts by attributes. The filter will give you contacts with an attribute that matches or is different to the one you selected for your attribute field, or that has a calculated field that is higher, lower, or equal to the amount you entered.

In this example, a filter has been applied to produce a list of French-speaking contacts.

mceclip2.png

And here, a list of customers that have been added after a specific date.

mceclip3.png

Filter contacts by behavior

You can also apply a filter to select contacts by their behavior towards your email campaigns.

Contacts who have opened your email campaigns

Produce a list of openers (readers), i.e., contacts who have opened your email campaigns. Your search can relate to a specific campaign or all your email campaigns. Similarly, the time range of the search can be limited by a start and end date, or unlimited.

In this example, a filter has been applied to select contacts that opened all campaign emails in the last two weeks.

mceclip5.png

Contacts who have clicked a link in your email campaigns

Produce a list of clickers, i.e., contacts who opened your email and clicked on one of the links.

In this example, we want a list of the contacts that clicked on a campaign at least once in 2020.

mceclip6.png

Contacts whose email address resulted in a hard bounce

Produce a list of hard bounces, i.e., contacts whose email address does not exist and resulted in a hard bounce.

In this example, the search filter is displaying hard bounce contacts from the last 10 days for all campaigns.

2021-09-08_10-36-07.png

Note that the list only contains blacklisted customers. In fact, with Sendinblue, if a customer's email address hard bounces once in any campaign, that customer is blacklisted and receives no further email campaigns.

Contacts who have been blacklisted

Produce a list of blacklisted contacts, i.e., contacts who have been blacklisted because they have marked your email as spam (complaint), or unsubscribed from your campaigns (unsubscription), or you have unsubscribed them manually (admin unsubscription), or they have hard bounced. You can apply a search filter to find customers that have been blacklisted for any of the above reasons.

In this example, we want the list of customers who have been blacklisted because they unsubscribed in 2021.

2021-09-08_10-38-18.png

Cross-reference search filters

You can refine and expand your search by cross-referencing the different filters.

AND condition

Refine your search by adding the condition AND.

mceclip7.png

In this example, we have produced a list of customers who opened a campaign in the last 100 days and also clickers in the last 100 days.

mceclip8.png

OR condition

Expand your search by adding the condition OR.

2021-09-08_10-49-13.png

In this example, we have produced a list of customers who are blacklisted because they marked your campaign emails as spam or because they unsubscribed from your newsletters.

mceclip9.png

You now have all the tools you need to filter your contacts effectively!