Are refunds in the Executive Summary report based on the cohort's purchase date or the date the refund was issued?

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 refunds number.

We'll be publishing a new refund dashboard that will have quite robust data on both refund date and order date basis.