I am creating an age segmentation with 11 age buckets using date of birth as the smart list field. I wrote it out based on between dates, but that will need to be updated every year. Is there a way to get it to automatically put people in the correct bucket? What exactly would it look like? The pic is attached.
Thanks for your help.
As the birth date will never get updated, the segments will not recompute. So try these in smart lists and update a field. Then you will be able to create the segments based on this field.
Yes, you are right. You will need a first "Under 18" segment to capture the very first group.
But again, I think the segment will not recompute as the date of birth will never change, so I would use a intermediary field.
I believe someone else has solved this on the forum.
I think this would work better as smart lists and batches and to re-run this once a year.
Once a year is probably not enough. If I am born on April 8th and you compute it today, (April 7th), I'll appear 1 year younger for almost a year
Marketo has a bug with the way dates are used in segments. They call it "not supported" but it's really a feature they should have.
Basically, if you use In the Past or In timeframe constraints, the segment doesn't work. I learned the hard way after creating an Activity Timeframe segment using a last activity timestamp. After testing, I noticed people were't switching segments properly.
See more info: https://nation.marketo.com/message/22851