Skip to content
~/reflective_data

blog / archive

Technical

✎ Written by humans. We love AI, but every article here is written by our top experts.

bigquery.md

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.md

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.md

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.md

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.md

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.md

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.md

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.md

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.md

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

ab-testing.md

A/B testing

Tracking Optimize Anti-Flicker Snippet Timeout in Google Analytics

If you have any experience with JavaScript-based A/B testing and/or personalization tools you know that flicker can be a real headache. In case your…

Sep 4, 2019 · 4 min read

get-started.sh

Tell us what you need. We'll scope it.

Pricing is tailored to your sources, volume and the parts of the platform you use. Request a demo or book a call with the team.