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.
engagement_month, active_users, engagement_events, events_per_active_user, active_users_pct_change, and engagement_events_pct_changeengagement_month ascending| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique lending product identifier |
| product_name | VARCHAR(120) | Name of the lending product |
| product_status | VARCHAR(30) | Current product status |
| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| user_name | VARCHAR(120) | User display name |
| segment | VARCHAR(50) | User business segment |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique engagement event identifier |
| user_id | INT | User who generated the event |
| product_id | INT | Product associated with the event |
| event_date | DATE | Date of the engagement event |
| event_type | VARCHAR(50) | Type of engagement activity |