blog / archive
Data Pipeline
✎ 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
Data infrastructure
Case Study: Overcoming The 1 Million Event Limit in GA4 Without Upgrading to GA360
GA360 is a great tool, and for the enterprises that can afford and justify the cost, probably the best analytics tool they can invest…
Aug 8, 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
Data infrastructure
Case Study: Building and maintaining a Data Pipeline and Data Warehouse for the Enterprise
At Reflective Data, we've worked with companies big and small. This means we have seen all levels of maturity when it comes to the…
Sep 20, 2021 · 4 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
Data infrastructure
Case Study: Storing Google Analytics Data Within The European Union or Locally
Data protection and privacy rules are getting tougher all over the world. This is especially true for the European Union and even more so…
Mar 12, 2021 · 5 min read
Data infrastructure
Case Study: Sending Data From Shopify and Google Analytics to BigQuery for More Advanced Analysis
Using Google Analytics Parallel Tracking and a custom data pipeline for Shopify, we managed to get all necessary data in BigQuery for more advanced…
Jan 25, 2021 · 4 min read
BigQuery
[Medium] Hit-Level Unsampled Google Analytics to BigQuery Without 360
Google Analytics and BigQuery, two tools that both the major players in their respective segments. Yet, there is no way to easily send raw…
Dec 30, 2020 · 2 min read
BigQuery
How to Query Google Analytics Data Using SQL
SQL is the most popular language for professionals to communicate with databases and query data. Google Analytics is the most popular tool for digital…
Oct 30, 2020 · 6 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.