Creating a Metric for Job Applications Exceeding 10 in 2 Days
kapa.ai I have an event Job Application Submitted, need to know % Job has job application greater than 10 in 2 days. How to create this metric?
To create a metric that shows the percentage of jobs that have more than 10 job applications in 2 days, you can use Mixpanel's Insights report with formulas and custom bucketing. Here's how to approach this: 1. First, create an Insights report that measures the frequency of "Job Application Submitted" events per job.2. Use the "Frequency per User" measurement, but instead of grouping by user, you'll want to group by the job property (assuming your "Job Application Submitted" event has a property that identifies which job the application is for).3. Set your time frame to 2 days.4. Use Custom Bucketing to create buckets for your job applications, with one bucket specifically for jobs with more than 10 applications: - Click on the overflow menu (three dots) and select "Custom Buckets" - Choose "Varied" to create buckets of different sizes - Create a bucket for "> 10" applications5. To calculate the percentage, you can use a Formula to divide the count of jobs with > 10 applications by the total number of jobs.The Custom Bucketing feature is particularly useful here as it allows you to organize your high-cardinality segments (in this case, jobs by application count) into meaningful buckets. This is mentioned in the Insights Advanced documentation under the "Custom Bucketing" section.If you need to track this metric over time, you can save this report to a dashboard for ongoing monitoring.Note: This approach assumes that your events are structured with a job identifier property. If your data model is different, you might need to adjust the approach accordingly.
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.