Correctly configured cohorts should accommodate refunds smoothly

Following up on yesterday's article, Shopify's refund skewing can get complex when it comes to customer cohorts.

I don't know how their cohorts work but in Repeat Customer Insights the cohorts use the order's adjusted values as described in the previous article (i.e. refunds adjust the original order's amount).

That means a refund has only two places it impacts cohorts:

  1. The Totals for the original cohort are adjusted down
  2. The specific month of the original cohort are adjusted down

Say for example an order is refunding in 2023-03 for an order placed in 2023-01 for a customer who first ordered in 2022-05.

  1. The totals for their 2022-05 cohort would be adjusted down
  2. The 2023-01 month in that cohort would be adjusted down (the 8th month)
  3. Nothing would happen to the 2023-03 cohort

That's the correct way a cohort report should handle refunds: by adjusting the original cohort.

Cohort reports are 100% behavior reports so I'd hope there's no skewing involved on Shopify's side.

Eric Davis

Optimize your promotion timing to save money and attention

Repeat Customer Insights will analyze a ton of customer behavior data for you, including their buying cycles.
If you knew exactly when the majority of your customers were ready to buy again, you can increase your orders and profit just by tweaking your message timing.

Learn more

Topics: Refund Cohort analysis

Would you like a daily tip about Shopify?

Each tip includes a way to improve your store: customer analysis, analytics, customer acquisition, CRO... plus plenty of puns and amazing alliterations.