How do I use borrowed property to filter other events?
How do I use borrowed property to filter other events?
How do I use borrowed property to filter other events?
Using Borrowed Properties to Filter Events
Borrowed properties, once created, behave like any other custom property in Mixpanel — meaning you can use them in filters and breakdowns across your reports. [Borrowed Properties] Here's how to set it up:
Step 1: Create the Borrowed Property
Go to Custom Properties and create a new custom event property.
Select "Add a borrowed property".
Choose the source event (the event that has the property you want).
Select the specific property to borrow.
This borrowed property will then capture the value from the most recent occurrence of the source event within a 7-day lookback window. [Borrowing Mechanics]
Step 2: Use the Borrowed Property as a Filter
Once created, the borrowed property is accessible to everyone in the project (depending on permissions) and can be used just like any standard property — including as a filter on other events in your reports. [Borrowed Properties]
Step 3 (Optional): Combine with Other Functions
If you want to use the borrowed property inside more complex logic (e.g., with other custom property functions), you need to:
First, create a custom property that contains just the borrowed property on its own.
Then, create a second custom property that references the first one and applies additional logic.
Key Limitations to Keep in Mind
The borrowed value comes from the most recent prior event where the property is set, within a 7-day window. If no matching event exists in that window, the property returns (not set).
A project can have a maximum of 20 borrowed properties.
Only Admin & Owner roles can create borrowed properties. [Borrowing Mechanics]
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Based on the available documentation, a single borrowed property is defined by selecting one specific source event and one specific property from that event. The creation flow described involves choosing a single event to borrow from and then selecting one property from it. [Borrowed Properties] The knowledge sources do not explicitly mention the ability to configure a single borrowed property to pull from more than one source event simultaneously. If you need to combine data from multiple events, a potential workaround based on the docs would be to:
Create separate borrowed properties for each source event (up to the 20-property project limit).
Then create a custom property that references those borrowed properties together using functions. [Borrowing Mechanics]
However, I'd recommend checking directly with Mixpanel Support to confirm whether multi-event attribution within a single borrowed property is supported, as the documentation doesn't provide enough detail to answer this definitively.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.