how do i track notification click through rate, i want it to be in Insights using formula; how do i type divide in the formula
Hi ReCat, 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
To track notification click-through rate in Mixpanel Insights using a formula, you can use the division operator ("/") in the formula. Here's how you can set it up:1. In Insights, add two metrics: - One for notification sends - One for notification clicks2. Click on the "Metrics" button, then select "Formula" to create a new formula.3. In the formula editor, you can use the division operator ("/") to calculate the click-through rate. The formula would look something like this: B / A Where A represents notification sends and B represents notification clicks.4. You can rename the formula to something like "Notification CTR" for clarity.The division operator ("/") is used to perform division in Mixpanel formulas, as mentioned in the Custom Properties documentation.Remember that you can also multiply the result by 100 to display it as a percentage:(B / A) * 100This will give you the notification click-through rate as a percentage in your Insights report.
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.