home / russian-ads

display_ads (view)

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

1 row where an ad_target was custom_audience:Lookalike (US, 1%) - People who like Being Patriotic

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
445 custom_audience:Lookalike (US, 1%) - People who like Being Patriotic, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices 5701 967 https://www.facebook.com/Being-PatriotiC-1601685693432389/ We must ensure the Dallas attack on police will never happen again. Most problems we face happen because we’ve stopped calling things by their names and the assassination of cops in Dallas was no exception. We’re hiding behind political correctness and denying the truth because we don’t want to ‘offend’ someone. And the truth is: a group of people calling their supporters to commit violence is not a peaceful group. A group of people coming to their opponent’s rallies and attacking peaceful people is a group of extremists. A group of people standing behind the attack on police is a group of terrorists. The Black Lives Matter are terrorists, and the sooner we admit it officially — the sooner this war on cops will end and people running a conservative ra||y won’t be afraid to be attacked by a hateful gang. Sign the petition to formally recognize Black Lives Matter as a terrorist organization: https://petitions.whitehouse.gov/petition/forma||y-recognize-bIaCk-Iives-matter- terrorist-organization 16.0 1000.00 RUB 2016-07-11T07:45:24-07:00 2016-07-12T07:45:22-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 1348.275ms · Data source: simonw/russian-ira-facebook-ads-datasette