🔍
Key Insights
📋 Filters & Analysis Tools
Activity Distribution by Subscription Type
Shows the count of restaurants grouped by subscription type (Free, Trial, Paid) and their activity levels.
Activity Levels:- No Activity: 0 active users in last 30 days
- Low Activity: 1-4 active users
- Medium Activity: 5-9 active users
- High Activity: 10+ active users
activeUsers30d from analytics dimension tables
Revenue Distribution Analysis
Histogram showing the distribution of monthly sales revenue across all restaurants.
Data Processing:- Uses IQR (Interquartile Range) method to filter extreme outliers
- Upper bound = Q3 + 3 × IQR
- Y-axis shows count of restaurants in each revenue bracket
avgMonthlySales calculated from POS and sales data
Usage Intensity vs Scale Analysis
- X-axis (Usage Intensity): Invoices per user - higher values indicate more intensive use
- Y-axis (Scale): Number of active users - higher values indicate larger restaurant operations
- Zones: High Intensity + Large Scale = Pro tier candidates | Low Intensity + Small Scale = Unlikely to convert
- Circle size: Total invoice volume over 30 days
Usage Intensity = Total Invoices (30d) / Active Users (30d)
This metric helps identify restaurants that are getting high value per user, which often correlates with willingness to pay for the service.
Data Sources:invoiceCount30dfromanalytics_factinvoiceactiveUsers30dfromanalytics_dimensionrestaurantuser- Circle size uses total invoice count for visual weight
Conversion Cohorts
Groups restaurants by activity level and shows conversion rates within each cohort.
Conversion Rate:(Paid Restaurants / Total in Cohort) × 100
Feature Usage Analytics
Counts restaurants with at least one item in each feature category.
Restaurant Details
| Name | Status | Active Users | Invoices | Orders | POS | Created | Last Active | Monthly Sales | Usage Profile |
|---|