Analyzing Companies Not Visiting Your Website in 30 Days on Mixpanel
How to present the following data in Mixpanel: Which companies did not enter my website in the last 30 days? Users should be presented with a breakdown of the company.
How to present the following data in Mixpanel: Which companies did not enter my website in the last 30 days? Users should be presented with a breakdown of the company.
To identify companies that did not enter your website in the last 30 days with a breakdown by company in Mixpanel, you'll need to use Group Analytics and cohorts. Here's how to approach this:
Using Group Analytics
First, ensure you have Group Analytics set up, which is available as an add-on for Enterprise or Growth plans. Group Analytics allows you to analyze data at a company level rather than individual user level.1. Set up a company identifier in your Group Analytics configuration. This allows you to track events at the company level rather than just the user level.
2. In your reports, use the "Analyze Uniques by" dropdown to select your company identifier instead of distinct_id (the default user identifier). Group Analytics documentation
Creating a Cohort for Inactive Companies
To identify companies that haven't visited your website: 1. Go to the Cohort Builder in Mixpanel 2. Create a cohort with the condition: "Users who did NOT do 'Website Visit' in the last 30 days" 3. Make sure to select your company identifier in the "Analyze Uniques by" dropdownThis will create a cohort of companies that haven't visited your website in the specified timeframe.
Visualizing the Data
Once you have your cohort: 1. Go to the Insights report 2. Select your cohort as the data source 3. Add relevant breakdowns to segment the data by company properties (like company size, industry, etc.) 4. Choose an appropriate visualization (table chart works well for this type of analysis)You can also export this cohort for further analysis or to use in marketing campaigns: Exporting Cohorts documentation
Alternative Approach Using Filters and Breakdowns
You could also approach this by: 1. Creating an Insights report showing companies that DID visit your website 2. Using the "View Users" feature to see the list of companies 3. Saving this as a cohort 4. Creating a new cohort that excludes the companies in your first cohortRemember that the difference between filters and breakdowns is important here: - Filters exclude data that doesn't meet your criteria - Breakdowns segment your data into groups for comparisonBreakdowns vs. Filters videoThis approach will give you a comprehensive view of which companies haven't engaged with your website recently, allowing you to take targeted action.
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.
