Deliver Dimensions and Measures in Google Looker for the Email Channel - Part 2
The measures and dimensions for the various options of the Email channel, in the Explore View, are as follows:
Dimensions | Email Campaign Unsubscribe Summary |
Email Campaign Link Summary |
Email Campaign Link Summary by Day |
Email A/B Test Campaign Overview |
---|---|---|---|---|
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 | ![]() |