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:
| 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 | |
| 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 | |