Connect Iterable to Data Studio
Bring your Iterable data into Data Studio with Windsor.ai, so your reports read live campaign and engagement data.
Pick the Iterable fields you need, and Windsor.ai keeps them flowing without a CSV export in between.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your Iterable data into Data Studio
Iterable is connected once in Windsor.ai, and these are the use cases the fields support:
Compare campaigns
Sends, opens and clicks per campaign show which campaigns people open and click.
Find the links people click
Email clicks grouped by email_click.url show which links in each campaign get clicked.
Watch unsubscribes and bounces
Unsubscribe and bounce events by campaign and email_unsubscribe.unsubSource show which sends cost you subscribers.
Using Windsor.ai to connect data from Iterable to Data Studio
Windsor.ai moves your Iterable fields into Data Studio on a connection you set up once, so the reports stay on live records rather than a CSV someone exported last week.
Pick the fields you need and Windsor.ai handles the rest.
How to connect Iterable to Data Studio with Windsor.ai
Explore a step-by-step guide to integrate your Iterable data into Data Studio with the Windsor.ai connector.
Select your data source
Choose Iterable as your data source and enter an Iterable API key. In Iterable, go to Integrations, then API Keys, and create a new key; read-only access is enough.
Select the reporting fields
Choose the Iterable fields you want in Data Studio on the right side, and preview your data before export.
Select Data Studio as your data destination
Scroll down to the list of data destinations and click Data Studio. Install the Windsor.ai connector by authorizing your account, selecting the required Iterable account(s), and clicking Connect, then Create Report.
FAQs
What Iterable data can I load into Data Studio?
Windsor.ai gives access to 378 Iterable fields. These are the groups; the Iterable field reference lists all of them:
- Campaigns: campaigns.name, campaigns.Id, campaigns.type, campaigns.campaignState, campaigns.messageMedium, campaigns.sendSize, campaigns.startAt.
- Email events: sends, opens, clicks, bounces, complaints and unsubscribes, each with its campaign ID, template ID and time, for example email_open.campaignId, email_click.url and email_unsubscribe.unsubSource.
- Other channels: send, delivery, open and click events for SMS, push, in-app and web push.
- Templates and channels: templates.name, templates.templateId, channels.name, channels.messageMedium.
- Users: user profile fields such as users.email, users.signupDate and users.emailListIds.
- Time: Date, Week, Month, Year.
How does Windsor.ai load Iterable data into Data Studio?
Windsor.ai provides a Data Studio connector. You authorize it once, select your Iterable account and the fields you want, and build the report on live data.
Does the Iterable connector include contact details?
Yes. Event rows carry the recipient’s email address, for example email_open.email, and open and click events also have the city, region and country. The users table has profile fields such as users.email. Pick only the fields you need when you set up a report or ask a question.
Can I combine Iterable data with other sources in my reports?
Yes. Windsor.ai supports 350+ data sources, so Iterable data can sit next to other connected sources in the same reports. For example, put Iterable email clicks by email_click.url and GA4 Sessions and Engaged sessions by Landing page in one table.
Do I need to code to connect Iterable to Data Studio?
No. You connect Iterable in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.
How much does it cost to integrate Iterable with Data Studio using Windsor.ai?
The free forever plan covers 1 data source, so connecting Iterable on its own costs nothing and needs no credit card. Combining Iterable with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with Iterable and Data Studio?
Yes. These are the resources to start with for the Iterable to Data Studio integration:
Tired of manual Iterable data exports? Try Windsor.ai today to work on live data

