https://www.growthbook.io/ logo
Join Slack
Powered by
This message was deleted.
# ask-questions
w
This message was deleted.
r
@microscopic-article-59871 has opened an issue Close Issue button
⭐ Our official support hours are 6:30am - 5pm Pacific Time, Monday through Friday. You may occasionally hear from us outside of these hours. Your support request has been logged in our system. Our support team will get back to you very soon!
b
Hi, I’ve got your support request in my queue and I’ll follow up as soon as I can
m
Hi, that's great thank you for the update 🙂
Just an update, I managed to fix point 2 by using: 
ecommerce.purchase_revenue
This now pulls through the value in GPB. Still not sure how I can get a bounce rate percentage though.
r
Hello, Josh, thanks so much for your patience! Here is an example of a SQL query that produces the Bounce Rate for GA4/BigQuery:
Copy code
SELECT
    user­_id,
    user­_pseudo­_id AS anonymous­_id,
    MIN(TIMESTAMP­_MICROS(event­_timestamp)) as timestamp,
    concat(user­_pseudo­_id,(select <http://value.int|value.int>­_value FROM unnest(event­_params) WHERE key = 'ga­_session­_id')) as session­_id,
    countif(event­_name = 'page­_view') as views,
FROM
  ­*­*­* your table ­*­*­*
WHERE
    ((­_TABLE­_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}')
    OR (­_TABLE­_SUFFIX BETWEEN 'intraday­_{{date startDateISO "yyyyMMdd"}}' AND 'intraday­_{{date endDateISO "yyyyMMdd"}}'))
group by
  user­_id,
  user­_pseudo­_id,
  session­_id
HAVING views = 1
Please note that you will need to provide the name of the table you're using in BigQuery on this line:
Copy code
FROM
  ­*­*­* your table ­*­*­*
153 Views
Open in Slack
PreviousNext
Powered by