3 ms·
Good call, I had that working a while ago but I forgot to include it in this version. You can derive it from the SQL-enabled version here: https://russian-ira-
by simonw 8y ago
Good call, I had that working a while ago but I forgot to include it in this version.
You can derive it from the SQL-enabled version here: https://russian-ira-facebook-ads-sql-allowed.now.sh/russian-ads-919cbfd?sql=select+sum%28spend_usd%29+from+display_ads%3B https://russian-ira-facebook-ads-sql-allowed.now.sh/russian-...
Gives $93,270
You can also break down by rubles v.s. USD: https://russian-ira-facebook-ads-sql-allowed.now.sh/russian-ads-919cbfd?sql=select+spend_currency%2C+sum%28spend_usd%29%2C+sum%28spend_amount%29+from+display_ads+group+by+spend_currency%3B https://russian-ira-facebook-ads-sql-allowed.now.sh/russian-...
The vast majority of the spend was in rubles.