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

The measures and dimensions for the various data exploration views of the email channel 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	Yes	Yes	Yes	Yes
Campaign ID	Yes	Yes		Yes
Campaign Name	Yes	Yes	Yes	Yes
Cell Code	Yes	Yes
Container ID	Yes	Yes	Yes	Yes
Container Name	Yes	Yes	Yes
Date Fields		Yes		Yes
> Contact Date		Yes		Yes
> Contact Month		Yes		Yes
> Contact Quarter		Yes		Yes
> Contact Time
> Contact Week		Yes		Yes
> Contact Year		Yes		Yes
> Response Date		Yes		Yes
> Response Month		Yes		Yes
> Response Quarter		Yes		Yes
> Response Time
> Response Week		Yes		Yes
> Response Year		Yes		Yes
Document
Email				Yes
Email (Masked)				Yes
Email Link				Yes
First Contact Hour				Yes
First Viewed Hour
Mailing Code	Yes	Yes	Yes	Yes
Mailing Instance	Yes	Yes	Yes	Yes
Mailing Name				Yes
Response Date			Yes
> Date			Yes
> Hour of Day			Yes
> Month			Yes
> Quarter			Yes
> Time			Yes
> Week			Yes
> Year			Yes
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	Yes
Count				Yes
Hard Bounce	Yes
ISP Feedback	Yes
Other	Yes
Out of Office	Yes
Send Failed	Yes
Soft Bounce	Yes
Technical Issue	Yes
Total Click Rate	Yes	Yes
Total Clicks	Yes	Yes		Yes
Total Delivered	Yes
Total Failed	Yes	Yes
Total Sent	Yes
Total Views	Yes	Yes
Unique Click Rate	Yes	Yes
Unique Clicks	Yes	Yes	Yes	Yes
Unique Complaints
Unique Views	Yes	Yes	Yes	Yes
Unknown	Yes
Winner Unique Clicks
Winner Unique Complaints
Winner Unique Views