will.stedden
>
bonkerfield
viewfoil
Viewfoil streams my online communication in one place. It's an
experiment
to test the limits of my personal transparency. You can post a public message to me with the form below or connect with me on social media.
Connect:
image/svg+xml
post a message
name
message
confirm human
private message
email
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)