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 spend_usd

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1742 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 — 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 792 122 https://www.facebook.com/Memopolis-450474615151098/ Tbh I believe in you 1.40832 88.02 RUB 2016-04-20T02:45:42-07:00 2016-04-23T02:45:42-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
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
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
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
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
1749 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 651 83 https://www.facebook.com/Memopolis-450474615151098/ So excited for that time of year when rich LA girls pretend to be hobos who talk to the moon and stuff! 1.584 99.00 RUB 2016-04-18T04:21:38-07:00 2016-04-21T04:21:37-07:00
1750 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1113 130 https://www.facebook.com/Memopolis-450474615151098/ Word! 1.584 99.00 RUB 2016-04-18T04:20:26-07:00 2016-04-21T04:20:26-07:00
1775 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1138 132 https://www.facebook.com/Memopolis-450474615151098/ GOD I LOVE NOT HEARING ANYONE TALK ABOUT THEIR JOB OR LIFE OR FEELINGS 1.584 99.00 RUB 2016-04-18T04:23:34-07:00 2016-04-21T04:23:33-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
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
1711 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 633 81 https://www.facebook.com/Memopolis-450474615151098/ When you're not even at McDonald's because you don't have a girlfriend. You're just at home eating Cheez its out of your belly button. When a Cheez it falls out.... Don't 1.6 100.00 RUB 2016-04-14T06:11:19-07:00 2016-04-15T06:11:18-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
1734 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1203 205 https://www.facebook.com/Memopolis-450474615151098/   1.6 100.00 RUB 2016-05-12T06:08:29-07:00 2016-05-13T06:08:28-07:00
1735 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 677 122 https://www.facebook.com/Memopolis-450474615151098/ Right after the dick sucking competition 1.6 100.00 RUB 2016-05-12T06:07:31-07:00 2016-05-13T06:07:30-07:00
1736 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 977 196 https://www.facebook.com/Memopolis-450474615151098/   1.6 100.00 RUB 2016-05-12T06:06:22-07:00 2016-05-13T06:06:21-07:00
1737 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1499 310 https://www.facebook.com/Memopolis-450474615151098/ My Spirit animal 1.6 100.00 RUB 2016-05-06T04:15:44-07:00 2016-05-07T04:15:43-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
1747 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1473 229 https://www.facebook.com/Memopolis-450474615151098/ Like why not? 1.6 100.00 RUB 2016-04-19T00:04:35-07:00 2016-04-22T00:04:35-07:00
1748 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1053 126 https://www.facebook.com/Memopolis-450474615151098/ Furiousity Killed the Cat 1.6 100.00 RUB 2016-04-19T00:03:38-07:00 2016-04-22T00:03:37-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

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 1320.915ms · Data source: simonw/russian-ira-facebook-ads-datasette