Transaction vs Order date based
The refunds data on the "Executive Summary" report should align with the Shopify sales report. Data in Shopify's Sales Report is calculated on a transaction-basis, meaning modifications to an order (such as returns, appeasements etc.) are treated as separate events on the day the update happened. Whereas Source Medium uses orders-based reporting, meaning order updates are reflected on the day the original order was placed.
if you are seeing the refunds number NOT matching with the Shopify Sales report, be sure to double check the
channel that are selected. The Customer Success Analyst can also let you know if we have features like
Exclude $0 Orders turned on, which could also influence the final
We'll be publishing a new refund dashboard that will have quite robust data on both refund date and order date basis.