Count of Customers Who Only Have 1 Order

Question

We want to create a table as follows.

# of Orders per Customers. # of Customers

1 2,000

2-5 3,000

6+ 1,000

I cannot figure out how to do this with segments and calculated metrics. Any ideas are welcome.

Thanks ....

Gene

Obeab · Accepted Answer

Jennifer,Your solution is elegant. Thanks for taking the time to come up with that solution.I am in learning mode of how to combine segments and metrics and your solution is clearNow, for challenge #2. My real use case is a little different. On our Sephora.com website, after a user completes an order, there is a button they can click to signup for SMS updates.My business users wants to know the following.I can define a segment as follows.However I am stuck as how to use this to answer the 2 questions above. When you have time can you suggest an approach?Thanks...Regards,Gene

Jennifer_Dungan · Answer

You should be able to do segments like:

1 Order:

2-5 Orders:

6+ Orders:

Then you can just pair these with your Unique Visitor Metric.

This will return users in those groups within your panel time frame... if you need to see Users from farther back, you can add a date range right into your segment to look at number of Orders, within a larger date range.

Let's say your data retention is 2 years, you can create a custom date range to look fully back at all your data, or use one of the existing ranges (my sample will use "Last 13 Full Months"):

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded