Get more out of your data.

Join for a weekly digest of real, no BS, full-stack digital marketing analytics help.
  • Popular on Vonn Data
All
Beginner Data Engineering
BigQuery SQL
Python
How to Export Your Universal Analytics (GA3) Data the Fastest & Easiest Way [w/ Free Templates Included]
May 6, 2024
Vonn
1:26 pm
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 2)
September 29, 2023
Vonn
10:13 am
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 1)
September 27, 2023
Vonn
10:30 am
What Are Python Lambda Functions?
September 14, 2023
Vonn
3:54 pm
How to Make a BigQuery Real-Time MTD Job Cost Monitoring Dashboard (Part 1): Setting Up the Data
April 17, 2023
Vonn
8:55 am
  • Latest on Vonn Data
image-44
How to Export Your Universal Analytics (GA3) Data the Fastest & Easiest Way [w/ Free Templates Included]
May 6, 2024
1:26 pm
Vonn
,
The Announcement Google has announced that all customers will lose access to Universal Analytics properties...
programming computer screen
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 2)
September 29, 2023
10:13 am
Vonn
This is Part 2 of extracting random jokes from an API and loading it into a BigQuery table via a data...
programming computer screen
A Beginner Data Engineer Project: Extract Random Jokes via API with Python (Part 1)
September 27, 2023
10:30 am
Vonn
In this Part 1 project, I’ll walk through creating a python script to extract random jokes from...
What Are Python Lambda Functions?
September 14, 2023
3:54 pm
Vonn
I learned python lambda functions from a codecademy.com tutorial – highly recommend. My definition: A...
Screenshot-2023-04-17-at-7.36
How to Make a BigQuery Real-Time MTD Job Cost Monitoring Dashboard (Part 1): Setting Up the Data
April 17, 2023
8:55 am
Vonn
,
In this part 1 post, we’ll go over Setting Up the Data: Creating a Sink: How to get BigQuery...
Man going up the stairs
3 Things You Need to Get Paid More
April 6, 2023
10:10 am
Vonn
1. Knowledge This is where you: Know what you know Know what you don’t know And you work...
How to Connect BigQuery with dbt
How to Connect BigQuery with dbt
March 29, 2023
10:00 am
Vonn
dbt is a great data modeling tool you can use to help you model GA4 data. This post will cover how to...
How to Model GA4 Data Easier in BigQuery with this Helpful Tool
How to Model GA4 Data Easier in BigQuery with this Helpful Tool
March 24, 2023
10:00 am
Vonn
Issues with modeling data strictly from inside BigQuery: What I found while modeling GA4 data in BigQuery...
When to Use IF NULL THEN 0 (How to Handle Null Values in SQL)
When to Use IF NULL THEN 0 (How to Handle Null Values in SQL)
March 15, 2023
10:00 am
Vonn
A couple of questions I’ve always had are: How are nulls handled and calculated when performing...
  • Browse All Categories
Beginner Data Engineering
GA4
BigQuery SQL
Python

Join Our Newsletter

Subscribe to receive our latest blog posts directly in your inbox!