# Mailchimp Reverse Integration Data

**URL:** <https://community.hubspot.com/t/mailchimp-reverse-integration-data/129161>\
**Category:** Marketplace Apps\
**Tags:** third-party-apps\
**Created:** [April 3, 2025, 12:26am UTC](https://community.hubspot.com/t/mailchimp-reverse-integration-data/129161 "2025-04-03T00:26:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aaron\_C](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@Aaron\_C](https://community.hubspot.com/u/Aaron_C)\
**Post date:** [April 3, 2025, 12:26am UTC](https://community.hubspot.com/t/mailchimp-reverse-integration-data/129161/1 "2025-04-03T00:26:18Z")

</div>

![Picture2.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/e/be711533240f3f562592bdcc984329e12f842cd5.png)

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

---

<div class="post-metadata">

**Author:** ![DianaGomez](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/dianagomez/32/48035_2.png) [@DianaGomez](https://community.hubspot.com/u/DianaGomez)\
**Post date:** [April 3, 2025, 12:30pm UTC](https://community.hubspot.com/t/mailchimp-reverse-integration-data/129161/2 "2025-04-03T12:30:59Z")

</div>

Hi, [@Aaron\_C](https://community.hubspot.com/t5/user/viewprofilepage/user-id/924370),

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**](https://community.hubspot.com/t5/user/viewprofilepage/user-id/140059) , **@trevordjones** - Could you share your perspective on how you would address this situation?

Thanks for taking a look!

Diana

---

<div class="post-metadata">

**Author:** ![trevordjones](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/trevordjones/32/35637_2.png) [@trevordjones](https://community.hubspot.com/u/trevordjones)\
**Post date:** [April 3, 2025, 5:28pm UTC](https://community.hubspot.com/t/mailchimp-reverse-integration-data/129161/3 "2025-04-03T17:28:47Z")

</div>

Hello, [@Aaron\_C](https://community.hubspot.com/t5/user/viewprofilepage/user-id/924370) andf thanks for the tag @DianaGomez !

You need to build your filter like this:

 ![2025-04-03 - 13_26_42 - Unnamed list 4_3_2025 1_23_43 PM _ Lists.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/a/e/ae7d8c96a6d9fe2962337f04ab75a6aa24d583bf.png)

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!