blog / archive
BigQuery
✎ Written by humans. We love AI, but every article here is written by our top experts.
BigQuery
3 GA4 Pain Points That Parallel Tracking Solves: the 1M Export Cap, GA360 Costs and Sampling
Hit the 1 million event BigQuery export limit, find GA360 too expensive, or tired of sampled and modelled data in GA4? Here is what…
Oct 13, 2026 · 6 min read
BigQuery
How to Export GA4 Data to Snowflake, Redshift, S3 or Another Warehouse
GA4 is by far the most popular digital analytics platform out there. The landscape for data storage solutions is much more fractured, and therefore,…
Jul 1, 2026 · 3 min read
BigQuery
How To Export Over 1 Million Events From Firebase Analytics GA4 To BigQuery Without GA360
Many mobile apps generate well over 1 million Firebase Analytics events per day but the cost of GA360 is hard to justify. In this…
Feb 3, 2025 · 4 min read
BigQuery
Optimal GA4 Setup For High-Traffic Websites and Apps in 2025
Collecting close to or above 1 million events per day? Then you've probably realized that using the free version of GA4 you're hitting several…
Nov 19, 2024 · 6 min read
BigQuery
GA4 Is Not GDPR Compliant – Here’s How to Use GA4 in the EU Safely
Google Analytics 4 (GA4) is not yet fully GDPR compliant. Google is working to make GA4 compliant with the GDPR, but it is a…
May 30, 2023 · 3 min read
A/B testing
Export Experiment Data From Google Optimize – While You Still Can
Google Optimize and Optimize 360 will no longer be available after September 30, 2023. Your experiments and personalizations can continue to run until that…
Jan 24, 2023 · 4 min read
BigQuery
Increase Your Company’s Profits by Getting and Leveraging a Data Warehouse
Possible use cases for a data warehouse are virtually limitless and depend on what kind of business you run. In this article, I'm providing…
Aug 11, 2022 · 8 min read
BigQuery
How to Avoid Google Analytics 4 [GA4] BigQuery Export Quota Limit of 1 Million Hits
While the new version of Google Analytics, the GA4, comes with the native BigQuery export feature available in the free version and some of…
May 12, 2022 · 3 min read
BigQuery
Best Google Analytics Alternative for 2023
No doubt that Google Analytics is the most popular tool when it comes to website analytics. Even though it's free for most users, it…
Mar 24, 2022 · 9 min read
A/B testing
Measure Long-Term Metrics Like Customer Lifetime Value (LTV) Using Google Analytics
Long-term metrics like customer lifetime value (LTV) and churn can be so much more insightful and lead to better results when optimized for when…
May 25, 2021 · 8 min read
put it into practice
Run it yourself, or have our experts do it
the platform
Pipelines, dbt and exploration in one place
Reflective Data is our data platform: managed pipelines from hundreds of sources into your warehouse, hosted dbt with a semantic layer, and an AI data agent. Use all of it or just one part.
expert services
Senior specialists for your data stack
Analytics implementation, audits, A/B testing, BI and AI, delivered by the experts who write these articles. Vendor-neutral, for startups and enterprises.