Deliver Dimensions and Measures in Google Looker for WhatsApp Channel

The measures and dimensions for the various options of the WhatsApp channel, in the Explore View, are as follows:

Table 1. Dimensions
Dimensions WhatsApp Campaign

Summary

WhatsApp Campaign

Summary by Hour

WhatsApp Recipients

Summary

Campaign Code
Campaign ID
Campaign Name
Cell Code
Container ID
Container Name
Date Fields
> Contact Date
> Contact Hour of Day
> Contact Month
> Contact Quarter
> Contact Time
> Contact Week
> Contact Year
> Response Date
> Response Hour of Day
> Response Month
> Response Quarter
> Response Time
> Response Week
> Response Year
Mailing Code
Mailing Instance
Masked Mobile No
Mobile No
Table 2. Measures
Dimensions WhatsApp Campaign

Summary

WhatsApp Campaign

Summary by Hour

WhatsApp Recipients

Summary

Count
Total Delivered
Total Failed
Total Pending
Total Sent
Total Views