How to get mailchimp email data from HubSpot API

[jing]

I can see Mailchimp email Open, Sent events in HubSpot. How can I get this data from HubSpot API?

[GRajput · Accepted solution]

Hi @jing 

"You can use Marketing - Marketing emails - statistics. using the email name you can fetch the data, you can plat with the other parameters provided to get data as per your requirement.
link - https://developers.hubspot.com/docs/api-reference/marketing-marketing-emails-v3/statistics/get-marke...

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.

Thanks!

Moderator note: While this solution may not address the original poster’s specific situation, it could be helpful for other community members facing similar challenges.

[RubenBurdin]

Hi @jing  good question, this is one of those cases where what you see in the activity tab and what you can reach via API don’t always line up nicely.

HubSpot can only return what exists as native CRM data: properties on the contact, or timeline activities stored as email engagements or custom timeline events. If those Mailchimp opens/sends are being written as standard email engagements, you should be able to find them with the email engagements API by querying /crm/v3/objects/emails and filtering on associations to the contact rather than via /crm/v3/objects/contacts alone (https://developers.hubspot.com/docs/api-reference/crm-emails-v3/guide )

If instead they are coming from an app that logs custom timeline events, the only way to reach them is via that app’s event type through the timeline events API. In both cases, the key is that the event must exist as a real engagement or event object, not just a visual embed. One quick check is to click into an activity in the UI and see if it opens as a HubSpot email engagement with an ID, or stays as an opaque integration card.

If you confirm that those Mailchimp activities are only rendered in the UI and not stored as objects, there unfortunately is no HubSpot API path to export them, and you would need Mailchimp’s side or a middleware layer to expose that data. When teams run into this limitation often, Stacksync helps by syncing normalized email events from tools like Mailchimp and HubSpot into a shared database in real time so reporting does not depend on what each UI chooses to expose.

[GRajput · Accepted solution]

Hi @jing 

"You can use Marketing - Marketing emails - statistics. using the email name you can fetch the data, you can plat with the other parameters provided to get data as per your requirement.
link - https://developers.hubspot.com/docs/api-reference/marketing-marketing-emails-v3/statistics/get-marke...

I hope this will help you out. Please mark it as Solution Accepted and upvote to help another Community member.

Thanks!

Moderator note: While this solution may not address the original poster’s specific situation, it could be helpful for other community members facing similar challenges.

[TomM2]

Hey @jing where do you see them? If they're on contact properties you could pull them through the contacts api. Realistically though the info is coming from mailchimp, is there any reason you can't pull these from mailchimp apis? 

[jing]

The mailchimp emails activities are shown in activity tab in HubSpot. I am pulling data for my client. I can not get these events from contact object through Hubspot api /crm/v3/objects/contacts. And We don't have integration with Mailchimp, Mailchimp also doesn't support retrieving email events from their API.

[TomM2 · Accepted solution]

Thanks @jing they would have to support retreiving events from their api for HubSpot to get them. Looks like they have documentation for email activity here:

https://mailchimp.com/developer/marketing/api/eepurl-reports/#:~:text=REPORTS-,Email%20Activity,-Get...

You could also try timeline events api:

https://developers.hubspot.com/docs/api-reference/crm-timeline-v3/guide