Deliver Dimensions and Measures in Google Looker for SMS Channel

The measures and dimensions for the various options of the SMS channel, in the Explore View, 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
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
SMS Link

Table 2. Measures

Dimensions	SMS Campaign Summary	SMS Campaign Summary by Hour	SMS Campaign Link Summary by Hour	SMS Recipients Summary
Count
Delivered
Failed
Rejected
Total Click Rate
Total Clicks
Total Delivered
Total Failed
Total Pending
Total Rejected
Total Sent
Unique Click Rate
Unique Clicks