👽 - viewfoil

will.stedden > bonkerfield

Viewfoil streams my online communication in one place. It's an experiment to test the limits of my personal transparency. You can connect with me on any of the social sites below.

Connect:

filter: 💡 🐦 🏟 👽 📺 ➿ 🐘💰 ⌛

👽

5/10/2020 08:21:00 PM

Taken from [Google Ad data on Bigquery](https://console.cloud.google.com/marketplace/details/transparency-report/google-political-ads?filter=solution-type:dataset&q=ad&id=0c422e45-5809-4373-b2f4-ce31204c2f4c) using this query: `SELECT a.advertiser_name, a.week_start_date, SUM(a.spend_usd) FROM bigquery-public-data.google_political_ads.advertiser_weekly_spend a INNER JOIN (SELECT advertiser_id FROM (SELECT advertiser_id, SUM(spend_usd)as total_2020 FROM bigquery-public-data.google_political_ads.advertiser_weekly_spend WHERE week_start_date > '2020-01-01' GROUP BY advertiser_id) ORDER BY total_2020 DESC LIMIT 50) c on a.advertiser_id = c.advertiser_id GROUP BY a.advertiser_name, a.week_start_date` tutorial on how to build Timeline/Vertical Streamgraphs here: [https://bonkerfield.org/2020/05/timeline-streamgraph-google-sheet/](https://bonkerfield.org/2020/05/timeline-streamgraph-google-sheet/) Code available Codepen: [https://codepen.io/stedn/pen/BaoxGwr](https://codepen.io/stedn/pen/BaoxGwr) Github Gist: [https://gist.github.com/stedn/ccd784c9c52ce76d01e1569cd60d213e](https://gist.github.com/stedn/ccd784c9c52ce76d01e1569cd60d213e)