Skip to main content

Hi everyone,

I’m looking for some guidance on a workflow challenge I’m facing.

The goal is to pull contacts who have clicked a specific link in a Mailchimp campaign into a HubSpot list and also capture the exact URL they clicked.

Zapier support has confirmed that:

  • The Campaign Report action in Mailchimp can provide the total number of clicks but not the contact details.

  • The Link Clicked trigger can provide contact-level click data, but given the volume we’re dealing with (2,000–10,000 clicks per campaign), it’s not cost-feasible on our current Zapier plan. We send about 3 campaigns per week.

I’ve already tried the webhook route, but unfortunately, Mailchimp’s webhooks don’t send click-level data.

Has anyone in the community found a creative workaround or alternative method to achieve this ideally without significantly increasing operational costs?

Open to suggestions involving custom scripts, API usage, or other automation tools that could bridge this gap.

Thanks in advance for any insights you can share.

Best regards,
Ari

Hi ​@Hype User, welcome to the Community! 🎉

Looks like Mailchimp’s API has a List clicked link subscribers endpoint that would work for what you’re after:

dd0183fa6a98c4db379d81c314f97e11.png
 

I’d suggest using either a Custom action or API Request action to make a request to that List clicked link subscribers API endpoint to see if that gets the information you’re after. That action should only use 1 task when it’s run so shouldn’t be too heavy on your task usage like the Link Clicked trigger would have been.

Let me know how you get on with that approach, happy to lend a hand if you get stuck at all 🙂


Reply