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
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
1704 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 6603 1145 https://www.facebook.com/Memopolis-450474615151098/ How the alligator be lookin at you when you fall in the pit 7.9864 499.15 RUB 2016-06-23T07:14:03-07:00 2016-06-25T10:52:00-07:00
1706 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5407 366 https://www.facebook.com/Memopolis-450474615151098/ Glasses make you 20% more attractive 8.0 500.00 RUB 2016-05-18T04:21:55-07:00 2016-05-19T04:21:53-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
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
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
1720 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 8562 1496 https://www.facebook.com/Memopolis-450474615151098/ When your mom describes you to her family 11.200000000000001 700.00 RUB 2016-06-23T07:27:00-07:00 2016-06-24T07:26:59-07:00
1721 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 4486 644 https://www.facebook.com/Memopolis-450474615151098/ That thing looks like Scrat off of Ice Age 10.48368 655.23 RUB 2016-06-23T07:24:34-07:00 2016-06-24T07:24:33-07:00
1723 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 2573 276 https://www.facebook.com/Memopolis-450474615151098/ Looks like he's stuck between a rock and a hard place 6.178560000000001 386.16 RUB 2016-06-23T07:14:42-07:00 2016-06-25T13:52:00-07:00
1731 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3454 228 https://www.facebook.com/Memopolis-450474615151098/ Getting an uber while drunk 4.8 300.00 RUB 2016-05-18T04:22:27-07:00 2016-05-19T04:22:26-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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1765 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 152 257 https://www.facebook.com/Memopolis-450474615151098/ Did you look down 6.4 400.00 RUB 2016-06-17T06:37:57-07:00 2016-06-20T06:37:55-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
1767 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1077 228 https://www.facebook.com/Memopolis-450474615151098/   1.6 100.00 RUB 2016-05-12T06:06:52-07:00 2016-05-13T06:06:51-07:00
1768 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 962 146 https://www.facebook.com/Memopolis-450474615151098/ Who else has done this more than 10 times? 1.6 100.00 RUB 2016-05-12T06:06:03-07:00 2016-05-13T06:06:02-07:00
1769 location:United States, interests:CollegeHumor, interests:BuzzFeed, interests:9GAG, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 1217 246 https://www.facebook.com/Memopolis-450474615151098/ Looks like an Apple mouse 1.6 100.00 RUB 2016-05-06T04:14:05-07:00 2016-05-07T04:14:04-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
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
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
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
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
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
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
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
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

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