Our Blog
Join for a weekly digest of real, no BS, full-stack digital marketing analytics help.
- Popular on Vonn Data
- Latest on Vonn Data
The Announcement
Google has announced that all customers will lose access to Universal Analytics properties...
This is Part 2 of extracting random jokes from an API and loading it into a BigQuery table via a data...
In this Part 1 project, I’ll walk through creating a python script to extract random jokes from...
I learned python lambda functions from a codecademy.com tutorial – highly recommend.
My definition:
A...
In this part 1 post, we’ll go over Setting Up the Data:
Creating a Sink: How to get BigQuery...
1. Knowledge
This is where you:
Know what you know
Know what you don’t know
And you work...
dbt is a great data modeling tool you can use to help you model GA4 data. This post will cover how to...
Issues with modeling data strictly from inside BigQuery:
What I found while modeling GA4 data in BigQuery...
A couple of questions I’ve always had are:
How are nulls handled and calculated when performing...
Introduction to GA4 Public Dataset in BigQuery
In this post, we’ll be using the GA4 public dataset...
In this post, we’ll provide a primer on BigQuery and GA4, why it’s beneficial, what are its...
With the new Google Analytics and Google’s decision to allow a direct integration between GA4 and...
Select From All Tables
SELECT * FROM `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_*`...
Pandas Resource Link
“Equal” is defined by having the same shape, same elements, in the...
From a ten-thousand foot view of data and analytics, there are 4 key areas to focus in:
Making visualizations
Structuring...