cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lgbuss Frequent Visitor
Frequent Visitor

Customer 'Journey' by Sale Source

Hello! I've tried searching everywhere to no avail. Here's hoping perhaps someone might be able to point me in the right direction. I'm trying to figure out how to show the number of customers along a journey path.

 

Product A

 

1st Sale

100 customers is from website

25 customers is from mobile

20 customers is from retail

 

2nd Sale

100 from website

10 from mobile

2 from retail

 

3rd Sale

20 from website

3 from mobile

1 from retail

 

et cetera

 

My data source is set up in this way:

 

useridproduct_idtimestampsource
user 1a02:00retail
user 2b03:00website
user 3b05:00website
user 2c09:00website
user 4a10:00retail
user 2b12:00mobile
user 1a13:00mobile
2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Customer 'Journey' by Sale Source

Hi @lgbuss,

 

How do you determine it's 1st sale, 2nd sale, 3rd sale,..etc? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lgbuss Frequent Visitor
Frequent Visitor

Re: Customer 'Journey' by Sale Source

@v-qiuyu-msft Thank you so much for the swift reply!

 

I'd like to determine if it's the fist sale based on the timestamp.  So, User 1's first sale of product A was Retail. User 1's 2nd sale of product A was mobile, et cetea.