How to create a custom event property. Step-by-step guide.
Hi Ilya L., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Here’s a concise, step‑by‑step guide to creating a custom event property in Mixpanel, based on the docs.> Note: The docs describe “Custom Properties” in general; when you create one as a Custom Event Property, it can be used anywhere regular event properties are used.[Custom properties]---
1. Open a report where you use properties
1. Go to a core report such as Insights, Funnels, Retention, etc. 2. Start building a query where you would normally select or break down by a property.This is where the formula bar for custom properties is available.[Custom properties]---
2. Start creating a Custom Property
1. Click into the formula bar (often labeled for creating a custom property). 2. If available, use “Insert Example” to load a sample formula as a starting point.[Custom properties]---
3. Build the formula for your event property
1. Type your formula using the Excel‑like language. 2. Press Ctrl + Space to see a list of available functions and their descriptions. 3. Type a period (.) to open the menu of available event and profile properties you can reference. - For a Custom Event Property, you can use both event and user profile properties.[Custom properties]> The formula can be up to 20,000 characters long.[Custom properties]---
4. Apply locally and validate
1. Click Apply (or equivalent) to use the custom property only in this report. 2. Check that the values look correct in your charts/breakdowns. - This helps avoid cluttering your project with unused definitions.[Custom properties]---
5. Save as a reusable Custom Event Property
1. Once you’re satisfied, choose Save as Custom Property. 2. Give it a clear name and add a description so others understand its purpose. 3. Decide who can access it: - By default it is private to you. - Optionally click Save and Share to share with specific colleagues, teams, or the whole org.[Custom properties]After saving, this custom event property can be reused across reports almost anywhere you’d use a normal event property.[Custom properties]---If you describe the calculation you want (e.g., “order value bucket,” “days since signup”), I can help translate it into a concrete custom property formula using this flow.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
To convert Session Duration (seconds) into hours with a custom property or formula, use: text $duration_s / 3600LBKS- $duration_s is the raw event property for Session Duration (Seconds).[Reserved props]
- 3600 is the number of seconds in an hour, as suggested when converting seconds to hours in formulas.[Insights formulas]
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
