home / russian-ads

display_ads (view)

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

1 row where an ad_target was exclude:multicultural_affinity:Hispanic (US — English dominant)

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
832 location:United States, excluded_connections:Exclude people who like Williams&Kalvin, age:18 - 51, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:multicultural_affinity:Hispanic (US - All), exclude:multicultural_affinity:Hispanic (US - Spanish dominant), exclude:multicultural_affinity:Hispanic (US — English dominant), exclude:multicultural_affinity:Hispanic (US — Bilingual), exclude:multicultural_affinity:Asian American (US), people_who_match:interests:National Museum of American History, people_who_match:interests:Stop Racism”, people_who_match:interests:Malcolm X Memorial Foundation, people_who_match:interests:Maya Angelou, people_who_match:interests:Mumia Abu- Jamal, people_who_match:interests:The Raw Story or mother jones, people_who_match:interests:Multicultural Affinity: African American (US) 6508 1240 https://www.facebook.com/WiIliamsKalvin-788980617892144/ BLACK DOLLARS MATTER While Black activists are trying to strict American government’s attention by organizing protests, Black bank owners urge Black Americans to transfer money into their banks. A few days ago there were started the #MoveYourMany campaign which the main goal is to demonstrate the value of Black lives within America. At the request of rapper Killer Mike, over 8,000 people have transferred their money into BIack—owned banks in the last 5 days. 50 years ago Martin Luther King Jr. requested Blacks to replace their funds from non-Black banks to BIack-owned institutions which would help to empower and advance Black community. The best way to fight the system is to break its capitalist back which is why it is important for Blacks to invest in ourselves! 8.0 500.00 RUB 2016-07-21T09:17:51-07:00 2016-07-22T09:17:50-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 1293.412ms · Data source: simonw/russian-ira-facebook-ads-datasette