Creating a Report on Recommended and Purchased Product Titles | Mixpanel Community

Mixpanel Community Icon

Mixpanel is headed to Money20/20 October 26 - 29 in Las Vegas, Nevada!

Creating a Report on Recommended and Purchased Product Titles | Mixpanel Community

Ansh A.
·
·
Bhagyashree B. You want to see in one report, a table that tells you product that was recommended, how many times it was recommended, and how many times it was bought?
Bhagyashree B.
·
·
I want a list of all the purchased products which was recommended earlier in the history of user
Ansh A.
·
·
So, just immediately recommended before purchase? Or all products recommended before purchase?
Bhagyashree B.
·
·
all
Ansh A.
·
·
So against one purchased product, you want to get a list of all recommended products?
Bhagyashree B.
·
·
No.. Basically, I want a products breakdown on title from recommended product events.. out of that, if purchase product's title is matching in the forward journey of a user, then it should provide me the count 3 columns title no of times the product was recommended to the users no of times the same user has purchased that product
Ansh A.
·
·
Ah got it. So you can go to Insights report, choose both these events with "Total Events" as calculation. Break it down by title. And change chart type to a table. You'll get your report.
Bhagyashree B.
·
·
Okay.. I did the same. But now, how can I confirm whether the purchases are from the users who has received the recommendations
Ansh A.
·
·
You can create a cohort of users who purchased. And use that filter so that it will only show you data for users that have purchased.
Bhagyashree B.
·
·
I want users who got recommendations and have purchased from those recommended products
Ansh A.
·
·
But this would give you all recommended products for users that purchased. Else, like I asked, do you want the most recent recommended product, and user purchased that?
Bhagyashree B.
·
·
But this would give you all recommended products for users that purchased - right! Else, like I asked, do you want the most recent recommended product, and user purchased that? - This will work
Bhagyashree B.
·
·
Else, like I asked, do you want the most recent recommended product, and user purchased that - How can we implement this?
Ansh A.
·
·
You can use borrowed properties. So in breakdown, go to computed, and choose title from recommended event. The insighr should have purchase event
Bhagyashree B.
·
·
Could you please provide me with the steps here