Ask any question about Analytics & Tracking here... and get an instant response.
Post this Question & Answer:
How can I use BigQuery to analyze eCommerce conversion rates over time?
Asked on Feb 17, 2026
Answer
To analyze eCommerce conversion rates over time using BigQuery, you'll need to query your GA4 data that's exported to BigQuery. This involves calculating the conversion rate by dividing the number of conversions by the number of sessions over a specific period.
<!-- BEGIN COPY / PASTE -->
SELECT
DATE(event_timestamp) AS date,
COUNTIF(event_name = 'purchase') / COUNT(DISTINCT session_id) AS conversion_rate
FROM
`your_project.your_dataset.events_*`
WHERE
_TABLE_SUFFIX BETWEEN 'start_date' AND 'end_date'
GROUP BY
date
ORDER BY
date;
<!-- END COPY / PASTE -->Additional Comment:
- Replace "your_project.your_dataset" with your actual BigQuery project and dataset names.
- Ensure the event name for purchases matches your GA4 setup, typically "purchase".
- Adjust 'start_date' and 'end_date' to the desired date range in 'YYYYMMDD' format.
- This query calculates the daily conversion rate by dividing the number of purchase events by the number of unique sessions.
Recommended Links:
