How do I create an Advanced Segmentation Rule that will pull Active subscribers subscribed on today's date in previous years?
Use the "now" operator in conjunction with day and month to pull subscribers who were added to this List on the same month and day as today. To make sure you are not pulling subscribers added today (this year), use < (less than) with now.year.
To pull Active subscribers, add a condition that targets subscribers 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.