Skip to content
~/reflective_data

blog / bigquery

[Medium] Hit-Level Unsampled Google Analytics to BigQuery Without 360

By Silver Ringvee · Dec 30, 2020 · updated May 22, 2023 · 2 min read

BigQueryData PipelineGoogle AnalyticsMedium

Google Analytics and BigQuery, two tools that are both major players in their respective segments. Yet, there is no way to easily send raw hit-level data from one to another.

In this article, originally posted on medium.com, we’re going to walk through the reasons you might want to access raw Google Analytics data in BigQuery and a few solutions that will get you there.

***

Google Analytics is, without a doubt, the most popular tool in the digital analytics segment. Besides being the best tool for tracking e-commerce, content and lead-gen websites, with some modification you can use Google Analytics for tracking SaaS and other web apps as well.

While being a really powerful and flexible tool, Google Analytics, too, has a few shortcomings. Perhaps the biggest problem every advanced user faces is the fact that there is no way to access raw hit-level data. The second major issue with Google Analytics is related to sampling and data collection limits.

Now, let’s take a look at some of the ways you can overcome these shortcomings without spending a ton on Google Analytics 360 — a premium version of Google Analytics that, to some extent, also eliminates these issues.

PS! If you already have GA 360, these techniques will give you an even more robust and flexible tracking solution.

– Sampling in Google Analytics
– Ways to avoid sampling in Google Analytics
– Why do you even need the raw data
– How to get access to unsampled hit-level raw data
– What about the price

***

Read the full post on medium.com

newsletter.sh

Join 7,900+ people building with data and AI

Field notes from our experts on tracking, data pipelines, experimentation and what AI is changing in data work. One or two emails a month, no fluff.

// unsubscribe any time
author

written by

Silver Ringvee

Silver Ringvee is an expert in both traditional digital analytics and user behavior analysis. Besides analytics, Silver also has a strong experience in A/B testing and web development. Over the years, he has worked on over a hundred websites helping them become more profitable using various data-driven solutions.

We love AI, but this article was written by one of our experts.

discussion

0 comments

Leave a comment

Your email address will not be published.

put it into practice

Run it yourself, or have our experts do it

platform

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.

services

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.