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