home / russian-ads

display_ads (view)

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

5 rows where an ad_target was people_who_match:interests:BIaokNewsoom

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
794 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIaokNewsoom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 64 1 https://www.facebook.com/WilliamsandKalvin/ Your voice counts! Here you can find news and videos about black community! 2.22336 138.96 RUB 2016-01-14T06:38:34-08:00  
808 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIaokNewsoom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 52 1 https://www.facebook.com/WilliamsandKalvin/ Your voice counts! Here you can find news and videos about black community! 0.0 0.00 USD 2016-01-14T06:38:43-08:00  
813 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIaokNewsoom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 48 0 https://www.facebook.com/WilliamsandKalvin/ Your voice counts! Here you can find news and videos about black community! 0.0 0.00 USD 2016-01-14T06:38:30-08:00  
855 location:United States, excluded_connections:Exclude people who like Williams&Ka|vin, age:18 - 45, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIaokNewsoom, people_who_match:interests:Black (Color), people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 48 0 https://www.facebook.com/WilliamsandKalvin/ Your voice counts! Here you can find news and videos about black community! 0.0 0.00 USD 2016-01-14T06:38:38-08:00  
910 no image location:United States, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, exclude:behaviors:Hispanic (US - All), exclude:behaviors:Hispanic (US - Spanish dominant), exclude:behaviors:Hispanic (US - English dominant), exclude:behaviors:Hispanic (US - Bilingual: English and Spanish), exclude:behaviors:Asian American (US), people_who_match:interests:BIaokNewsoom, people_who_match:interests:HuffPost Politics, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) 0 0 https://www.facebook.com/Williamsathalvin/ As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberation of Black Americans, the question is "who will keep his dream alive"? He saw the promise-Iand where blacks and whites live together in harmony and each of them given equal rights and privileges, freedom and justice. Today, we do not see this equality among blacks and whites in America. These rights and privileges, freedom and justice shouldn't be for some selected few but all! Thanks for watching, I'd like to hear from you; Click like, Share and Comment. Together we can make America a better place. https://www.youtube.com/watch?v=th|85XjHKc As we celebrate and reflect upon the birth of the great Martin Luther King Jr., a voice of the people and one who sacrificed his life for the total liberatio... WHO WILL BE THE NEXT MARTIN LUTHER KING JR? Williams&Ka|vin 0.0 0.00 USD 2016-01-19T03:47:57-08:00 2016-01-22T03:46:36-08: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 1274.959ms · Data source: simonw/russian-ira-facebook-ads-datasette