home / russian-ads

display_ads (view)

Data source: simonw/russian-ira-facebook-ads-datasette

58 rows where an ad_target was people_who_match:interests:Immigration

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1271 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1737 215 https://www.facebook.com/Stop-AI-896610653786585/ If you want to save America, you're a part of us. Like to join! 13.37152 835.72 RUB 2016-04-13T07:48:07-07:00  
1272 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 13188 2179 https://www.facebook.com/Stop-AI-896610653786585/ If you want to save America, you're a part of us. Like to join! 131.19776000000002 8199.86 RUB 2016-05-05T03:27:06-07:00  
1275 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Illegal immigration 0 0 https://www.facebook.com/Stop-Al-896610653786585/ Illegal immigrant invasion became the problem of gigantic proportions. More than 18 million illegal immigrants are currently tearing America apart one piece at a time. This unstoppable force is polluting our land, stealing ourjobs and receiving insane amounts money for that. 5% of population is committing 40% of all crimes in America. 65% of all drugs are coming through the Mexican border. No good comes from these people. Without them USA would be a lot better. It is just a simple fact. 0.0 0.00 USD 2016-05-05T03:35:49-07:00 2016-05-07T03:29:18-07:00
1276 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Conservatism 89 2 https://www.facebook.com/Stop-AI-896610653786585/ They take yourjob and money, there is nothing good in illegal immigration! Join! 0.56 35.00 RUB 2016-01-14T05:19:41-08:00  
1282 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 847 82 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 7.017600000000001 438.60 RUB 2016-04-13T07:47:50-07:00  
1283 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 19223 2335 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 111.89775999999999 6993.61 RUB 2016-05-05T03:27:06-07:00  
1290 location:United States, age:18 - 65+, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Human migration, people_who_match:interests:Illegal immigration, people_who_match:interests:Emigration 1793 432 https://www.facebook.com/Stop-AI-896610653786585/ Parasite is an organism that lives in or on another organism and benefits by deriving nutrients at the host's expense. About 20 million parasites live in the United States illegally. They exploit Americans and give nothing in return. Isn't it time to get rid of parasites that are destroying our country? 8.0 500.00 RUB 2016-05-05T03:34:37-07:00 2016-05-07T03:30:14-07:00
1294 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Conservatism 108 3 https://www.facebook.com/Stop-AI-896610653786585/ We are against illegal immigration! Press like tojoin! 0.6569600000000001 41.06 RUB 2016-01-14T05:20:21-08:00  
1297 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Conservatism 100 2 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants! 0.0 0.00 USD 2016-01-14T05:15:47-08:00  
1316 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Conservatism 249 11 https://www.facebook.com/Stop-AI-896610653786585/ Facts and news about refugees your government doesn’t want you to know. Join! 1.4512 90.70 RUB 2016-01-14T05:20:51-08:00  
1322 location:United Kingdom, United States, excluded_connections:Exclude people who like Stop A.|., age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Conservatism 123 5 https://www.facebook.com/Stop-AI-896610653786585/ News is telling you enough about good refugees. We take on bad ones. 2.04368 127.73 RUB 2016-01-14T05:16:25-08:00  
1325 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 12834 3051 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 185.62896 11601.81 RUB 2016-04-13T07:46:57-07:00  
1326 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 91603 18259 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 832.3352 52020.95 RUB 2016-05-05T03:27:06-07:00  
1332 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Human migration, people_who_match:interests:Illegal, people_who_match:interests:Illegal immigration 3394 784 https://www.facebook.com/Stop-AI-896610653786585/ We are under attack. Even there is no open action the war has already started. The enemy is smart and ruthless. We are losing so far, because our leader is one of them. Obama has betrayed America and now he is just executing orders of his bosses. Obama was always a mere pawn in the hands of Arabian Sheikhs. His latest orders are just proving it. All these refugees, which we are about to take in, are soldiers with one simple goal. They are going to try to terrorize the nation until it agrees to convert. To win this war we need to gather our forces and elect a leader, who loves America as much as we do and is willing to do everything it takes to protect it. I believe that only Trump is strong enough to overpower this snake of an enemy and Choke it to death. We are at war gentlemen! We need to act fast! 8.0 500.00 RUB 2016-05-05T03:32:59-07:00 2016-05-07T03:30:29-07:00
1333 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-04-13T07:48:09-07:00  
1334 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1335 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 223 25 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 3.43104 214.44 RUB 2016-04-13T07:47:57-07:00  
1336 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1337 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-04-13T07:47:24-07:00  
1338 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1339 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-04-13T07:47:22-07:00  
1340 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1341 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 144 16 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 2.68752 167.97 RUB 2016-04-13T07:48:10-07:00  
1342 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1343 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/Stop-AI-896610653786585/ Close the borders until it's too late. Like to join! 0.028 1.75 RUB 2016-04-13T07:48:28-07:00  
1344 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1345 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.02432 1.52 RUB 2016-04-13T07:48:29-07:00  
1346 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1347 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 4 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.04096 2.56 RUB 2016-04-13T07:48:34-07:00  
1348 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1349 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.01056 0.66 RUB 2016-04-13T07:48:33-07:00  
1350 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1351 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/Stop-AI-896610653786585/ The nation without borders is not a nation at all. Like to join! 0.012 0.75 RUB 2016-04-13T07:47:21-07:00  
1352 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1353 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 3 0 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 0.04144 2.59 RUB 2016-04-13T07:46:51-07:00  
1354 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1355 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 20 2 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.40368000000000004 25.23 RUB 2016-04-13T07:47:22-07:00  
1356 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1357 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.016800000000000002 1.05 RUB 2016-04-13T07:48:32-07:00  
1358 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Close the borders until it's too late. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1359 no image location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.016 1.00 RUB 2016-04-13T07:48:09-07:00  
1360 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders If you want to save America, you're a part of us. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1361 no image location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-04-13T07:46:49-07:00  
1362 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/Stop-AI-896610653786585/ This page is dedicated to protection against illegal immigrants! Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1363 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 2 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.02688 1.68 RUB 2016-04-13T07:47:25-07:00  
1364 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders The nation without borders is not a nation at all. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1365 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-04-13T07:48:01-07:00  
1366 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  
1367 location:United States, excluded_connections:Exclude people who like Stop A.|., age:35 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:Politics 1 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.020640000000000002 1.29 RUB 2016-04-13T07:48:04-07:00  
1368 location:United States, excluded_connections:Exclude people who like Stop A.|., age:21 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Immigration, people_who_match:interests:The Invaders, people_who_match:interests:Politics 0 0 https://www.facebook.com/StopAlllnvaders Take care of our vets, not illegals. Like to join! 0.0 0.00 USD 2016-05-05T03:27:06-07:00  

Next page

Advanced export

JSON shape: default, array

CSV options:

CREATE VIEW display_ads AS 
        select ads.id,
            case when image is not null then
                json_object("img_src", "https://raw.githubusercontent.com/edsu/irads/03fb4b/site/" || image, "width", 200)
            else
                "no image"
            end as img,
            json_group_array(
                json_object(
                    "label", targets.name,
                    "href", "/russian-ads/display_ads?_target="
                        || urllib_quote_plus(targets.id)
                )
            ) as targeting,
            ads.impressions, ads.clicks, ads.url, ads.text,
            cast(case
                when ads.spend_currency == "RUB" then ads.spend_amount * 0.016
                else ads.spend_amount
            end as float) as spend_usd,
            ads.spend_amount, ads.spend_currency,
            ads.created, ads.ended
        from ads
            join ad_targets on ads.id = ad_targets.ad_id
            join targets on ad_targets.target_id = targets.id
        group by ads.id
        order by ads.id
Powered by Datasette · Query took 1167.831ms · Data source: simonw/russian-ira-facebook-ads-datasette