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.
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.
The Ultimate Ads Dashboard
The Ultimate Ads Dashboard
Here's a Looker Studio dashboard template you can purchase and download on ByMarketers.
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.
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.
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.
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.
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!
29 June 2024
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.
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.