Combining Ad Data using Dataform in Google Cloud Platform

Combining Ad Data using Dataform in Google Cloud Platform

In this post I'll be sharing how to combine various ad data sources into a single BigQuery table using Dataform in Google Cloud Platform. This uses fake dummy ad data.

Read more


Interactive Dashboard Wine Farms in the Western Cape

Interactive Dashboard: Wine Farms in the Western Cape

Having visited a couple of wine farms in the Western Cape recently, I thought it might be fun to visualize how many there were.

Read more


Ultimate Ads Dashboard Looker Studio template

The Ultimate Ads Dashboard

The Ultimate Ads Dashboard

Here's a Looker Studio dashboard template you can purchase and download on ByMarketers.

View the Ultimate Ads Dashboard on the ByMarketers website

Read more


200 Food Additives and their Legal Status in Canada, the EU, and the US

200 Food Additives and their Legal Status in Canada, the EU, and the US

Something I've been reading up on lately is the number of Food Additives in various food products. I was curious in the differences in regulations between Canada (where I live), the EU and the USA. I used ChatGPT to compile some data (which I hope is accurate but proceed with caution) and visualized it in an interactive Looker Studio report.

Read more


Mapping all WWE pay per view events in Looker Studio

In this post I'll show you a Looker Studio dashboard I've built that lets you view all of WWE's pay per view events over the last 40 years.

Read more


Mapping all Formula 1 Grand Prix Races

In this post I'll show you a data visualization showing all of the Formula 1 Grand Prix that have taken place over the years. I've built it in Looker Studio.

Read more


Looker Studio connection map

How to make a Looker Studio Connection Map

In this blog post I'll show you how to build a Connection Map in Looker Studio. A Connection Map is a type of Google Map in Looker Studio that allows you to map a line between two points on a map.

Read more


North American Sports Teams Data Visualization

All the different sports teams and leagues across the US and Canada had always seemed a bit overwhelming, so I decided to make a report in Looker Studio to visualize which teams from which leagues are in which cities. Hope you enjoy!

Read more

Four in One Analytics Looker Studio Dashboard Template

Four in One Analytics Looker Studio Dashboard Template

I recently released a new Looker Studio dashboard template on ByMarketers which includes Google Analytics, Search Console, Google Ads and YouTube Analytics data. ByMarketers is a site on which you can download many different digital marketing templates & resources.

Read more


Visualizing a young Africa and an aging World

Visualizing a young Africa and an aging World

In this post I'll be looking at data showing a young Africa and an aging world. The charts are based on World Bank Indicators data/ I used Looker Studio to connect to the dataset in BigQuery and visualized it.

Read more