Anyone ever tried to do a bounce rate or engaged user type metric using the GA4 Bigquery export? I've got a fact table on the page_view event, but not certain how to make that a proportion of count > 1.

Hi Merritt. Sessions that have bounced are marked in the

totals.bounces

field with a

1

and sessions that didn’t bounce with a

NULL

I believe

I've never seen totals.bounces in the bigquery export. What event does it appear on?

oh, maybe that's wrong

¯\_(ツ)_/¯

This page lists common queries like bounce rate, which might help: https://www.ga4bigquery.com/sessions-dimensions-metrics-ga4/

Perfect. Thanks @strong-mouse-55694!