Shopify: product SKU, customer name, email,
Gorgias: Ticket tag, ticket text
Yotpo: Negative Sentiment Score
Returnly / Loop: Reason Code
By filtering by the SKU of the affected product, you can quickly identify the relevant cases across your tech stack. In Returnly, you found 241 cases of customers who brought the affected product and marked with the return code of "defective product." From the Gorgias integration, you then found 98 more cases through matching product SKU to ticket tags. The exact process occurred with Yotpo. You identified the reviews with a Negative Sentiment Score that affected SKU, finding 21 more unique cases. After getting this list of affected customers, the marketing team quickly put this group into a win-back funnel. Affected customers were given a refund for their order and a discount code for a future purchase. Thanks to the speed of the response, the win-back campaign was successful, preserving a majority of customers from churning.