Looking at Political Advertising on Google using BigQuery and Data Studio

Looking at Political Advertising on Google using BigQuery and Data Studio

So I wanted to build a report looking at Political Advertising on Google using the Google Transparency Report BigQuery dataset.

It’s an interesting data set showing the vast amounts spent on political advertising.

The Google Data Studio report showing Political Advertising in India, the EU / UK and the United States.

Below is the Google Data Studio dashboard. There are three seperate pages. The first shows the US, the second shows India and the final page shows the EU and UK. Currently these are the only three regions with data available.

Below are screenshots showing part of each page.

Below is a screenshot showing Google Political Advertising in the United States. Notice the the amount spent by MIKE BLOOMBERG 2020 INC which is an astronomical $62 million on 64,243 creatives.

Political Advertising in the United States.

Below is a screenshot showing Google Political Advertising in India.

Google Advertising in India.

Below is a screenshot showing Google Political Advertising in the European Union and the United Kingdom.

European Union and the United Kingdom screenshot.

A second table in the report shows each creative. Below it shows the number for the US. You can see there are over 300 thousand of them.

a list of advert creatives from google bigquery public dataset

If you click on the URL link you will see what the ad contained. Below is the top ad in the image above for Mike Bloomberg’s 2020 election campaign.

A screenshot of a Mike Bloomberg video advert from the political advertising bigquery data set

Below is an image ad from the Civic Coalition political party in Poland. It is from the data the European Union and United Kingdom.

An ad from the European Union.

Google Transparency report website

You can also take a look at some of the data on the Google Transparency report website. It gives some context to the data and purpose of making it public. They also have a list of Frequently Asked Questions about the data.

Political advertising in the European Union and the United Kingdom, United States and India - Google Transparency report

The BigQuery public dataset

This Advertising data is available on Google BigQuery in the Public Datasets.

This Political Advertising data is available on Google BigQuery in the Public Datasets.

You can access it using the BigQuery data connector in Google Data Studio.

Download Google Data Studio Templates

If you’d like to download one of my Google Data Studio reports as a template to use for your own data, you can visit Data Studio Templates and purchase one.

Google Data Studio Templates

My Other Blog Posts

If you liked this post you might enjoy some of my other blog posts. These focus mainly on analytics and data visualization.

Do NOT follow this link or you will be banned from the site!