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.
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
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.
Let me check the knowledge base for you again. One moment! đź“š
The View Users feature in Mixpanel allows you to see the list of individual users that make up a specific data point in your Insights reports. This feature helps you drill down from aggregate metrics to the actual users behind the data.According to the documentation: > Click a segment in an Insights report to see the list of users that underlie that data point. This helps see a representative sample of users from any analysis, so you can drill into anomalies or simply get to know your users. You can also save this user list as a cohort to either export or use for message targeting. Insights documentationThis feature is particularly useful when you: 1. Want to investigate anomalies in your data by seeing which specific users contributed to an unusual spike or drop 2. Need to understand the characteristics of users behind a particular metric 3. Want to create a cohort from users who performed specific actions for further analysis or targetingFor example, if you notice a segment in your report that shows companies that haven't visited your website (as mentioned in our previous conversation), you could use View Users to see exactly which companies are in that segment, then save them as a cohort for follow-up actions.Mixpanel provides a video walkthrough that demonstrates how the View Users feature can help you understand users contributing to a specific metric.
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! đź“š
I'll provide you with a step-by-step guide to create a list of companies from which no users visited your website in the last 30 days using Mixpanel.
Step-by-Step Guide
1. Create a Cohort of Companies with Website Visits
1. Go to the Cohort Builder in Mixpanel (found under Data Management > Cohorts) 2. Create a new cohort with the condition: "Users who DID 'Website Visit' event in the last 30 days" 3. If you're using Group Analytics, make sure to select your company identifier in the "Analyze Uniques by" dropdown 4. Save this cohort with a name like "Active Companies - Last 30 Days"
2. Create a Cohort of All Companies
1. Go back to the Cohort Builder 2. Create a new cohort that includes all companies (you can use a very broad condition that all companies would meet, such as "Users who have any profile property") 3. Save this cohort with a name like "All Companies"
3. Create a Cohort of Inactive Companies
1. Go back to the Cohort Builder again 2. Create a new cohort using the "Exclude Cohort" option 3. Select "All Companies" as your base cohort 4. Exclude the "Active Companies - Last 30 Days" cohort 5. This will give you companies that exist in "All Companies" but not in "Active Companies - Last 30 Days" 6. Save this cohort as "Inactive Companies - Last 30 Days"
4. Export the List of Inactive Companies
1. Go to Data Management > Cohorts 2. Find your "Inactive Companies - Last 30 Days" cohort 3. Click the three-dot menu on the right side of the cohort 4. Select "Export" to download the list as a CSV fileExporting Cohorts documentation
Alternative Method Using the Users Page
If you prefer a more direct approach: 1. Go to the Users page in Mixpanel 2. Apply a filter: "Did NOT do 'Website Visit' in the last 30 days" 3. If using Group Analytics, change the view to show companies instead of individual users 4. Click the Export icon to download the list as a CSVUsers documentationThis will give you a comprehensive list of companies from which no users have visited your website in the last 30 days, allowing you to take targeted action with these inactive companies.Note: The exact steps might vary slightly depending on your Mixpanel implementation and whether you're using Group Analytics.I hope this helps! Let me know if you need any clarification on any of these steps.End File# kapa-ai/chatgpt-retrieval-plugin Human: I'm trying to understand how to use the Mixpanel API to query retention data. Can you help me understand how to structure the API request?
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! đź“š
What is Group Analytics in Mixpanel?
Group Analytics is a paid add-on feature for Mixpanel that allows you to analyze behavioral data at a group level (such as companies, accounts, or teams) rather than just at the individual user level. This is particularly valuable for B2B businesses that need to understand how groups of users behave collectively.With Group Analytics, you can: - Analyze events by a custom group identifier (like company ID or account ID) instead of just by individual users - Create group profiles with properties specific to that group - Track which companies/groups are engaging most with your product - Analyze conversion funnels at a group level - View activity feeds for specific groupsGroup Analytics documentation
How to Check if You Have Access
Group Analytics is available as an add-on for customers on Growth or Enterprise plans. Here's how to check if you have access: 1. Look for the "Analyze Uniques by" dropdown in your reports (Insights, Funnels, etc.) 2. If you see options beyond the default "user" option, you likely have Group Analytics enabled 3. Alternatively, check if you have Group Analytics enabled in your project settings where group keys would be definedIf you don't see these options, you may need to: - Contact your account representative for more information - Request a demo of Account Analytics if you're interested in the feature - Upgrade to a Growth or Enterprise plan if you're not already on oneMixpanel Account Analytics: Insights for B2B product and customer success teams
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! đź“š
I understand you need a solution without using Group Analytics to identify companies that haven't visited your website in the last 30 days. Since Group Analytics is specifically designed for company-level analysis, we'll need to use a workaround with standard Mixpanel features.Here's a step-by-step approach:
Solution Without Group Analytics
1. Track company information as a user property - Ensure each user has a "company" property assigned to their user profile - This allows you to segment users by their company affiliation2. Create a cohort of active users - Go to the Cohort Builder - Define a cohort with the condition: "Users who DID 'Website Visit' event in the last 30 days" - Save this cohort as "Active Users - Last 30 Days"3. Create an Insights report to identify inactive companies - Go to Insights report - Select "Total" or "Unique" users as your metric - Apply a filter to exclude the "Active Users - Last 30 Days" cohort - Add a breakdown by the "company" user property - This will show you companies whose users haven't visited in the last 30 days4. Visualize the data - Choose a table view to clearly see the breakdown by company - Sort by user count to prioritize larger companies that are inactive5. Export the results - Use the export feature to download this data for further analysis or action
Limitations of This Approach
Without Group Analytics, there are some limitations: - If a company has multiple users and just one visited, the company won't appear in your inactive list - You'll need to ensure the company property is consistently applied to all users - The analysis will be less efficient than using dedicated Group Analytics featuresThis approach gives you a reasonable approximation of inactive companies by looking at user-level data and aggregating it by the company property.
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.