Is there a way to extract the full text of a SMS messages that were sent to customers?
I'm trying to create an automation that would create a history of all SMS messages that were sent to the customer.
The "SMS Message Detail Report" is pretty much useless if you are using the "Concatenate Message" settings for your sends. This report creates separate rows for each of the parts of the message and the ID that is assigned to them seems to be assigned in a random order.
For example if you had a message with parts A, B & C the corresponding IDs can be 3, 1 & 2, so there's no way to correctly concatenate those parts using an ascending or descending order.
Has anyone encountered custom extracts or other solutions that show the full the contents of text message that was delivered to a customer?