If someone can post instructions, I’d be happy to follow them and make a copy as...

Sayrus · 2025-09-29T13:21:21 1759152081

For what it's worth, my own procedure:

1. Create a GCS bucket

2. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s...

3. For each table under google_political_ads, run the following query: SELECT * FROM `bigquery-public-data.google_political_ads.<TABLE>` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY) GROUP BY country;

3. Export as CSV in GCS

Another procedure that is probably better but requires BigTable is:

1. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s...

2. For each table, click Snapshot and set Snapshot time to Sep 23 (Sep 24 works as well)