Kevin P.

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

Got it I think…

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

But I need wheel_tyre to be Tyre AND Wheel not Tyre OR Wheel… but I can’t seem to do that in Mixpanel - any ideas?

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

Hmm… I’ve added a list property now for items which itself contains a wheel_tyre value of either Wheel or Tyre - but I can’t seem to figure out how to filter it… here’s what I’m currently doing

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

Yeah I think I’ll do the same, would be an extraordinary amount of data, although I expect you wouldn’t have to export it all would you?

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

Yeah good idea… unfortunately not going to help with my previous 18 months of data 😂 hindsight is a wonderful thing!!

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

I will look into the link you’ve sent above though, maybe that’s the answer

Commented on How to Create a Mixpanel Report for Wheel and Tyre...·Posted inCommunity Questions

Kevin P.

That’s given me a few ideas, thanks so much for that! I’ve managed to get something so I could do it for various date ranges and compare manually. What I’m really trying to do is get a report which shows me how many orders have Wheel AND Tyre items on them each day and compare that over time but to do that I’d need to GROUP order-complete-item either by order_id or by Unique User/Device then ascertain whether that GROUP has both Tyre and Wheel items in it

Posted in Community Questions·

Kevin P.

How to Create a Mixpanel Report for Wheel and Tyre Sales Tracking

Hi all, Can anyone help and point me in the right direction to achieve a particular report in Mixpanel? For sales on our website I record 2 types of event: one order-complete and one or more order-complete-item - where the order-complete-item represents a line item on the order. All of the events have a property for order_number and the order-complete-item event has a property for product_type (which can be either Wheel or Tyre). I want to produce a report that shows how many orders have BOTH Wheel and Tyre sales but I simply can’t figure out how to group it. I think I need to use a Custom Property and have tried looking at just order-complete-items by Unique User and going from there, but when I filter by Tyre AND Wheel, my report shows no data which I know is not correct If anyone could point me in the right direction here, I’d really appreciate it Cheers

14Comments