Datapipe
Email marketing agencies
Send each client a monthly report of campaigns, opens, clicks and list growth.
Read & reportControlled changes
See your Campaign Monitor numbers in Google Drive.
Read sent campaigns, clicks by link, subscriber lists, list changes by day and transactional email from a Campaign Monitor account, including every client of an agency account. You can allow teammates and AI tools to add or unsubscribe a subscriber and to schedule a draft campaign or move it back to drafts. Allowed changes apply right away and are recorded in history.
- Campaign results for every client, refreshed for you
- See which links readers click in each newsletter
- Ask ChatGPT or Claude which list grew fastest this month
Google DriveStart free Connect Campaign Monitor
Updated November 2026
| Campaign name | Recipients | Unique opens |
|---|---|---|
| Coffee club · 2026-11-10 | 7,522 | 3,031 |
| Running club news · 2026-11-06 | 2,236 | 1,076 |
| Wholesale price list · 2026-11-05 | 1,395 | 887 |
- SetupPaste a key or token
- Reads75 report fields across 6 datasets
- Changes4 change actions
- RefreshDaily to every 15 minutes
Who uses Datapipe with Campaign Monitor
In-house marketing teams
Compare newsletters week by week without exporting reports.
Ecommerce brands
See which products and offers readers click, next to transactional email totals.
What you can do with Campaign Monitor
Read and report
One account stays bound to each data source.
- Campaign performance
- Clicks by link
- Subscriber lists
- List changes by day
- and 2 more
Controlled changes
- Add a subscriber to a list
- Unsubscribe a subscriber from a list
- Schedule a draft campaign
- Move a scheduled campaign back to drafts
Changes stay off until you allow them. Allowed changes apply to Campaign Monitor right away, and history keeps the values before and after.
Full read details
Campaign results count everything up to now; list figures are current, and list changes by day cover up to 92 days. Subscriber email addresses and names are left out of reports.
Examples for your team
Report campaign results per client
Compare recipients, unique opens, clicks and unsubscribes for every campaign each client sent this month.
- Scheduled refresh
- Latest Campaign Monitor data
- Updated report
Show list growth
Track new subscribers, unsubscribes and bounces for every list, day by day.
- Scheduled refresh
- Latest Campaign Monitor data
- Updated report
Schedule the approved newsletter
A teammate schedules the client’s approved draft for Tuesday at 9:00 in the client’s time zone.
- Allowed
- Applied
- Recorded
Limit: History keeps the change, and it can be moved back to drafts.
Fix things in Campaign Monitor without opening it
Spot it, fix it
See the problem in your report, then make the fix in Datapipe instead of opening Campaign Monitor, finding the record and retyping it.
More people can help
Teammates and AI tools you allow can make changes without getting edit access to Campaign Monitor.
You decide what can change
Changes stay off until you allow them. Every change is recorded with who made it and the values before and after.
Jobs you can stop doing by hand in Campaign Monitor
Add a subscriber to a list
Add an event sign-up
TodayType the address into Campaign Monitor by hand.
With DatapipeA teammate adds the sign-up to the newsletter list with their tracking consent. Confirmed opt-in lists still send the confirmation email.
Add a new wholesale buyer
TodayWait for the client to add them.
With DatapipeClaude adds the buyer from your order sheet to the wholesale list.
Exactly what this can change
Adds one subscriber to a list with their tracking consent. Lists with confirmed opt-in send a confirmation email first. An address that unsubscribed or bounced is not added again.
Supported fields: Email, Name, Consent to track opens and clicks.
Unsubscribe a subscriber from a list
Honour an unsubscribe request by email
TodayFind the list and unsubscribe the address by hand.
With DatapipeA teammate unsubscribes the address that asked by reply; history records who did it and when.
Remove a departed client contact
TodaySearch each list in Campaign Monitor.
With DatapipeUnsubscribe the contact from the client’s list from Datapipe.
Exactly what this can change
Unsubscribes one active subscriber from a list. If the client’s lists share a suppression list, the address is suppressed there too.
Supported fields: Email.
Schedule a draft campaign
Schedule the approved newsletter
TodayLog in, open the draft and pick a time.
With DatapipeSchedule the client’s approved draft for Tuesday at 9:00. Campaign Monitor emails the confirmation address when it sends.
Line up next week’s promotion
TodayWait for someone with Campaign Monitor access.
With DatapipeClaude schedules the promotion draft for the time the client approved.
Exactly what this can change
Schedules one draft campaign to send at a time from tomorrow on, in the client’s time zone, to the lists and segments it already has. It is never sent immediately. Campaign Monitor emails the confirmation address when it sends.
Supported fields: Send at (client’s time zone, YYYY-MM-DD HH:MM), Email for the send confirmation.
Move a scheduled campaign back to drafts
Hold a newsletter that needs a fix
TodayLog in and unschedule it before it goes out.
With DatapipeMove the scheduled campaign back to drafts from Datapipe, fix it, then schedule it again.
Pause a send after news breaks
TodayFind the campaign in the scheduled list.
With DatapipeA teammate moves the campaign back to drafts in seconds.
Exactly what this can change
Cancels the schedule of one campaign that has not started sending and keeps it as a draft.
Supported fields: Campaign.
Schedule a draft campaignDraft · Coffee club · December roast · made by Jordan Blake
| Field | Before | After |
|---|---|---|
| Status | Draft | Scheduled for 2026-12-01 09:00 |
You control who can change what
- A change is allowed for this data source
- A teammate or AI tool makes it
- It applies right away, or waits for approval if you set that
- Recorded with the values before and after
Source changes are managed on the Changes page in Datapipe. Approval is optional: set it for risky changes, for every change, or for one person. AI tools such as ChatGPT can never widen their own access. Who can turn this on?
Provider rules and limits
Provider permissions still apply, and automations in Campaign Monitor may react to changes.
Only fields supported by an allowed action can be changed; for some actions the owner, an admin or a project manager also picks the individual writable fields.
Before you connect
What you need
An API key or token from your Campaign Monitor account.
Read and write
Read access for reports. The 4 change actions need edit access in Campaign Monitor and stay off until the owner, an admin or a project manager allows them.
Limits and exclusions
Subscriber email addresses and names are not included.
Full details and limits
Read one Campaign Monitor account, including every client of an agency account: sent campaigns with opens, clicks, unsubscribes and bounces, clicks by link, subscriber lists and their daily changes, drafts and scheduled campaigns, and transactional email totals. Dates go back up to 365 days (92 days for list changes by day). Subscriber email addresses and names are left out.
Uses the account’s Campaign Monitor API key from Account settings. A person with full access creates it. The same key covers reports and subscriber and campaign changes.
Campaign results count everything up to now, so recent campaigns keep changing. List figures are current, and list changes by day cover up to 92 days. Subscriber email addresses and names are not included.
Reports you can build
6 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
- Campaign performance
- Clicks by link
- Subscriber lists
- List changes by day
- Drafts and scheduled campaigns
- Transactional email
What each dataset reports
- Campaign performance
One row per campaign sent in the selected dates, for every client the key can see: recipients, unique and total opens, clicks, unsubscribes, bounces, spam complaints and forwards. Results count everything up to now, as Campaign Monitor reports them, so a recent campaign keeps adding opens and clicks. Sent dates are as Campaign Monitor gives them for the client.
- Clicks by link
One row per campaign and link for campaigns sent in the selected dates: how many clicks the link got and how many subscribers clicked it, counted from Campaign Monitor’s click records up to now. Subscriber email addresses are not included.
- Subscriber lists
Current state of every subscriber list: active subscribers, and new subscribers, unsubscribes, deletions and bounces today, yesterday, this week, this month and this year, as Campaign Monitor counts them in the client’s time zone. Report dates do not change these values.
- List changes by day
One row per list and day in the selected dates: subscribers who joined and are still active, unsubscribes and bounces, counted from Campaign Monitor’s subscriber records by the date it gives in the client’s time zone. People who joined and later left count only on the day they left. Days without changes are left out.
- Drafts and scheduled campaigns
Every draft and scheduled campaign for each client the key can see, with its subject and, for scheduled ones, when it will send in the time zone Campaign Monitor shows. Use the Campaign ID here to schedule a draft or move a scheduled campaign back to drafts. Report dates do not change this list.
- Transactional email
One row per client with Campaign Monitor’s transactional email totals for the selected UTC dates: messages sent, delivered, bounced, opened and clicked.
Metrics and dimensions
75 report fields across 6 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 Campaign Monitor 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 make allowed Campaign Monitor changes. They can never widen their own access.
Which Campaign Monitor campaign got the most clicks in the last 30 days, and which link did readers click most?
Coffee club on November 10 led. The shop link got the most clicks, then subscriptions.
Better than exporting by hand
- It refreshes on its own, so nobody pastes in a new export.
- Each campaign can be its own row.
- You can keep a row per day instead of one lump sum.
Start from a goal
Campaign performance
One row per campaign sent in the selected dates, for every client the key can see: recipients, unique and total opens, clicks, unsubscribes, bounces, spam complaints and forwards.
Use this template →Clicks by link
One row per campaign and link for campaigns sent in the selected dates: how many clicks the link got and how many subscribers clicked it, counted from Campaign Monitor’s click records up to now.
Use this template →Subscriber lists
Current state of every subscriber list: active subscribers, and new subscribers, unsubscribes, deletions and bounces today, yesterday, this week, this month and this year, as Campaign Monitor counts them in the client’s time zone.
Use this template →List changes by day
One row per list and day in the selected dates: subscribers who joined and are still active, unsubscribes and bounces, counted from Campaign Monitor’s subscriber records by the date it gives in the client’s time zone.
Use this template →How it works
Create a project and choose Campaign Monitor in Data sources.
Pick where it goes. This one sends the numbers to Google Drive.
Pick where it goes. Choose campaign performance or another dataset, the dates and a destination.
Sample report
Sample campaign report for the last 30 days, one row per sent campaign across the agency’s clients. Opens and clicks count everything up to now, so recent campaigns keep adding to them.
| Campaign name | Recipients | Unique opens | Clicks | Unsubscribes |
|---|---|---|---|---|
| Coffee club · 2026-11-10 | 7,522 | 3,031 | 478 | 16 |
| Running club news · 2026-11-06 | 2,236 | 1,076 | 274 | 5 |
| Wholesale price list · 2026-11-05 | 1,395 | 887 | 226 | 3 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Works well with Campaign Monitor
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.
Campaign Monitor + Google Analytics“Follow newsletter clicks to visits and conversions on the website.”See Google Analytics →
Campaign Monitor + Shopify“Line up campaign sends with orders.”See Shopify →
Campaign Monitor + Mailchimp“Compare clients on Campaign Monitor with clients on Mailchimp side by side.”See Mailchimp →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.
The workspace owner, workspace admins and project managers. Changes start off. They choose which changes are allowed for each data source and who can make them: project operators and managers, selected teammates, and the AI tools those people connect. They can change this at any time.
No. Teammates make allowed changes in Datapipe, and Datapipe applies them through the connected Campaign Monitor account. Nobody else gets a Campaign Monitor login from this.
Yes, if that change is allowed for them. They work through Datapipe the same way a teammate does, within the same allowed changes and fields, and every change is recorded in the Changes history. AI tools can switch changes off, but they can never widen their own access. Asking for more waits for a person.
Yes, if you want. For each data source, approval can cover risky changes only (deleting, sending, publishing, refunds and price changes) or every change. You can also switch it on for one person, such as an intern. Those changes wait on the Changes page until the owner, an admin or a project manager approves them. Nobody but the owner approves their own change.
Datapipe sends each change once and records the result in the Changes history. If it cannot confirm that Campaign Monitor received it, the request is marked Uncertain and is never retried automatically, so you can check Campaign Monitor first.
Yes. Datapipe reads the reports on this page and can make 4 kinds of change: add a subscriber to a list; unsubscribe a subscriber from a list; schedule a draft campaign; move a scheduled campaign back to drafts. Each one stays off until the owner, an admin or a project manager allows it for this data source. Allowed changes apply right away and are recorded in the Changes history. Provider permissions still apply.
This page lists 75 report fields across 6 datasets. You pick the columns when you build the report.
Read one Campaign Monitor account, including every client of an agency account: sent campaigns with opens, clicks, unsubscribes and bounces, clicks by link, subscriber lists and their daily changes, drafts and scheduled campaigns, and transactional email totals. Dates go back up to 365 days (92 days for list changes by day). Subscriber email addresses and names are left out. Account permissions and the records available from the provider determine which rows can be read.
One for each Campaign Monitor 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 Campaign Monitor with sample data first
Build the report first, then add Campaign Monitor when you are ready.