如何从Mailchimp营销活动获取Workflow ID及邮件追踪信息

Got it, let's break this down. In Mailchimp, your scheduled drip mails are part of Automations (formerly known as Workflows), so you'll need to use Automation-specific tools to pull all the details you're after: Workflow ID, customer email, send time, status, and which exact drip mail was sent. Here are two reliable approaches:

Option 1: Pull Historical/On-Demand Data via the Mailchimp API #

This works great if you need to fetch past activity or run periodic reports.

Step 1: Map Workflow IDs to Drip Mails First #

First, get a list of all your Automations to link each Workflow ID with its individual drip mails. Use the List Automations endpoint:

curl --request GET \
  --url 'https://<dc>.api.mailchimp.com/3.0/automations' \
  --user 'anystring:<your-api-key>'

In the response, each automation entry has an emails array—this lists every drip mail in the workflow, with its own id (email ID) and title (the name you gave the drip mail). The parent automation's id is your Workflow ID.

Step 2: Fetch Recipient Activity for Each Drip Mail #

For each drip mail (using the Workflow ID and Email ID from Step 1), use the Get Automation Email Activity endpoint to pull recipient-specific data:

curl --request GET \
  --url 'https://<dc>.api.mailchimp.com/3.0/automations/<workflow_id>/emails/<email_id>/activity' \
  --user 'anystring:<your-api-key>'

The members array in the response will give you exactly what you need:

• email_address: The customer's email
• timestamp: When the email was sent
• status: Delivery status (like sent, bounced, opened)
• You already have the Workflow ID and drip mail name/ID from Step 1 to map this back to the correct campaign.

Step 3: (Optional) Get Scheduled (Unsent) Drip Mails #

If you need to see recipients who are queued to get a drip mail but haven't received it yet, use the Get Automation Email Queue endpoint:

curl --request GET \
  --url 'https://<dc>.api.mailchimp.com/3.0/automations/<workflow_id>/emails/<email_id>/queue' \
  --user 'anystring:<your-api-key>'

This returns scheduled send times and recipient emails for upcoming drip mail sends.

Option 2: Real-Time Updates with Automation Webhooks #

If you want instant notifications when a drip mail is sent (or has a status change), set up an Automation Webhook:

1. In your Mailchimp account, go to Automations > [Your Workflow] > Settings > Webhooks
2. Add your endpoint URL and select the events you want to track (e.g., "Email sent", "Email opened")

When an event triggers, Mailchimp will send a payload to your endpoint with all the details:

• workflow_id: The ID of the automation workflow
• email_id: The ID of the drip mail that was sent
• email_address: The customer's email
• timestamp: Exact send time
• status: The delivery status (like sent)

You can use the List Automations endpoint from Step 1 to map the IDs back to the actual workflow and drip mail names.

Why Your Previous Tries Didn't Work #

• The Sent-To Reports endpoint is designed for regular one-time campaigns, not Automations. Automations have separate endpoints because they're triggered by user actions or schedules, not bulk sends.
• Regular Campaign webhooks only track events for standard campaigns—they don't capture Automation-specific data like Workflow IDs. You need to use Automation-specific webhooks instead.

内容的提问来源于stack exchange，提问作者DotNetUser