GA4 & BigQuery: Benefits, Drawbacks, and Cost
In this post, we’ll provide a primer on BigQuery and GA4, why it’s beneficial, what are its drawbacks, and costs to use it. What is BigQuery in GA4? BigQuery is a type of data warehouse solution running in the cloud, specifically on the Google Cloud Platform. With the new Google Analytics 4, Google is now […]
5 Learnings From Creating a Sessions Fact Table From GA4 Data in BigQuery SQL
With the new Google Analytics and Google’s decision to allow a direct integration between GA4 and BigQuery, a new world of possibilities has opened up for us. The direct integration allows us to export GA4 raw data into a BigQuery dataset, and from there, we can use SQL to model the data into a usable […]
BigQuery SQL & GA4: How to Query Multiple Tables Using _TABLE_SUFFIX
Select From All Tables Select From Specific Dates Select Only Yesterday’s Data Note: sometimes yesterday’s data may not always be fully exported yet from GA4 and loaded into your raw table. So you can do a “2 day delay load” by selecting only the data from 2 days ago: Select Data From 2 Days Ago
Python Pandas: How to Check if Two DataFrames or Series are Equal to Each Other
Pandas Resource Link “Equal” is defined by having the same shape, same elements, in the same order. If 2 Series, or columns are equal: If 2 DataFrames are equal:
4 Key Areas to Master in Data & Analytics
From a ten-thousand foot view of data and analytics, there are 4 key areas to focus in: Making visualizations Structuring & modeling data Doing analysis Building and operating machine learning models 1. Making visualizations This involves being able to communicate data to others, stakeholders, your boss, your team, yourself. How well can you create visualizations […]