Using our Iterable Connector with Looker Studio
Getting Started
Before you start, you’ll need to have your Iterable API key on-hand. This key allows our connector to link your Iterable account and Google Looker Studio.
To create an Iterable API key:
Sign in to your Iterable project as an org admin.
Navigate to Integrations > API Keys
Click New API Key
In the Create API Key window, enter a name for the key and select Server-side for the type of API key.
When you have finished, click Create.
In the Copy Your New API Key window, copy the API key.
Adding the Iterable Connector to your Looker Studio Report
There are two ways to begin adding your Iterable data to Looker Studio
To start with a new report, click here.
To add the Iterable Connector to a pre-existing report, search for Iterable Connector in the Add Data window of your Looker project.
Once you have authorized Looker Studio and the Iterable Connector, you will be prompted to input your Iterable API Key to complete setup.
Available Metrics
Average Custom Conversion Value number
Average Order Value number
Campaign Created At date
Campaign Created by User Id text string
Campaign Ended At date
Campaign ID text string
Campaign Labels text string
Campaign List IDs text string
Campaign Message Medium text string
Campaign Name text string
Campaign Recurring Campaign ID text string
Campaign Send Size number
Campaign Start At date
Campaign State text string
Campaign Suppression List IDs text string
Campaign Template ID text string
Campaign Type text string
Campaign Updated At date
Campaign Updated by User ID text string
Campaign Workflow ID text string
Purchases/M (Email) number
Revenue number
Revenue/M (Email) number
Sum of Custom Conversions number
Total Complaints number
Total Custom Conversions number
Total Email Holdout number
Total Email Opens number
Total Email Opens (filtered) number
Total Email Send Skips number
Total Email Sends number
Total Emails Bounced number
Total Emails Clicked number
Total Emails Delivered number
Total Hosted Unsubscribes number
Total Purchases number
Total Unsubscribes number
Unique Custom Conversions number
Unique Email Clicks number
Unique Email Opens number
Unique Email Opens (filtered) number
Unique Email Sends number
Unique Emails Bounced number
Unique Emails Delivered number
Unique Hosted Unsubscribes number
Unique Purchases number
Unique Unsubscribes number
Helpful Formulas
Please find some helpful formulas below for your Iterable Looker Studio reports
Click to Open Rate (CTOR): Unique Email Clicks/Unique Email Opens (filtered)
Bounce Rate: Total Emails Bounced/Total Email Sends
Delivery Rate: Total Emails Delivered/ Total Email Sends
Open Rate: Unique Email Opens (filtered)/Total Emails Delivered
Click Rate: Unique Email Clicks/Total Emails Delivered