Calculating CTR in Mixpanel: Challenges with E-commerce Events
Hi everyone, I hope you're all doing well! I'm currently using Mixpanel for an e-commerce project, and it has events for Product List Viewed and Product Clicked. I'm trying to calculate the CTR between these two events, but I've run into a bit of a challenge. The Product List Viewed event includes multiple products, which means we have a "Products" property that is an array of objects, with each object representing a product. On the other hand, the Product Clicked event only contains a single product, so all the product information is flattened in the event's body, and it doesn't have the Products property. Because of this, I'm unable to compare the two events. Has anyone else experienced this issue and figured out how to calculate the CTR? One potential solution would be to include the Products in the Product Clicked event, but that would require changing the tracking (and many other product events) and fixing the historical data, which is a big no for me. Thanks!
