Creating a Report on Recommended and Purchased Product Titles

Hi Team I have a question regarding creating reports. Context: I am passing two events with their respective properties:

1.
Recommended Product: title, sku, price
2.
Purchased Product: title, sku, price

If I am getting 8 recommended products, I'll hit 8 Recommended Product events to Mixpanel. If I am having 2 items in my order, I'll hit 2 Purchased Product events to Mixpanel. Now, I have to create a report where I should get the breakdown of Titles that were recommended to the users and they have also purchased with the number of times they have purchased. Please help me create the same report.

16 comments

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
Ansh A.
·
·
In the report you've built above - click on breakdown, in that you'll see computed as an option, and there you can choose the option borrow from. And then in that choose the recommended event with property title

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