Deliver Dimensions and Measures in Google Looker for the Email Channel - Part 1

The measures and dimensions for the various options of the Email channel, in the Explore View, are as follows:

Table 1. Dimensions

Dimensions	Email Campaign Summary	Email Campaign Summary by Day	Email Campaign Response Analysis by Hour	Email Campaign Recipient Details
Campaign Code
Campaign ID
Campaign Name
Cell Code
Container ID
Container Name
Date Fields
> Contact Date
> Contact Month
> Contact Quarter
> Contact Time
> Contact Week
> Contact Year
> Response Date
> Response Month
> Response Quarter
> Response Time
> Response Week
> Response Year
Document
Email
Email (Masked)
Email Link
First Contact Hour
First Viewed Hour
Mailing Code
Mailing Instance
Mailing Name
Response Date
> Date
> Hour of Day
> Month
> Quarter
> Time
> Week
> Year
Test Name
Winning Criteria
Winning Test

Table 2. Measures

Measures	Email Campaign Summary	Email Campaign Summary by Day	Email Campaign Response Analysis by Hour	Email Campaign Recipient Details
Challenge Response
Count
Hard Bounce
ISP Feedback
Other
Out of Office
Send Failed
Soft Bounce
Technical Issue
Total Click Rate
Total Clicks
Total Delivered
Total Failed
Total Sent
Total Views
Unique Click Rate
Unique Clicks
Unique Complaints
Unique Views
Unknown
Winner Unique Clicks
Winner Unique Complaints
Winner Unique Views