Hi GrowthBook team, I’ve successfully added the snippet to Shopify and am pulling GA data through BigQuery. I can see some metrics, like page views, but I’m unable to find key metrics such as revenue or AOV. Could you please guide me on how I can access these metrics? Is there a specific setup or additional configuration required to fetch revenue and AOV data? Thanks in advance for your help!

Hi Leon, good morning! You'll want to create a metric for revenue in the Metrics section (https://app.growthbook.io/metrics). Further information on metrics config can be found in our docs here - https://docs.growthbook.io/app/metrics

Thank you Natasha, but i think i know how to create a metric. My problem is that i feel like important data is missing. Maybe in our Data Warehouse (GA / Bigquery) the revenue is missing? But maybe there is a way to submit this data via a event?

The revenue data will need to be in your data warehouse. How are you tracking revenue in BigQuery? You'll need to define this revenue metric in GrowthBook and then use SQL to join to your revenue data in BQ

I just followed the https://docs.growthbook.io/guide/GA4-google-analytics guide. (As sugested in your Shopify guide) I get a lot of events that can be automaticly converted in metrics (page_view, click, purchase). Since i dont have much experience with sql i wonder if there is a way to get the event data from the "purchase" event to create a revenue goal ... 🤷‍♂️ Also i dint work with big query before so i dont know if that data is in my database ...

Sorry for the delayed response, I was lunching. Reviewing your query now......

nah, that was just the problem, there is no metric for revenue ... but i found out via the google docs and investigating the database that i can pull some event specific data. (and it seemed to work) for anybody in the futre: the query that i endet up using was :

SELECT
  user_id,
  user_pseudo_id as anonymous_id,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  ecommerce.purchase_revenue_in_usd as value
FROM
  `ga4-growthbook-436511`.`analytics_324469232`.`events_*`
WHERE
  event_name = '{{eventName}}'
  AND ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
       (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))

with eventName being purchase. Maybe you want to include that somewhere 🙂

Hey Leon, sorry for delayed response I was out on sick leave. Ahhh I gotcha now. I'll submit a docs update request on your behalf. Thank you for the info 🙏