MailChimp lists, triggers and automation

1 replies
I currently collect birthday data, I want people to receive relevant mailings to the age of their child. So I need MailChimp to translate a birth date (18/01/2017) to their age (1-year-old), then filter that recipient into a particular position (1-2-year-olds) in a huge sequence of automated mailings.

I already have an annual automated mailing (1 month/ 1 week before their birthday) set up.

So I need to find a way to translate a date to an age. Then identify how a user would move from one 'List' to another.

I use tag process for the annual automated mailing mentioned above. This could work, however, the trigger appears to be limited to 999 days after the original date. I need the email trigger to be able to send more than that. For example, a parent receives tailored guidance about their child when they are over 1000 days old.

Also thinking I could segment my audience, but I need it to reflect today's date, rather than static dates. For example, today this user is 2, however, next week they are 3 and therefore will need to be automatically moved.

I've considered a Zapier/Google Sheets interaction. Currently, Zapier is inserting a new row, which annoyingly avoids the formula on sheet 2.

Help, please.
#automation #lists #mailchimp #triggers
Avatar of Unregistered
  • Profile picture of the author daniel27lt
    You could add an age form/field for when users sign up.

    I understand what you're trying to do. I was trying something like this but less complicated, and I personally messaged MailChimp, and it couldn't be done. So good luck.
    Signature
    Download Free PLR Products to give away to build your list. Find all the most up-to-date PLR on the market.
    {{ DiscussionBoard.errors[11297810].message }}

Trending Topics