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