Mailchimp Reverse Integration Data

[Aaron_C]

I used reverse integration here to get this data because Mailchimp doesnt have segmentation criteria to capture this without manual re-runs.
I created an active list (as shown in the screenshot) based on Mailchimp-HubSpot reverse integration data, assuming it would capture contacts who opened any Mailchimp email between 3 to 6 months ago. However, I’ve realised that the logic doesn’t work as expected.

Currently, the list includes:

• Anyone who has opened an email in the last 182 days (≈6 months).
• Anyone who has opened an email more than 89 days ago (≈3 months).

This means that if Profile A opened an email on January 1st, 2024 (more than 182 days ago) and then opened another on March 3rd, 2025, they would still be included in the list—despite not meeting my intended criteria.

What I actually need:
I want to capture only those who have opened an email between 3 and 6 months ago from today’s date (April 3rd, 2025)—meaning only those who engaged between October 2024 and December 2024.

Issues & Challenges:

• Mailchimp’s advanced segmentation doesn’t support this dynamically—it requires manual re-runs, which I want to avoid.
• HubSpot support didn’t provide an alternative solution.

Looking for any suggestions or solutions to achieve this automation. Appreciate the help!

Thanks,
Aaron

[DianaGomez]

Hi, @Aaron_C,

Thanks for reaching out to the Community!

I would like to invite some members of our community who may offer valuable insights.— hey @OPerek-Clark, @andrus , @trevordjones - Could you share your perspective on how you would address this situation?

Thanks for taking a look!

Diana

[trevordjones]

Hello, @Aaron_C andf thanks for the tag @DianaGomez !

You need to build your filter like this:

Your build looks at one open less than 182 days ago and one open more than 89 days ago (two opens).

This one looks at a single open that is both more than 89 days ago and less than 182 days ago.

Hope this helps!