blog / archive
Technical
✎ Written by humans. We love AI, but every article here is written by our top experts.
RD Platform
Why a Semantic Layer Is Essential for Giving AI Access to Your Data
AI can write SQL, but it cannot know what your numbers mean. A semantic layer defines every metric once, so people, dashboards and AI…
Oct 8, 2026 · 6 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 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
Data Pipeline
Six Key Components of an Analytics Data Pipeline
This blog post is aimed for anyone planning to build a data pipeline or upgrade their current setup. An end-to-end analytics data pipeline is…
Dec 10, 2019 · 5 min read
Google Analytics
How to Detect and Fix Duplicate Transactions in Google Analytics
Enhanced Ecommerce is one of the most powerful and flexible features of Google Analytics. Its flexibility, though, leaves a lot of room for errors…
Nov 7, 2019 · 4 min read
Data Visualization
Working with Google Analytics Data Using Python and Jupyter Notebooks
Python is a programming language with virtually limitless functionalities and one of the best languages for working with data. Jupyter Notebooks, on the other…
Oct 28, 2019 · 8 min read
Jupyter Notebook
Jupyter Notebooks in WordPress
While it might look like a normal WordPress blog post (like all the previous posts on our blog), you are actually looking at a…
Oct 12, 2019 · 5 min read
Google Analytics
Data You Should Be Tracking Using Google Analytics Custom Events
Out of the box, Google Analytics already tracks a bunch of really useful data points. What the default setup lacks, though, is context and…
Sep 26, 2019 · 7 min read
Google Analytics
Tracking Rage Clicks Using Google Tag Manager and Google Analytics
Visitors rage clicking on certain elements on your website is a good indicator of a UX error. For example, people may click on a…
Sep 17, 2019 · 5 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.