<@U07FJ89LFFB> how much would it cost to use Bigqu...
# ask-ai
w
@brash-pillow-71627 how much would it cost to use Bigquery with the streaming function along with Growthbook?
b
A message from kapa.ai
The cost of using BigQuery with the streaming function alongside GrowthBook depends on several factors, including your data volume, query frequency, and how you configure your tables and queries. Key points from the knowledge sources: - Streaming Export in GA4: The streaming export option in GA4 sends event data to BigQuery within minutes, but it is only available for GA4 properties on Google Analytics 360 (the paid Enterprise version). This means you will incur additional costs for both GA4 360 and BigQuery streaming inserts, which are billed separately from standard batch exports. The standard (free) GA4 only supports daily exports, which are less costly but have a 24-hour delay in data availability. GrowthBook works with both daily and streaming tables, but you need to update your queries to use the
events_intraday_*
tables for streaming data. There is no mention of GrowthBook itself incurring extra costs for using streaming data, but the underlying BigQuery streaming costs will apply [GrowthBook and Google BigQuery (BQ)](https://docs.growthbook.io/kb/google-analytics/google-big-query-bq-troubleshooting). - BigQuery Query Costs: BigQuery charges based on the amount of data scanned per query. GrowthBook is designed to minimize costs by adding date filters to queries and supporting partitioned tables. You can further reduce costs by ensuring your tables are partitioned by date and that your queries only scan the necessary date ranges. GrowthBook also allows you to control how often queries are run (e.g., only when you manually refresh results), which can help manage costs [App > Metrics and Fact Tables](https://docs.growthbook.io/app/metrics#database-cost-optimization). - Typical Cost Ranges: For typical usage (e.g., 1 million events and 25,000 conversions per month), users report costs ranging from free to about $100 per month, depending on query frequency and data volume. However, this is for standard usage and may not include the additional costs associated with streaming inserts [Forum Conversation > T > 18902674](https://linen.growthbook.io/t/18902674/hi-anyone-know-the-average-cost-of-growthbook-with-ga4-bigqu). - Monitoring and Optimization: GrowthBook adds a label (
integration: "growthbook"
) to all BigQuery jobs it runs, making it easy to monitor and attribute costs specifically to GrowthBook queries. Enterprise features like Fact Table Query Optimization can further reduce costs by combining multiple metric queries into a single query [Configuring GrowthBook to work with BigQuery](https://docs.growthbook.io/guide/bigquery). Summary: - The main additional cost for streaming is from BigQuery's streaming insert pricing and the need for GA4 360. - Query costs depend on data scanned, which GrowthBook helps minimize. - Typical reported costs for standard usage are up to $100/month, but streaming may increase this, especially with high event volumes. - You can monitor and control costs by adjusting query frequency and using partitioned tables. If you need a precise estimate, you should: - Check your expected event volume and streaming insert costs in the [BigQuery pricing documentation](https://cloud.google.com/bigquery/pricing). - Monitor your actual usage using the
integration: "growthbook"
label in BigQuery. - Adjust GrowthBook's query frequency and table partitioning to optimize costs. If you need more detailed, scenario-specific pricing, the knowledge sources do not provide exact numbers for streaming usage, so you should consult Google's BigQuery pricing calculator and monitor your usage after setup.