Skip to main content

Mixpanel Community Icon

Home
Groups
Members

Announcements
Community Questions
Mixpanel Bot
Product Ideas
Resources

Community Guidelines

Docs & Guides
Events & Webinars
Contact Us

Powered by Tightknit

How to Create a Cohort Table Report for Users Registered Within 7 Days Without Transactions on Kapa.ai

·Jun 17, 2026 05:28 PM·

kapa.ai How can I create a table report that shows a cohort of users who registered within 7 days but did not make a transaction?

1 comment

· Sorted by Oldest

kapa.ai
APP
·
(edited)·
Here's how you can create this analysis in Mixpanel:
Step 1: Create the Cohort
First, build a cohort for users who registered within 7 days but did not make a transaction:
1.
Go to the Users page in Mixpanel.
2.
Click Add Filter and set the following conditions:
Did Sign Up (or your registration event) in the last 7 days
Did not do Transaction (or your purchase/transaction event) in the last 7 days
3.
Use the AND operator to combine both conditions.
4.
Save and name your cohort (e.g., "Registered, No Transaction – Last 7 Days").
[Cohort Builder docs] [Cohort setup guide]
Step 2: Use the Cohort in a Report
Once the cohort is saved, you can use it in an Insights report to display it as a table:
1.
Go to Insights.
2.
In the Events and Cohorts menu, select your saved cohort.
3.
Change the visualization to Table using the chart type selector.
4.
Optionally, add breakdowns (e.g., by country, device, or marketing source) to get more granular data.
[Using cohorts in analysis]
Tips
You can also filter any existing report by this cohort using the global Filter button, which will restrict the entire report to only users in that cohort. [Report filters]
The cohort is reusable — once saved, you can apply it across Funnels, Retention, and other reports without recreating it.
Cohorts are private by default but can be shared with your team. [Managing cohorts]
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.