home / russian-ads

display_ads (view)

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

99 rows where an ad_target was people_who_match:behaviors:Facebook access (browser): Chrome

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
3395 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:41:50-07:00  
3396 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3397 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 1060 4 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 5.6728000000000005 354.55 RUB 2016-05-12T01:52:43-07:00  
3398 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 10198 28 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 43.5272 2720.45 RUB 2016-05-13T00:04:16-07:00  
3399 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:42:14-07:00  
3400 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3401 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3402 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:42:11-07:00  
3403 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3404 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3405 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:42:06-07:00  
3406 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3407 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 354 1 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser Unlimited, free and rapid app for you - listen music online on ur Facebook! musicfb.info FaceMusic Stop A.|. 1.04688 65.43 RUB 2016-05-12T02:39:55-07:00  
3408 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser Unlimited, free and rapid app for you - listen music online on ur Facebook! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3409 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:41:55-07:00  
3410 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 481 2 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 2.43872 152.42 RUB 2016-05-12T01:49:12-07:00  
3411 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3412 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:41:42-07:00  
3413 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 277 1 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3414 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3415 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free music extension! Be online and listen anything u like! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:42:17-07:00  
3416 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free music extension! Be online and listen anything u like! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3417 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 737 3 https://musicfb.info/ Listen to your favorite music via “FaceMusic” absolutely legal and for free! Free online music player! Download now! musicfb.info FaceMusic Stop A.|. 7.10128 443.83 RUB 2016-05-12T01:50:48-07:00  
3418 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Listen to your favorite music via “FaceMusic” absolutely legal and for free! Free online music player! Download now! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3419 location:United States, age:13 - 30, gender:Male, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:free music, and_must_also_match:interests:Free software 0 0 https://musicfb.info/ Free music extension! Be online and listen anything u like! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:42:01-07:00  
3420 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Free music extension! Be online and listen anything u like! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:49:12-07:00  
3421 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 404 1 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T01:56:01-07:00  
3422 location:United States, age:14 - 17, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Free software Interests: Music 0 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-13T00:04:16-07:00  
3423 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Music Interests: Free software 0 0 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T02:01:04-07:00  
3424 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Spotify 0 0 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:21:55-07:00  
3425 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:25:50-07:00  
3426 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:24-07:00  
3427 location:United States, age:15 - 30, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 160 0 https://musicfb.info/ A tiny browser extension will help you to browse, listen and share any kind of music! Free online music library! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:43-07:00  
3428 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Music Interests: Free software 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T02:01:07-07:00  
3429 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Spotify 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:21:55-07:00  
3430 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:25:50-07:00  
3431 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:24-07:00  
3432 location:United States, age:15 - 30, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 221 0 https://musicfb.info/ Free online player! Just add in ur browser and jump in the world of free music! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:43-07:00  
3433 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Music Interests: Free software 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T02:01:09-07:00  
3434 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Spotify 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:21:55-07:00  
3435 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:25:50-07:00  
3436 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:24-07:00  
3437 location:United States, age:15 - 30, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ First online player for ur browser! Listen everything for free! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:43-07:00  
3438 location:United States, age:15 - 30, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 251 1 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Download free music player! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:32:04-07:00  
3439 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Music Interests: Free software 0 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T02:01:07-07:00  
3440 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Spotify 0 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:21:55-07:00  
3441 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:25:50-07:00  
3442 location:United States, age:15 - 25, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 0 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:24-07:00  
3443 location:United States, age:15 - 30, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Grooveshark, and_must_also_match:interests:Last.fm, and_must_also_match:interests:SoundCloud, and_must_also_match:interests:Vevo, and_must_also_match:interests:Shazam (service), and_must_also_match:interests:Google Play Music 181 0 https://musicfb.info/ Only for Chrome users! Any music via “FaceMusic” absolutely legal and for free! Free online music library! Download! musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T03:28:43-07:00  
3444 location:United States, age:15 - 25, gender:Female, language:English (UK), language:English (US), placements:News Feed on desktop computers, people_who_match:behaviors:Facebook access (browser): Chrome, and_must_also_match:interests:Music Interests: Free software 0 0 https://musicfb.info/ Free online player! Jump in the world of free music! Click and download for ur browser musicfb.info FaceMusic Stop A.|. 0.0 0.00 USD 2016-05-12T02:01:01-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 1306.849ms · Data source: simonw/russian-ira-facebook-ads-datasette