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 created

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ▼ ended
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  
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  
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1753 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1706 167 https://www.facebook.com/Memopolis-450474615151098/ Why not all three? 3.2 200.00 RUB 2016-04-14T06:12:37-07:00 2016-04-15T06:12:37-07:00
1752 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6469 997 https://www.facebook.com/Memopolis-450474615151098/ 80, the picture of my soul, is a piece of art? 8.0 500.00 RUB 2016-04-15T00:08:39-07:00 2016-04-18T00:08: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
1778 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1851 192 https://www.facebook.com/Memopolis-450474615151098/ Unless payer 2 is top screen, then exceptions are made. 1.6 100.00 RUB 2016-04-15T08:16:00-07:00 2016-04-18T13:56:01-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
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
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
1776 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 8478 1659 https://www.facebook.com/Memopolis-450474615151098/ Stawp stawp 8.65056 540.66 RUB 2016-04-18T04:18:44-07:00 2016-04-24T12:18:00-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
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
1710 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6592 856 https://www.facebook.com/Memopolis-450474615151098/ Well it had me at the sleep part 8.648 540.50 RUB 2016-04-18T04:21:16-07:00 2016-04-24T12:21:00-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
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
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
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
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
1774 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1031 149 https://www.facebook.com/Memopolis-450474615151098/ But that ain't none of my business 1.6 100.00 RUB 2016-04-19T00:04:00-07:00 2016-04-22T00:04:00-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
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
1745 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11324 1409 https://www.facebook.com/Memopolis-450474615151098/ Life is so hard 9.424479999999999 589.03 RUB 2016-04-19T00:31:27-07:00 2016-04-24T14:31:00-07:00
1773 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 847 126 https://www.facebook.com/Memopolis-450474615151098/ It is technically PM 1.6 100.00 RUB 2016-04-19T08:02:06-07:00 2016-04-22T08:02:05-07:00
1743 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3553 376 https://www.facebook.com/Memopolis-450474615151098/ This kitchen is not the same without you 5.575520000000001 348.47 RUB 2016-04-20T02:44:31-07:00 2016-04-24T02:44:00-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
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
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
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
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
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
1741 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2629 238 https://www.facebook.com/Memopolis-450474615151098/ When you're getting roasted in a group Chat 4.44032 277.52 RUB 2016-04-21T02:20:17-07:00 2016-04-24T02:20:16-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

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