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:
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 | ||||
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 |
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 |