How to monitor user engagement metrics tracking in Bubble.io: Step-by-Step Guide

Go to Data tab → Data types. Create 'UserSession' with fields: user (User), login_time (date), logout_time (date), duration_minutes (number), device_type (text). Create 'EngagementEvent' with fields: user (User), event_name (text, e.g., 'clicked_upgrade', 'viewed_pricing'), event_data (text), timestamp (date). Create 'DailyMetric' with fields: date (date), dau_count (number), new_users (number), avg_session_minutes (number), total_events (number).

In your login workflow (after the 'Log the user in' action), add: Create a new thing UserSession (user = Current User, login_time = Current date/time, device_type = detect via user agent or leave blank). Store the Result of step's unique id in a custom state called 'current_session_id.' In your logout workflow (before 'Log the user out'), add: Make changes to UserSession where unique id = page's current_session_id → logout_time = Current date/time, duration_minutes = (Current date/time - This UserSession's login_time):format as seconds / 60 rounded to 0.

At key interaction points in your app, add event logging. For example, when a user clicks the pricing page button, add a workflow action: Create a new thing EngagementEvent (user = Current User, event_name = 'viewed_pricing', timestamp = Current date/time). Do the same for other important actions: 'completed_signup,' 'created_project,' 'invited_teammate,' 'upgraded_plan.' Keep event names consistent (lowercase with underscores) so they are easy to aggregate later.

Go to Backend workflows and create a workflow called 'aggregate_daily_metrics.' Schedule it to run daily at midnight. In the workflow: (1) Calculate DAU by searching UserSessions where login_time is today, then counting unique users. (2) Calculate new users by searching Users where Created Date is today:count. (3) Calculate average session duration from today's UserSessions. (4) Count total EngagementEvents from today. (5) Create a new DailyMetric record with all these values. Schedule the workflow to re-run itself tomorrow.

Create an 'analytics' page. Add a chart element (from the Chart.js plugin). Set the chart type to 'Line.' For the X-axis, use DailyMetric records' dates (search DailyMetrics sorted by date, last 30 days). For the Y-axis dataset, use dau_count values. Add a second dataset for new_users in a different color. Below the chart, add summary cards: a Group showing 'Today's DAU' (search DailyMetrics where date = today's dau_count), 'This Month's MAU' (search UserSessions where login_time >= first day of month, unique users count), and 'Average Session Duration.' Style cards with large numbers and labels.

Below the main chart, add a Repeating Group showing event name breakdown. Data source: search EngagementEvents where timestamp >= 30 days ago, grouped by event_name, aggregation: count. Display each event name with its count and a percentage of total. Add date range filters (two Date Picker elements for start and end dates) that constrain all searches on the page. Add a Dropdown filter for specific event names so admins can drill down into specific user actions.