home / russian-ads

display_ads (view)

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

15 rows where an ad_target was custom_audience:Lookalike (US, 1%) - newtestaudit

View and edit SQL

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
50 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 92618 6555 https://blackmattersus.com/ Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 215.33584 13458.49 RUB 2016-06-21T07:09:02-07:00  
51 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 12653 393 https://b|ackmattersus.com/?utm_source=facebook&utm_medium=Cpc&utm Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 18.69296 1168.31 RUB 2016-07-06T07:18:32-07:00  
63 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://b|ackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters 0.0 0.00 USD 2016-06-21T07:08:44-07:00  
98 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters This Is What Being “Confident In Ones Blackness” Means To Some White Conservatives Black Matters Life Expectancy For Black Americans Increase Black Matters Police Brutality Videos Change How Black Men Live Black Matters 0.0 0.00 USD 2016-06-23T06:07:51-07:00  
99 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:16 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 0 0 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Black Matters 0.0 0.00 USD 2016-06-23T06:11:47-07:00  
109 custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices 34545 2218 https://blackmattersus.com/ Get breaking news and analysis on the life of African American community in the US. Black Matters Justice? I don't think so! Black Matters 56.41088 3525.68 RUB 2016-06-23T06:05:12-07:00  
291 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9918 741 https://www.facebook.com/BlaCk-Matters-1579673598947501/ All Black rallies, meetings, and protests are now in one place. Search for a meetup in your area to attend. Create your own meetup and get it promoted to more than 300,000 people for free. BlackMattersUS has been organizing meetups all over the USA for some time now. Some of our meetups like “Not My Heritage” rally against the symbols of racism an NEW On BlackMattersUS: All Black Protest Meetups In One Place | Black Matters Black Matters 12.78848 799.28 RUB 2016-08-05T07:10:10-07:00 2016-08-08T07:10:05-07:00
292 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 8946 791 https://www.facebook.com/BlaCk-Matters-1579673598947501/ We take into account every piece of opinion you come up with. We believe in your exquisite views. Join us as we share our opinions on segregation (Blacks). Black voices must be echoed! Your opinion matters! “Discrimination is a hellhound that gnaws at Negroes in every waking moment of their lives to remind them that the lie of their inferiority is accepted as truth Take Part In Black Segregation Survey | Black Matters Black Matters 13.23248 827.03 RUB 2016-08-05T06:51:21-07:00 2016-08-08T06:51:19-07:00
293 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 11393 1591 https://www.facebook.com/blackmattersus/ A new BlackMattersUS tool gathers all the Black meetups in one place. Now you can keep track of and organize ALL the Black meetups in one place! We are glad to be the first and only platform that provides this opportunity. For those who want to make real Changes, we offer a convenient search of the upcoming and past events. For the organizers, we suggest the free promotion of your events to more than 300,000 of event-goers via all the social media! All copyrights remain with original owners. Now it is easy to search for a meetup in your area! 12.97728 811.08 RUB 2016-08-05T08:12:30-07:00 2016-08-08T08:12:29-07:00
294 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 9628 1890 https://www.facebook.com/BlaCk-Matters-1579673598947501/ "Maybe the most talented gymnast I’ve ever seen in my life," former gold medalist, Mary Lou Retton said A BIack-American teenage girl, Simone Biles is making history in the world of gymnastics. She is 3 times reigning world Champion and has 14 gold medals at the i Black Teen Wins More World Championship Medals Than Any American Woman | Black Matters Black Matters 9.616 601.00 RUB 2016-08-10T02:29:13-07:00 2016-08-11T02:29:11-07:00
295 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 8822 782 https://www.facebook.com/blackmattersus/ MOVE heroes need your support! Those who fought for Black rights were wrongfully sentenced to a maximum of 100 years in prison for the crime they never committed. They sacrificed their lives for our Chance to have a better future. Now they feel forgotten and think that their lives were spent in vain. Don't let them think that we forgot about theirjob and deeds. Let's unite and send them our message of support to jail. Take part in our flash mob: Create the message Post it with the hashtag #BMOVE9 Send us the link 13.871680000000001 866.98 RUB 2016-08-10T00:32:13-07:00 2016-08-11T00:32:11-07:00
296 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 12232 1298 https://www.facebook.com/BlaCk-Matters-1579673598947501/ FLASHMOB #BMOVE9: Send in your words of support to the fighters for Black lives, The Move Organization. You are the one who can restore the belief that their efforts were not useless. Back in 1985, a whole village inhabited by members of a Philadelphia-based black liberation group, the MOVE was totally destroyed by a bomb attack organized by Take Part In Flashmob: BE MOVE 9 | Black Matters Black Matters 16.0 1000.00 RUB 2016-08-09T07:38:53-07:00 2016-08-10T07:38:51-07:00
297 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3569 322 https://www.facebook.com/BlaCk-Matters-1579673598947501/ Every piece of opinion you give counts in our survey. Take part in our “Black business survey” today! “A man’s success in business today turns upon his power of getting people to believe he has something they want.” Gerland Stanley Powered byTypeform Thank yo Do You Support Black Business? | Black Matters Black Matters 6.09248 380.78 RUB 2016-08-10T08:30:22-07:00 2016-08-11T08:30:20-07:00
300 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 3 0 https://www.facebook.com/blackmattersus/ A new BlackMattersUS tool gathers all the Black meetups in one place. Now you can keep track of and organize ALL the Black meetups in one place! We are glad to be the first and only platform that provides this opportunity. For those who want to make real Changes, we offer a convenient search of the upcoming and past events. For the organizers, we suggest the free promotion of your events to more than 300,000 of event-goers via all the social media! All copyrights remain with original owners. Now it is easy to search for a meetup in your area! https://blackmattersus.oom/meetup/ 0.032799999999999996 2.05 RUB 2016-08-05T07:25:00-07:00 2016-08-08T07:24:58-07:00
301 no image custom_audience:Lookalike (US, 1%) - newtestaudit, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 0 0 https://www.facebook.com/blackmattersus/ A new BlackMattersUS tool gathers all the Black meetups in one place. Now you can keep track of and organize ALL the Black meetups in one place! We are glad to be the first and only platform that provides this opportunity. For those who want to make real Changes, we offer a convenient search of the upcoming and past events. For the organizers, we suggest the free promotion of your events to more than 300,000 of event-goers via all the social media! All copyrights remain with original owners. Now it is easy to search for a meetup in your area! https://blackmattersus.oom/meetup/ 0.0 0.00 USD 2016-08-05T06:52:42-07:00 2016-08-08T06:52:40-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/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 1370.528ms · Data source: simonw/russian-ira-facebook-ads-datasette