Diagnosing Engagement Declines

How would you approach analyzing a decline in user engagement for a specific lending product?

Use the provided tables to produce monthly engagement metrics for Trepp CRE Lending Analytics from January through April 2024.

Output

1. One row per month, with engagement_month, active_users, engagement_events, events_per_active_user, active_users_pct_change, and engagement_events_pct_change
2. Include the first month with NULL prior-month percentage changes
3. Order by engagement_month ascending

Output details

• Count distinct users for active_users and count every qualifying event for engagement_events.
• Round events_per_active_user and both percentage-change columns to two decimal places.
• Calculate percentage changes relative to the previous month and multiply them by 100.
• Return NULL when a denominator is zero, including zero active users or zero prior-month values.
• Return only months containing qualifying events; do not add rows for months without events.
• Represent engagement_month as the first calendar day of each month.