Linking Mixpanel Events for Analytics on User Rebates and Order Types

Ann E. · 2024-07-30T17:00:28.314Z

Hi everyone, I have a question. In Mixpanel, we receive two related events: 1. *Order Placed* - Information about an order placed for buying or selling on an exchange. 2. *User Rebate* - Information about a user receiving a rebate from the exchange after placing an order. The second event occurs only if the first event has occurred. Is it possible to get the data (parameters of the first event) to build analytics for the second event? For example, the *Order Placed* event has a parameter called *order type*, and I would like to see how many *User Rebate* events had a specific *order type*. Is it possible to link these two events by ID? Or is there a way to send a common identifier that can be used to join these events? If so, how can this be done?

Linking Mixpanel Events for Analytics on User Rebates and Order Types | Mixpanel Community

10 comments

· Sorted by Oldest

Moon L.
·
·
Hi Ann, one way to implement this is including “order id” and “order type” properties on the two events, and sending them during your “track” call. If you have “order type” directly on User Rebate (or User Rebate Sent or User Rebate Received to be consistent in naming convention) then you can use Insight Report with breakdown on “order_type” property to see how many rebate events had specific order type
Ansh A.
·
·
Ann E. You can use borrowed properties to do so. Mixpanel offers a way for you to do so. I've written a quick guide on using this here. Lemme know if you need any more help.
👍2
Ann E.
·
·
Ansh A. Great! Thanks a lot, that's just what I needed. One clarifying question, what is the basis for these properties? How do we understand that these two events are related? By some kind of user ID?
Ansh A.
·
·
User ID will be used to map, and it will always map to the latest value that's present for every event.
❤️‍🔥1
Ann E.
·
·
Thanks for your help! Our team decided that it will be best for us to send order_id for both the Order Placed and User Rebate events and match them by this property. Ansh A. Can you please explain how to link these two events by the order_id parameter? I need to be able to use this parameter to retrieve data from one event for another event that doesn’t have this data.
Ansh A.
·
·
Hey Anna E. you won't be able to map them by order ID using borrowed properties. But in your use case, I'm assuming whenever a rebate event fires, the latest order event should be mapped, and that is what will happen. So should work well for your use case right.
Ann E.
·
·
Ansh A. Thanks, but it seems that borrowed properties won’t work for us, as there are complex technical details regarding the sending of Rebate events (they are received in batches from the exchange) and therefore might not correspond to the order placement event. So, I still want to match them by ID. Is it possible to do this in other ways outside the concept of borrowed properties, if we are just considering the connection of two events by an equal parameter to get the required properties?
Ansh A.
·
·
Ann E. it's definitely possible, bur you'll have to change your implementation a bit. You can send the Order ID with both the events, and then create a funnel, choose keeping property constant feature within the funnel and keep Order ID constant. And then, you can just breakdown the funnel by order type. Does this help?
Ann E.
·
·
Ansh A. yeah, thanks, that definitely will help)
✅1
Ansh A.
·
·
Ann E. I also write a blog around simplifying Mixpanel, along with daily posts on LinkedIn. If you feel it could help, feel free to connect with me over LinkedIn, or follow my blog.
🔥1

Moon L.
·
·
Hi Ann, one way to implement this is including “order id” and “order type” properties on the two events, and sending them during your “track” call. If you have “order type” directly on User Rebate (or User Rebate Sent or User Rebate Received to be consistent in naming convention) then you can use Insight Report with breakdown on “order_type” property to see how many rebate events had specific order type
Ansh A.
·
·
Ann E. You can use borrowed properties to do so. Mixpanel offers a way for you to do so. I've written a quick guide on using this here. Lemme know if you need any more help.
👍2
Ann E.
·
·
Ansh A. Great! Thanks a lot, that's just what I needed. One clarifying question, what is the basis for these properties? How do we understand that these two events are related? By some kind of user ID?
Ansh A.
·
·
User ID will be used to map, and it will always map to the latest value that's present for every event.
❤️‍🔥1
Ann E.
·
·
Thanks for your help! Our team decided that it will be best for us to send order_id for both the Order Placed and User Rebate events and match them by this property. Ansh A. Can you please explain how to link these two events by the order_id parameter? I need to be able to use this parameter to retrieve data from one event for another event that doesn’t have this data.
Ansh A.
·
·
Hey Anna E. you won't be able to map them by order ID using borrowed properties. But in your use case, I'm assuming whenever a rebate event fires, the latest order event should be mapped, and that is what will happen. So should work well for your use case right.
Ann E.
·
·
Ansh A. Thanks, but it seems that borrowed properties won’t work for us, as there are complex technical details regarding the sending of Rebate events (they are received in batches from the exchange) and therefore might not correspond to the order placement event. So, I still want to match them by ID. Is it possible to do this in other ways outside the concept of borrowed properties, if we are just considering the connection of two events by an equal parameter to get the required properties?
Ansh A.
·
·
Ann E. it's definitely possible, bur you'll have to change your implementation a bit. You can send the Order ID with both the events, and then create a funnel, choose keeping property constant feature within the funnel and keep Order ID constant. And then, you can just breakdown the funnel by order type. Does this help?
Ann E.
·
·
Ansh A. yeah, thanks, that definitely will help)
✅1
Ansh A.
·
·
Ann E. I also write a blog around simplifying Mixpanel, along with daily posts on LinkedIn. If you feel it could help, feel free to connect with me over LinkedIn, or follow my blog.
🔥1