Datapipe
Lifecycle marketers
Track opens, clicks and list growth across every send.
Read & reportOwner-approved writes
See your Mailchimp numbers in Claude.
Review audience members, segments, tags and campaign activity. Teammates or AI can propose contact, tag, campaign and automation changes, and each one waits for owner approval.
- Campaign, list and subscriber results in one refreshing sheet
- Compare sends month over month without exporting
- Ask an AI assistant which emails worked, using live Mailchimp data
ClaudeUpdated November 2026
| Audience counts | Members | Segments |
|---|---|---|
| 1,240 | 1,240 | 1,240 |
| 640 | 640 | 640 |
| 210 | 210 | 210 |
- SetupSign in or paste a key
- Reads125 report fields across 12 datasets
- Changes10 owner-approved actions
- RefreshDaily to every 15 minutes
Who uses Datapipe with Mailchimp
Founders
See whether the newsletter is growing without logging in.
Agencies
Send each client a monthly email performance report.
What you can do with Mailchimp
Read and report
Read campaign performance plus eleven audience and campaign-detail reports.
- Mailchimp emails
- Audiences (lists)
- Audience members
- Audience segments
- and 8 more
Change with owner approval
- Update audience member name
- Update contact fields and groups
- Add or remove a contact tag
- Unsubscribe a contact or ask them to resubscribe
- Archive a contact
- Edit a draft campaign's subject, preview text, name or sender
- Schedule a draft campaign
- Unschedule a campaign
- Send a draft campaign now
- Pause or start a classic automation
The owner reviews the exact values and approves every proposed change before it is applied to Mailchimp.
Full read details
Explore current members, segment rules and membership, merge definitions and tags; inspect campaign links, recipients, activity and unsubscribes using explicit IDs. Audience state and cumulative campaign results follow their own date and permission limits.
Examples for your team
Review an audience and its fields
Choose an audience to inspect current member statuses, segment membership, merge definitions and one member's tags.
- Scheduled refresh
- Latest Mailchimp data
- Updated report
Limit: These reads do not change consent or subscription status.
Inspect a campaign's reported activity
Choose a campaign and compare link click totals with its recipient and activity reports.
- Scheduled refresh
- Latest Mailchimp data
- Updated report
Limit: Optional bot/MPP filtering applies to the recipient activity list; tracking data is not proof of a person's intent.
Prepare a campaign recap
Refresh campaign sends, opens and clicks for the reporting period.
- Scheduled refresh
- Latest Mailchimp data
- Updated report
Limit: Share the results with a client without repeating the manual export.
Tag recent buyers as customers
Your store report lists recent buyers.
- Proposed
- Owner approves
- Applied and logged
Limit: A teammate proposes the Customer tag for each contact, and the owner approves each one before Mailchimp updates its segments.
Fix things in Mailchimp without opening it
Spot it, fix it
See the problem in your report, then propose the fix in Datapipe instead of opening Mailchimp, finding the record and retyping it.
More people can help
Teammates and AI tools can suggest changes without getting edit access to Mailchimp.
Nothing changes without your yes
You see the current and proposed value side by side, and every change is logged.
Jobs you can stop doing by hand in Mailchimp
Update audience member name
Fix first names used in merge tags
TodaySearch the audience for members whose FNAME is "AVERY" or "avery" and retype each one in Mailchimp.
With DatapipeSort the members report by first name to find them. Propose the corrected name and approve each one. Email, tags and subscription status stay unchanged.
Split full names typed into FNAME
TodayOpen members where FNAME holds "Avery Chen" and LNAME is empty, then fix both fields by hand.
With DatapipeChatGPT reads the members report and proposes the split first and last names. You approve each member's exact change.
Exactly what this can change
Updates FNAME/LNAME on one existing audience member. Mailchimp automations may react. Email, subscription status, consent, tags and campaign sending are unchanged.
Supported fields: First name, Last name.
Update contact fields and groups
Fill in a missing company or city field
TodayOpen each contact whose COMPANY field is blank and type it in from your CRM.
With DatapipeChatGPT compares the members report with your CRM data source and proposes the missing values. You approve each contact's exact change.
Move a contact into the right interest group
TodayFind the contact, open their profile and tick a different group box.
With DatapipePropose the group change from the members report, for example adding a customer to Wholesale. You approve it before Mailchimp updates.
Exactly what this can change
Changes the merge fields and group memberships the owner selects for one existing contact in one audience. Mailchimp automations and segments may react. Email address, subscription status and consent are unchanged.
The owner selects supported writable fields for this action before teammates can propose changes.
Add or remove a contact tag
Tag customers who bought in the last month
TodayExport recent orders, find each buyer in Mailchimp and add a Customer tag by hand.
With DatapipeYour store report lists recent buyers. A teammate proposes the Customer tag for each, and you approve them one at a time.
Remove an old event tag after the event
TodaySearch for contacts tagged Webinar-Oct and untag them so the follow-up journey stops.
With DatapipePropose removing the tag from each contact in the report. Nothing changes in Mailchimp until you approve.
Exactly what this can change
Adds or removes one tag on an existing contact. Tags can start Mailchimp journeys or change segments. Email, fields and subscription status are unchanged.
Supported fields: Tag, Change.
Unsubscribe a contact or ask them to resubscribe
Honor an unsubscribe request sent by email
TodayRead the request, search for the address in Mailchimp and unsubscribe it manually.
With DatapipeA teammate proposes the unsubscribe for that contact, and you approve it. Mailchimp stops marketing email to them.
Invite a past subscriber to rejoin
TodayAsk the person to sign up again through your form and hope they find it.
With DatapipePropose Ask to resubscribe. Mailchimp emails them a confirmation link, and they stay unsubscribed until they click it.
Exactly what this can change
Changes one contact's subscription. Unsubscribe stops marketing email to them. Ask to resubscribe sends Mailchimp's confirmation email, and they stay unsubscribed until they confirm. Datapipe never marks someone subscribed without their confirmation.
Supported fields: Subscription.
Archive a contact
Archive contacts who stopped opening
TodayFilter for inactive contacts and archive them inside Mailchimp.
With DatapipeThe members report shows who has not opened in a year. Propose archiving each one, then approve them to keep your audience size down.
Archive test contacts before a launch
TodayHunt down test and demo addresses and archive each from the audience page.
With DatapipePropose archiving each test contact from the report. You approve before Mailchimp changes anything.
Exactly what this can change
Archives one contact. They stop counting toward your audience size and won't receive campaigns. Their history is kept and they can be added back later.
Supported fields: Archive.
Edit a draft campaign's subject, preview text, name or sender
Sharpen a draft's subject line
TodayOpen the draft, rewrite the subject and preview text, and save.
With DatapipeChatGPT reads last month's campaign results and proposes a new subject and preview text for the draft. You approve the exact wording.
Fix the sender name before sending
TodayNotice the From name still says the old brand and edit it in the campaign builder.
With DatapipePropose the right From name and reply-to address on the draft. You approve it, and nothing is sent.
Exactly what this can change
Changes settings on a draft campaign only. Nothing is sent. Recipients and content are unchanged.
Supported fields: Subject line, Preview text, Campaign name, From name, Reply-to email.
Schedule a draft campaign
Schedule a newsletter for Tuesday morning
TodayOpen the draft, pick a date and time, and confirm the schedule.
With DatapipePropose the send time for the draft. You approve it, and Mailchimp sends it then.
Line up a campaign while you're away
TodayLog in on Monday night to schedule the next day's email.
With DatapipeA teammate proposes the schedule ahead of time, and you approve it from your phone.
Exactly what this can change
Schedules a draft campaign to send to its audience at the chosen time, on the quarter hour. It sends automatically unless someone unschedules it first.
Supported fields: Send at (UTC).
Unschedule a campaign
Stop a campaign that has a mistake
TodayRush into Mailchimp to find the scheduled email and stop it.
With DatapipePropose Unschedule on that campaign. Once approved it goes back to draft and nothing is sent.
Move a send after a date change
TodayUnschedule the campaign so you can pick a new time later.
With DatapipePropose unscheduling it now, then schedule the new time in a separate proposal.
Exactly what this can change
Stops a scheduled campaign from sending and returns it to draft. Nothing is sent.
Supported fields: Change.
Send a draft campaign now
Send an approved draft right away
TodayOpen the draft, check it once more and click Send.
With DatapipeA teammate proposes sending the finished draft. You approve it, and Mailchimp sends it to the campaign's audience.
Send a time-sensitive announcement
TodayWait until someone with Mailchimp access is free to send it.
With DatapipePropose the send as soon as the draft is ready, and approve it wherever you are.
Exactly what this can change
Sends a draft campaign to its audience immediately. This can't be undone.
Supported fields: Send.
Pause or start a classic automation
Pause a welcome series during a site outage
TodayFind the classic automation and pause each email so new signups don't get broken links.
With DatapipePropose Pause all emails on the automation. You approve it, and Mailchimp holds every email in it.
Restart a seasonal automation
TodayTurn the holiday series back on email by email when the season starts.
With DatapipePropose Start all emails, read the notice, and approve when you're ready.
Exactly what this can change
Pauses or starts every email in one classic automation. Starting can send email to contacts already queued. Customer Journeys can't be changed through Mailchimp's API.
Supported fields: Automation.
Add or remove a contact tagContact · avery@northwind.example · proposed by Jordan Blake
| Field | Current value | Proposed value |
|---|---|---|
| Tags | Lead | Lead, Customer |
Every team member's change needs owner approval
- Owner turns on an action
- A teammate or AI tool proposes
- Check the current and proposed values, then approve that individual change
- Applied once and logged
Source changes use the separate Actions & approvals workflow in Datapipe. AI tools such as ChatGPT can propose changes but never approve them. Who can turn this on?
Provider rules and limits
Provider permissions still apply, and automations in Mailchimp may react to approved changes.
Only fields supported by an enabled action can be proposed; some actions also support individual owner-selected writable fields.
Before you connect
What you need
Connect Mailchimp from Data sources using the available sign-in or your account key.
Read and write
Read access for reports. The 10 change actions need edit access in Mailchimp and stay off until the owner turns them on.
Limits and exclusions
Audience data is current state; campaign details are cumulative provider results and are not filtered by report dates.
Full details and limits
Eleven new reports join campaign performance. Audience data is current state; campaign details are cumulative provider results and are not filtered by report dates. Opens and clicks can include automated activity. Recipient activity offers optional bot and Apple privacy filtering, retains recipients with no remaining actions and excludes IP addresses. Merge values stay JSON. Account permissions and history limits apply; deprecated contact totals and full modern Audience Contacts coverage are not claimed. These reads do not send campaigns or change consent. Optional name corrections remain separate: the owner enables the action and approves every proposed change.
Reports you can build
12 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Mailchimp emails
- Audiences (lists)
- Audience members
- Audience segments
- Segment members
- Merge field definitions
- Tags for a member
- Campaign link clicks
- Members who clicked a link
- Campaign recipients
- Campaign recipient activity
- Campaign unsubscribes
What each dataset reports
- Mailchimp emails
Sends, opens, and clicks.
- Audiences (lists)
Current legacy-list audience inventory and native subscribed, unsubscribed and cleaned counts. These counts are not a complete modern Audience Contacts total. The deprecated total_contacts field is excluded. Report dates do not reconstruct past audience state.
- Audience members
Current accessible data for one audience in the connected Mailchimp account. Report dates do not reconstruct past membership. Merge values and collections stay JSON; missing measurements remain null. Member ecommerce totals retain the provider's currency and are lifetime/provider totals, not revenue in the report dates. This endpoint does not certify archived contacts or all modern Audience Contacts are included.
- Audience segments
Current accessible data for one audience in the connected Mailchimp account. Report dates do not reconstruct past membership. Merge values and collections stay JSON; missing measurements remain null. Segment type, rules and membership counts are provider state. Counts request cleaned, transactional and unsubscribed members as well; no segment is created or recalculated by this read.
- Segment members
Current accessible data for one audience in the connected Mailchimp account. Report dates do not reconstruct past membership. Merge values and collections stay JSON; missing measurements remain null. Choose one existing segment. Cleaned, transactional and unsubscribed members are explicitly included when returned by the segment endpoint. Rules and account limits still affect membership.
- Merge field definitions
Current accessible data for one audience in the connected Mailchimp account. Report dates do not reconstruct past membership. Merge values and collections stay JSON; missing measurements remain null. Field types, choices, defaults, required/public flags and display ordering describe the audience schema. Private account definitions are only loaded into connected reports, not this public page.
- Tags for a member
Current accessible data for one audience in the connected Mailchimp account. Report dates do not reconstruct past membership. Merge values and collections stay JSON; missing measurements remain null. Choose one member using its lowercase subscriber hash from Audience members. Tags are fully paged through the dedicated endpoint rather than inferred from an embedded preview.
- Campaign link clicks
API-reported results for one explicitly selected campaign, cumulative as available at read time. The report date range does not filter these records. Tracking, account permissions and provider history limits apply; opens/clicks can include automated activity. One row per reported campaign link, with native total/unique click counters. Unique counts are not additive across links.
- Members who clicked a link
API-reported results for one explicitly selected campaign, cumulative as available at read time. The report date range does not filter these records. Tracking, account permissions and provider history limits apply; opens/clicks can include automated activity. Choose one campaign link ID. One row per provider-reported member with its click count for that link; this is not website conversion attribution.
- Campaign recipients
API-reported results for one explicitly selected campaign, cumulative as available at read time. The report date range does not filter these records. Tracking, account permissions and provider history limits apply; opens/clicks can include automated activity. One row per reported recipient with delivery status, open count and last-open timestamp. This is a sent-to report, not current audience subscription state.
- Campaign recipient activity
API-reported results for one explicitly selected campaign, cumulative as available at read time. The report date range does not filter these records. Tracking, account permissions and provider history limits apply; opens/clicks can include automated activity. One recipient per row with the API-reported action list as JSON. Action type, timestamp and URL are retained; IP addresses are excluded. Optional bot filtering is sent to Mailchimp and recorded on each row; the default includes all reported activity. Filtering actions does not remove recipients with an empty activity list.
- Campaign unsubscribes
API-reported results for one explicitly selected campaign, cumulative as available at read time. The report date range does not filter these records. Tracking, account permissions and provider history limits apply; opens/clicks can include automated activity. One provider-reported unsubscribe per member, retaining its reason and timestamp. This read does not unsubscribe anyone or change consent.
Metrics and dimensions
125 report fields across 12 datasets.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Send Mailchimp data anywhere
Google SheetsA sheet that refreshes every morning.
Data StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.
Excel / CSVA Drive file you can open in Excel.ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
AI tools can also propose a Mailchimp change. Only the owner can approve it.
Which automated email sequences in Mailchimp had the highest unsubscribe rates last month?
The customer re-engagement sequence had an above-average 1.8% unsubscribe rate alongside a 42% open rate.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
- The same numbers can be split by who they came from.
- You can keep a row per day instead of one lump sum.
- Orders and sales stay in the report, ready each morning.
- People and the way you reach them can be their own rows.
What can you do with this data?
Explore all use cases →Start from a goal
Audiences (lists)
Current legacy-list audience inventory and native subscribed, unsubscribed and cleaned counts.
Use this template →Audience members
Current accessible data for one audience in the connected Mailchimp account.
Use this template →Audience segments
Current accessible data for one audience in the connected Mailchimp account.
Use this template →Segment members
Current accessible data for one audience in the connected Mailchimp account.
Use this template →How it works
Connect Mailchimp from Data sources using the available sign-in or your account key.
Pick where it goes. This one sends the numbers to Claude.
Choose an audience or campaign report, then refresh on a schedule.
Sample report
| Audience counts | Members | Segments | Merge definitions | Member tags | Total and unique link clicks | Recipients | Reported actions |
|---|---|---|---|---|---|---|---|
| 1,240 | 1,240 | 1,240 | 1,240 | 1,240 | 860 | 1,240 | 1,240 |
| 640 | 640 | 640 | 640 | 640 | 410 | 640 | 640 |
| 210 | 210 | 210 | 210 | 210 | 155 | 210 | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Mailchimp
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Mailchimp + Shopify“Did orders rise in the days after each send?”See Shopify →
Mailchimp + Google Analytics“Did site visits rise after each email went out?”See Google Analytics →
Mailchimp + Stripe“Is the list growing as fast as paying customers?”See Stripe →
Mailchimp + HubSpot“Did the last campaign move any deals forward?”See HubSpot →Questions
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
No. Name a project, add a data source, then choose a report and destination.
OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.
Only the workspace owner. Writes start disabled. The owner enables permitted actions and eligible teammates: owner only, all project operators and managers, or selected teammates. The owner can change this at any time, and saving new settings cancels pending proposals.
No. Teammates propose in Datapipe, and approved changes are applied through the connected Mailchimp account. Nobody else gets a Mailchimp login from this.
They can propose a change through Datapipe, the same way a teammate can. They can never approve it. Only the owner approves, in Actions & approvals.
Datapipe sends each approved change once and logs the result. If it cannot confirm that Mailchimp received it, the request is marked Uncertain and is never retried automatically, so you can check Mailchimp first.
Yes. Datapipe reads the reports on this page and can make 10 kinds of change: update audience member name; update contact fields and groups; add or remove a contact tag; unsubscribe a contact or ask them to resubscribe; archive a contact; edit a draft campaign's subject, preview text, name or sender; schedule a draft campaign; unschedule a campaign; send a draft campaign now; pause or start a classic automation. Each one stays off until the owner turns it on, and every proposed change needs the owner's approval. Provider permissions still apply.
This page lists 125 report fields across 12 datasets. You pick the columns when you build the report.
Available rows depend on the connected account, selected report type, its date rules and provider limits. Current-inventory reports show current records rather than earlier historical states.
One for each Mailchimp account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Try Mailchimp with sample data first
Build the report first, then add Mailchimp when you are ready.