How do I create an Advanced Segmentation Rule that will pull Active contacts subscribed on today's date in previous years?
Use the "now" operator in conjunction with day and month to pull contacts who were added to this List on the same month and day as today. To make sure you are not pulling contacts added today (this year), use < (less than) with now.year.
To pull Active contacts, add a condition that targets contacts with an open within the last six months.
- Go to LISTS > SEGMENTATION > CREATE ADVANCED RULE.
- Enter a Rule Name and Description.
- In the Commands textbox, enter the following, then click CREATE:
(subscribed_date.day = now.day
and subscribed_date.month = now.month
and subscribed_date.year < now.year)
and (tracking_opened exists
and tracking_event_date < (now - 6m))
Note that this is not an "open" for a particular List. Advanced Segmentation Rules will not target tracking events from a particular List.