Shopify | Reporting on SMS Campaigns

The Shopify - Sinch MessageMedia integration includes reporting on SMS campaign success. Outbound reporting on campaigns can be a valuable tool for your business as it provides information such as message delivery, opt-out metrics, return on investment, as well as click-through rates on any links you include in your message content. This data can help you adjust future campaigns so you get the most value for your business.

To view a list of campaigns, go to Campaigns and then Campaign Reports. 

When you connect to the Shopify integration, each campaign that is sent will display the following details:

1. Revenue: The influenced dollar value of revenue you have generated within 72 hours of sending the campaign.
2. ROI: ROI is calculated by dividing the value of sales made (by recipients of the campaign within 72 hours of sending it) by the campaign by the cost of messages sent, multiplied by 100: sales $ / sent cost $ * 100 = ROI%
3. Sales recovered: The number of sales made that can be attributed to this campaign
4. Units: The number of SMS units sent out in your campaign
5. Cost: The cost per SMS unit multiplied by the number of SMS units you have sent in your campaign

Attribution occurs where the campaign recipients phone number matches the phone number provided in the order details or shipping details.

Downloading the report

If you wish to dig deeper into the data, you can download a CSV file of the information seen on screen. This will allow you manipulate the data in any way that suits your business, or merge with external data sources for enhanced attribution. 

Here's how to download the report: 

1. From the report view, filter to your preferred reporting date
2. Click 'Download report'
3. Check your downloads for a CSV file named according to the Campaign name
4. Your CSV file will provide you information on: 
   • Purchaser Name
   • Purchaser Mobile
   • Purchaser Email
   • Cart Value
   • Click count - will provide you information on the number of times a customer clicked on the link  (if any) included within your message
   • Date and Time of: 
     • SMS send
     • Purchase
   • Time to purchase - provides you with the amount of time it took your customer to purchase
   • Message cost

For more information on other areas of reporting, take a look at our Reporting help section.