Measures and Dimensions in Google Looker for SMS Channel

The measures and dimensions for the various data exploration views of the SMS channel are as follows:

Table 1. Dimensions
Dimensions SMS Campaign

Summary

SMS Campaign

Summary by Hour

SMS Campaign Link

Summary by Hour

SMS Recipients

Summary

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

Summary

SMS Campaign

Summary by Hour

SMS Campaign Link

Summary by Hour

SMS Recipients

Summary

Count Yes
Delivered Yes
Failed Yes
Rejected Yes
Total Click Rate Yes Yes Yes
Total Clicks Yes Yes Yes Yes
Total Delivered Yes Yes Yes
Total Failed Yes Yes Yes
Total Pending Yes
Total Rejected Yes Yes Yes
Total Sent Yes
Unique Click Rate Yes
Unique Clicks Yes