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 | ![]() |