Segment in order to Include contacts for journeys: email delivered at least 6 times in the last 12 months and also email opened at least once in 6 months. Group 2: or email delivered less than 6 times in the last 6 months or no emails delivered.
In Dynamics 365 Marketing, building segments for audience hygiene and inactive email engagement can be challenging due to the limited filtering operators in the segment builder. However, there are a few strategies you can use to create segments that meet your criteria as closely as possible. Let’s go over each scenario and some workarounds.
Goal: Identify contacts who received at least 6 emails in the last 12 months but did not open any of them.
Unfortunately, Dynamics 365’s segment builder does not support a "not opened" or "0 times" condition directly. Here’s a workaround:
Workaround:
Email > Delivered > At least 6 times in the last 12 months
.Email > Opened > At least 1 time in the last 12 months
.This combined segment will give you the contacts who received at least 6 emails but did not open any in the last 12 months. You can then use this combined segment to exclude these contacts from your journey.
Goal: Include contacts who:
Workaround:
Email > Delivered > At least 6 times in the last 12 months
.Email > Opened > At least 1 time in the last 6 months
.Email > Delivered > Fewer than 6 times in the last 6 months
or Email > Delivered > Exactly 0 times
.This combined segment will include contacts who are either engaged (received at least 6 emails and opened one recently) or have not been overly contacted (received fewer than 6 emails in the last 6 months or none at all). You can use this segment to target active or less-targeted contacts in your journey.
To identify inactive contacts for ongoing email hygiene and potential re-engagement or removal, you can create a segment specifically for contacts who meet a variety of inactivity criteria. Here are a few options:
Option A: Contacts who have not opened or clicked any email in the last 12 months.
Email > Opened > Exactly 0 times in the last 12 months
and Email > Clicked > Exactly 0 times in the last 12 months
.Option B: Contacts who have not opened or clicked any email in the last 6 months but were delivered at least 6 emails.
Email > Opened > Exactly 0 times in the last 6 months
.Email > Clicked > Exactly 0 times in the last 6 months
.Email > Delivered > At least 6 times in the last 6 months
.Option C: Contacts who have been delivered a high number of emails with minimal engagement (e.g., less than 1% open rate).
If you have Dynamics 365 Customer Insights integrated with Marketing, you can use Customer Insights to create more complex segments based on custom conditions. Customer Insights offers more flexibility for defining engagement metrics and can create calculated attributes, such as open rates or advanced engagement scores.
You can then sync these segments back to Dynamics 365 Marketing and use them to target or exclude contacts in real-time journeys.
If real-time updates aren’t critical, you could periodically run an automated workflow or batch job to identify and update these inactive contacts into a marketing list based on your engagement criteria. This approach is more manual but can serve as a workaround until the segmentation capabilities in Dynamics 365 improve.
While Dynamics 365 Marketing’s segment builder doesn’t currently support advanced conditions like "not opened" or complex engagement rates, using combined segments and Customer Insights can help you achieve similar results. For real-time journeys, create combined segments that approximate your criteria as closely as possible by including and excluding specific engagement behaviors.
If you need further customization, consider creating calculated fields in Customer Insights or automating marketing lists to periodically update based on engagement history.
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156