First, data is pulled from the SMS data views into two DEs:
1. Shared Items > Shared Data Extensions > _Reporting > Data Views > SMSSubscriptionLog
2. Shared Items > Shared Data Extensions > _Reporting > Data Views > SMSMessageTracking
The automation is located here: Automation Studio > my automations > Reporting > Data Views > SMS Data Views
Next, two DEs are populated and passed to Domo:
1. Shared Items > Shared Data Extensions > _Reporting > SMS > SMS_Subscribers
2. Shared Items > Shared Data Extensions > _Reporting > SMS > SMS_Messages
The automation is located here: Automation Studio > my automations > Reporting > SMS > SMS Reporting