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 |