Bounced vs engaged sessions per device
Bounced vs engaged sessions per device
From the sessions table, for each device count two metrics: bounced_sessions — sessions with bounced = 1, and engaged_sessions — sessions with bounced = 0. Group by device and return columns device, bounced_sessions, engaged_sessions. Sort by device ascending.
Expected output sample
| device | bounced_sessions | engaged_sessions |
|---|---|---|
| desktop | 1 | 3 |
| mobile | 2 | 2 |
| tablet | 1 | 1 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid