How to Find Customers with 2 Purchases per Month

Hi Joe S., 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> 👋

To create a cohort in Mixpanel that finds customers who have on average 2 purchases per month, you can use the Cohort Builder.Here's how to set it up: 1. Navigate to the Cohort Builder at Mixpanel → Users → Cohorts, or access it directly from any report by clicking "Create Custom > Cohort"2. Define the cohort criteria using a filter like: - "Users who did Purchase (or your purchase event name) more than or equal to 2 times in the last 30 days"3. Save the cohort with a descriptive name like "Regular Purchasers (2+ per month)"According to the Cohort documentation, cohorts are defined using conditions of the form "Users who did <event> more/less than <some threshold> ". You can set the time window to match your monthly period (e.g., last 30 days) and the threshold to 2 or more purchases.Note: Mixpanel's cohort builder works with event counts over specific time periods rather than calculating true averages over multiple months. If you need to identify users with a consistent pattern of 2 purchases per month over several months, you may need to: - Create multiple cohort conditions for different monthly periods and combine them with AND operators - Or use the cohort to identify users who meet the threshold in a rolling 30-day windowOnce created, you can use this cohort to segment your analysis in Insights, Funnels, and Retention reports, or sync it to third-party tools like Segment or Braze for targeted campaigns.

ℹ️ 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 create a bar graph by date in Mixpanel, you'll want to use the Insights report with a specific chart configuration:

1. Go to Insights: Navigate to Reports → Insights2. Select your metric: Choose the event you want to analyze (e.g., "Purchase" or any other event)3. Set your date range: Use the date range selector to choose your desired time period (e.g., Last 30 days, Last 3 months, etc.)4. Choose the Bar Chart visualization: Click the chart type dropdown in the upper right corner and select Bar chartAccording to the Insights documentation, bar charts in Insights calculate metrics across the entire time period selected. However, if you want to see bars segmented by date (daily, weekly, or monthly), you should use the Column chart instead, which provides a time-segmented view.

- Select Column chart or Stacked Column chart from the visualization options - These chart types show your metric broken down by time intervals (daily, weekly, monthly) based on your date rangeYou can also adjust the time granularity by changing the date interval settings to view data by day, week, or month as needed.The Insights visualization options include both bar charts (for aggregate values) and column charts (for time-segmented data), so choose the one that best fits your analysis needs.

ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.