home / russian-ads

display_ads (view)

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

98 rows where an ad_target was interests:CollegeHumor sorted by clicks

id img targeting impressions clicks ▼ url text spend_usd spend_amount spend_currency created ended
1685 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/ oh 0.0 0.00 USD 2016-05-16T04:17:32-07:00 2016-05-17T04:17:31-07:00
1708 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 laughed morbidly at this, i need help 0.0 0.00 USD 2016-05-16T04:16:30-07:00 2016-05-17T04:16:30-07:00
1732 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/ What is life now 0.0 0.00 USD 2016-05-16T04:18:18-07:00 2016-05-17T04:18:17-07:00
1733 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/ It could also be someone stabbing you, and trying to kill ya too 0.0 0.00 USD 2016-05-16T04:15:43-07:00 2016-05-17T04:15:42-07:00
1766 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/ When you out in public and see your bf make eye contact with a girl 0.0 0.00 USD 2016-05-16T04:18:03-07:00 2016-05-17T04:18:02-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
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
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
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
1738 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 26 1 https://www.facebook.com/Memopolis-450474615151098/ As long as he has candy, I'd be fine with it 1.0667200000000001 66.67 RUB 2016-04-22T08:10:43-07:00 2016-04-25T08:10:43-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
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
1777 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 77 9 https://www.facebook.com/Memopolis-450474615151098/ What a savage 1.0286400000000002 64.29 RUB 2016-04-18T04:16:25-07:00 2016-04-21T04:16:23-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
1770 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 60 10 https://www.facebook.com/Memopolis-450474615151098/ What's a mehmeh 0.24080000000000001 15.05 RUB 2016-04-22T01:16:15-07:00 2016-04-25T01:16:14-07:00
1757 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 66 11 https://www.facebook.com/Memopolis-450474615151098/ Chun Li is THICK 0.3424 21.40 RUB 2016-04-11T08:46:20-07:00 2016-04-12T19:03:00-07:00
1739 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 61 12 https://www.facebook.com/Memopolis-450474615151098/ The people that want to get rid of racism always bring in more racism. 0.25536000000000003 15.96 RUB 2016-04-22T00:20:56-07:00 2016-04-25T00:20:55-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
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
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
1871 location:United States, interests:Imgur, interests:CollegeHumor, interests:Reddit, age:18 - 50, language:English (US), placements:Instagram Feed 3330 25 https://www.instagram.Com/nuts.news/ Hello friends! Enjoy us daily! All the funniest memes and actual news. Click Learn More! Nuts News ( @nuts.news) Funnylnst 15.3208 957.55 RUB 2015-12-01T04:32:19-08: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
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
1756 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 190 42 https://www.facebook.com/Memopolis-450474615151098/ I will evolve into my feline form. 1.6 100.00 RUB 2016-04-12T08:30:26-07:00 2016-04-13T08:30:26-07:00
1874 location:United States, interests:CollegeHumor, interests:Government, interests:Politics and social issues, age:18 - 65+, language:English (US), placements:Instagram Feed 11932 45 https://instagram.Com/nuts.news/ Funnylnst 22.68128 1417.58 RUB 2015-11-03T02:32:45-08: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
1712 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 673 47 https://www.facebook.com/Memopolis-450474615151098/ What did you do to my drink? 1.6 100.00 RUB 2016-04-11T06:39:16-07:00 2016-04-12T06:39:16-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
1754 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 466 52 https://www.facebook.com/Memopolis-450474615151098/ Welcome to America! 1.6 100.00 RUB 2016-04-13T00:29:58-07:00 2016-04-14T00:29:58-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
1755 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 497 58 https://www.facebook.com/Memopolis-450474615151098/ When you have 3 Bentley steering wheel In a Jeep. 1.6 100.00 RUB 2016-04-13T00:29:32-07:00 2016-04-14T00:29:31-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
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
1751 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 469 64 https://www.facebook.com/Memopolis-450474615151098/ Pickleboy and Bridgette 1.6 100.00 RUB 2016-04-15T07:13:30-07:00 2016-04-18T07:13:29-07:00
1771 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 325 64 https://www.facebook.com/Memopolis-450474615151098/ Savage 1.5455999999999999 96.60 RUB 2016-04-22T00:21:15-07:00 2016-04-25T00:21:15-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
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
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
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
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
1740 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 399 71 https://www.facebook.com/Memopolis-450474615151098/ When you fart hella loud and u new 1.34608 84.13 RUB 2016-04-22T00:03:19-07:00 2016-04-25T00:03:19-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
1772 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 387 75 https://www.facebook.com/Memopolis-450474615151098/ There is the Chair where I put everything. 1.44384 90.24 RUB 2016-04-20T02:44:55-07:00 2016-04-23T02:44:54-07:00
1746 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 554 77 https://www.facebook.com/Memopolis-450474615151098/ Me IRL 1.6 100.00 RUB 2016-04-19T00:04:53-07:00 2016-04-22T00:04:52-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/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 2899.293ms · Data source: simonw/russian-ira-facebook-ads-datasette