home / russian-ads

display_ads (view)

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

99 rows where an ad_target was interests:BuzzFeed

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
1779 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 410 59 https://www.facebook.com/Memopolis-450474615151098/ That's a hot five 1.6 100.00 RUB 2016-04-14T06:11:38-07:00 2016-04-15T06:11:38-07:00
1782 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 400 33 https://www.facebook.com/Memopolis-450474615151098/ Been there done that 1.20032 75.02 RUB 2016-04-11T08:45:29-07:00 2016-04-12T11:33:01-07:00
1783 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 575 70 https://www.facebook.com/Memopolis-450474615151098/ Parenting goals 1.59984 99.99 RUB 2016-04-11T06:39:05-07:00 2016-04-12T06:39:05-07:00
1787 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1310 214 https://www.facebook.com/Memopolis-450474615151098/ Gross. Why did u do it 1.6 100.00 RUB 2016-05-12T06:07:50-07:00 2016-05-13T06:07:49-07:00
1788 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 495 78 https://www.facebook.com/Memopolis-450474615151098/ RIP 1.26576 79.11 RUB 2016-04-22T06:49:20-07:00 2016-04-25T06:49:19-07:00
1789 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2079 245 https://www.facebook.com/Memopolis-450474615151098/ No sleep, grades are struggling, flat broke, stressed to the max. Homesick, just done adulting. That's basically everything you feel after your first year of college. 4.62608 289.13 RUB 2016-04-21T02:21:58-07:00 2016-04-24T02:21:57-07:00
1790 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1634 217 https://www.facebook.com/Memopolis-450474615151098/ That would turn me on. 4.6448 290.30 RUB 2016-04-21T02:21:42-07:00 2016-04-24T02:21:42-07:00
1791 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 473 79 https://www.facebook.com/Memopolis-450474615151098/ Sunday Bunday 1.44112 90.07 RUB 2016-04-20T02:45:58-07:00 2016-04-23T02:45:58-07:00
1792 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 739 94 https://www.facebook.com/Memopolis-450474615151098/ Then they ask u to stay late... 1.43152 89.47 RUB 2016-04-20T02:45:21-07:00 2016-04-23T02:45:21-07:00
1793 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3892 336 https://www.facebook.com/Memopolis-450474615151098/ Accurate asf 4.0 250.00 RUB 2016-04-14T06:12:15-07:00 2016-04-16T01:42:28-07:00
1794 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 978 77 https://www.facebook.com/Memopolis-450474615151098/ Technically he can't see the bacon. Well, who cares? 1.6 100.00 RUB 2016-04-13T00:30:20-07:00 2016-04-14T00:30:20-07:00
1795 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 460 57 https://www.facebook.com/Memopolis-450474615151098/ When you have a dream that you sucked at being a quarterback and wake up and realize that you still suck at being a quarterback 1.6 100.00 RUB 2016-04-13T00:29:08-07:00 2016-04-14T00:29:07-07:00
1806 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1159 265 https://www.facebook.com/Memopolis-450474615151098/ Better than Shakespeare 1.6 100.00 RUB 2016-05-06T04:15:13-07:00 2016-05-07T04:15:12-07:00
1807 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 409 49 https://www.facebook.com/Memopolis-450474615151098/ looks like snoop dog 1.4366400000000001 89.79 RUB 2016-04-20T02:46:25-07:00 2016-04-23T02:46:25-07:00
1808 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 848 125 https://www.facebook.com/Memopolis-450474615151098/ It ain't easy being Cheesy 1.6 100.00 RUB 2016-04-19T00:03:18-07:00 2016-04-22T00:03:18-07:00
1814 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 850 70 https://www.facebook.com/Memopolis-450474615151098/ Prehistoric 7.99488 499.68 RUB 2016-06-17T06:33:01-07:00 2016-06-18T06:33:00-07:00
1815 location:United States, interests:Entertainment, interests:BuzzFeed, interests:9GAG, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:13 - 45, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 28226 1135 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 68.52047999999999 4282.53 RUB 2016-06-17T06:31:04-07:00 2016-07-24T06:31:04-07:00
1818 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3625 285 https://www.facebook.com/Memopolis-450474615151098/ Can you smrell what the wok is cookin 8.0 500.00 RUB 2016-05-18T04:23:14-07:00 2016-05-19T04:23:13-07:00
1819 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ "Thx mim" 0.0 0.00 USD 2016-05-16T04:18:43-07:00 2016-05-17T04:18:42-07:00
1820 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ Haha- wait... Is he.... He's coming isn't he.... That motherbarker... 0.0 0.00 USD 2016-05-16T04:17:14-07:00 2016-05-17T04:17:13-07:00
1821 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ Hulk got his cousin pregnant 0.0 0.00 USD 2016-05-16T04:16:54-07:00 2016-05-17T04:16:53-07:00
1822 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1371 306 https://www.facebook.com/Memopolis-450474615151098/ Bu but but this is a guy 1.6 100.00 RUB 2016-05-06T04:14:47-07:00 2016-05-07T04:14:47-07:00
1823 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 52 15 https://www.facebook.com/Memopolis-450474615151098/ When there's no food vs. When mom brings food 0.23888 14.93 RUB 2016-04-22T00:04:25-07:00 2016-04-25T00:04:25-07:00
1824 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1674 219 https://www.facebook.com/Memopolis-450474615151098/ You think cause I'm a dog I don't know about the secret menu 4.42176 276.36 RUB 2016-04-21T02:19:26-07:00 2016-04-24T02:19:25-07:00
1825 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 691 64 https://www.facebook.com/Memopolis-450474615151098/ Why does everyone hate the yellow ones, they're not even bad 1.6 100.00 RUB 2016-04-14T06:10:40-07:00 2016-04-15T06:10:39-07:00
1834 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2757 494 https://www.facebook.com/Memopolis-450474615151098/   4.8 300.00 RUB 2016-05-12T06:08:06-07:00 2016-05-13T06:08:05-07:00
1835 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 56 9 https://www.facebook.com/Memopolis-450474615151098/   0.28416 17.76 RUB 2016-04-22T00:01:33-07:00 2016-04-25T00:01:32-07:00
1836 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 513 58 https://www.facebook.com/Memopolis-450474615151098/ kill meow 1.6 100.00 RUB 2016-04-19T00:01:47-07:00 2016-04-22T00:01:46-07:00
1841 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 912 124 https://www.facebook.com/Memopolis-450474615151098/ we need to talk 1.584 99.00 RUB 2016-04-15T08:16:22-07:00 2016-04-18T15:33:01-07:00
1845 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9779 1597 https://www.facebook.com/Memopolis-450474615151098/ Not that many cause we aren't on Twitter 11.200000000000001 700.00 RUB 2016-06-23T07:25:39-07:00 2016-06-24T07:25:37-07:00
1846 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ Bitch, it's not my fault you mad. I even asked and you didn't wanna tell me. 0.0 0.00 USD 2016-06-17T06:39:17-07:00 2016-06-20T06:39:16-07:00
1847 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ Patrick got some weird ass fingers 0.0 0.00 USD 2016-06-17T06:33:47-07:00 2016-06-20T06:33:46-07:00
1848 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 240 94 https://www.facebook.com/Memopolis-450474615151098/ But... But he's Asian 6.4 400.00 RUB 2016-06-17T06:38:53-07:00 2016-06-20T06:38:52-07:00
1849 location:United States, interests:Entertainment, interests:BuzzFeed, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 0 0 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 0.0 0.00 USD 2016-04-09T07:56:50-07:00  
1850 location:United States, interests:Entertainment, interests:BuzzFeed, interests:Hobbies and activities, excluded_connections:Exclude people who like Memopolis, age:13 - 40, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers 808 32 https://www.facebook.com/Memopolis-450474615151098/ Welcome to the City of memes - Memopolis. 5.2664 329.15 RUB 2016-04-09T07:57:42-07:00  
1853 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 262 40 https://www.facebook.com/Memopolis-450474615151098/ White people 1.39632 87.27 RUB 2016-05-18T04:24:12-07:00 2016-05-19T04:24:11-07:00
1854 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 364 69 https://www.facebook.com/Memopolis-450474615151098/ I swear Family Feud has the best nicknames for a dick 2.3000000000000003 143.75 RUB 2016-05-18T04:21:39-07:00 2016-05-19T04:21:37-07:00
1855 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ Most difficult shit ever 0.0 0.00 USD 2016-05-18T04:21:10-07:00 2016-05-19T04:21:09-07:00
1856 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ new meaning to fucking up the logo. 0.0 0.00 USD 2016-05-18T04:20:31-07:00 2016-05-19T04:20:29-07:00
1857 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/Memopolis-450474615151098/ I want bare titties but not bear titties 0.0 0.00 USD 2016-05-16T04:16:14-07:00 2016-05-17T04:16:13-07:00
1858 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 172 16 https://www.facebook.com/Memopolis-450474615151098/ *Then have to pee half way threw movie, but holds it so you don't miss anything* 1.3667200000000002 85.42 RUB 2016-04-11T08:36:10-07:00 2016-04-12T08:36:09-07:00
1859 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 428 46 https://www.facebook.com/Memopolis-450474615151098/ Corgi you the real mvp 1.6 100.00 RUB 2016-04-11T07:03:57-07:00 2016-04-12T07:03:57-07:00
1860 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 695 74 https://www.facebook.com/Memopolis-450474615151098/ "It still has a few more miles left" 1.6 100.00 RUB 2016-04-13T00:30:53-07:00 2016-04-14T00:30:52-07:00
1861 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 643 68 https://www.facebook.com/Memopolis-450474615151098/ Only 20,000 80 kids will get this 1.6 100.00 RUB 2016-04-11T08:45:46-07:00 2016-04-12T13:03:00-07:00
1862 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 531 68 https://www.facebook.com/Memopolis-450474615151098/ Right now. Show it to your parents/so/dog/whoever pays before you go shopping. 1.6 100.00 RUB 2016-04-11T06:38:46-07:00 2016-04-12T06:38:46-07:00
1863 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 117 16 https://www.facebook.com/Memopolis-450474615151098/   0.16128 10.08 RUB 2016-05-12T06:07:04-07:00 2016-05-13T06:07:03-07:00
1864 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4 0 https://www.facebook.com/Memopolis-450474615151098/ This Es Wut causes depression 0.0232 1.45 RUB 2016-05-06T04:13:42-07:00 2016-05-07T04:13:41-07:00
1866 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 25 2 https://www.facebook.com/Memopolis-450474615151098/ Who is talking I done see anyone 0.20528000000000002 12.83 RUB 2016-04-18T04:20:52-07:00 2016-04-21T04:20:51-07:00
1867 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 13 1 https://www.facebook.com/Memopolis-450474615151098/ Yes because being in debt is worse with a Child 0.0888 5.55 RUB 2016-04-15T08:17:00-07:00 2016-04-18T20:03:01-07:00

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/umd-mith/irads/master/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 1672.711ms · Data source: simonw/russian-ira-facebook-ads-datasette