Bounce rate per device
Bounce rate per device
From the sessions table, compute each device's bounce rate: the ratio of sessions with bounced = 1 to the total number of sessions. Group by device, round the ratio to 4 decimals, and return columns device and bounce_rate. Sort by device ascending. The count() denominator is always > 0 within a group.
Exemplo de resposta esperada
| device | bounce_rate |
|---|---|
| desktop | 0.25 |
| mobile | 0.5 |
| tablet | 0.5 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid