First-Time and Returning Don't Add Up

Shopify Discussion
1

I just noticed looking at a report in Shopify where Returning, First-Time, and N/A do not match the total row when you sum them up individually. In the example below, the total customers says 2383 but when you add each row up it equals 2402. Does anyone know why that is?

Thanks.

gromden_1-1660666888996.png
gromden_1-1660666888996.png1587×187 5.28 KB

2

Hi @gromden

Claudia here from Better Reports.

The first-time customer type applies to all first orders, and all subsequent orders will show the returning customer type. This means that a returning customer will always have one order showing first-time.

In your report, some of the returning customers have also placed their first order during the time frame you are reporting on.

This type of report counts the distinct customer ids in each category but also counts the distinct customer id in the grand total.

This means that customer A that placed both their first and second order during that time frame, will count as 1 in both the first-time and returning customer type but will only count as 1 in the grand total.

Does this help clarify?

3

Hey Claudia

Thanks for the explanation. That makes sense if the grand total only counts the distinct customer id once even if they get counted as both new and returning.