blog / archive
BigQuery
✎ Written by humans. We love AI, but every article here is written by our top experts.
A/B testing
Case Study: Solving The Discrepancy Between A/B Testing Tool, Google Analytics and Backend Data For a Large E-Commerce Business
Working with skewed data can be worse than having no data at all. This is why we're always promoting all sorts of analytics audits…
Jan 15, 2021 · 7 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
BigQuery
How to Avoid Google Analytics Sampling and Data Limits?
Google Analytics, while being by far the most popular tool in its segment, does have a few limitations that can make this, otherwise nearly…
Aug 25, 2020 · 9 min read
BigQuery
Making BigQuery a Single Source of Truth for Marketing Data Analysis
Is your marketing data currently under the control of multiple vendors and platforms? Do you have to mix together siloed data and reporting tools…
Jun 18, 2020 · 14 min read
BigQuery
Why Every Business Needs a Marketing Data Warehouse and How to Set One Up?
The number of marketing tools an average business uses has grown rapidly. Besides one or two analytics platforms there’re a few ads platforms, CRM,…
May 21, 2020 · 9 min read
BigQuery
How to Query and Analyze Google Analytics Data with BigQuery
BigQuery is an extremely powerful tool for analyzing massive sets of data. It's serverless, highly scalable and integrates seamlessly with most popular BI and…
Apr 15, 2020 · 9 min read
BigQuery
Unsampled Hit-Level Google Analytics Data Without 360
Google Analytics is a really good tool for marketing-focused digital analytics. And by far the most popular one in this segment. With some custom…
Mar 3, 2020 · 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.