Makes google’s political ad database actually useful
This is a series of scripts that takes Google’s political ad transparency data and makes the ad content searchable as, ironically, the world’s most powerful search company does not make their ad data searchable.
It can also takes the ad targeting information and map it to electorates, but this only works for postcodes at the moment so isn’t in the main group of scripts yet.
It is aimed at Australian content, but most of the scripts could be applied to all ad content if you’d like to use it elsewhere.
Get the data
The current output is a work-in-progress, but you can find the latest file here as gzipped csv or json