Chord Commerce Data Platform
Data Models
Users
3 min
new vs repeat users in purchasing, we have the concept of new vs returning users or customers new users whether or not the user is a new user, as defined by if the user has completed a first order repeat users whether or not the user is a returning user, as defined by the user has purchased again following a first order if analyzing new unique users and repeat unique users in a given period, they can be counted more than once since a user can be both new and repeat in the period when there's more than one purchase as a result, the count of new users plus the count of repeat users may be greater than the count of total unique users for example, this user is shown as a new and repeat user in this period and only counted once as a unique customer user oms user id unique new customer count unique repeat customer count unique customer count 12345678 1 1 1 if we add the purchase dates, we'll see that this user purchased twice over the period analyzed, which is why this user shows as both new and repeat in this period user oms user id order completed date unique new customer count unique repeat customer count unique customer count 12345678 1/1/2024 1 0 1 12345678 2/5/2024 0 1 1 if you have any questions or need help, please reach out to us at help\@chord co mailto\ help\@chord co