home / russian-ads

display_ads (view)

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

9 rows where an ad_target was people_who_match:interests:Jesus Daily

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
6 location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 0 0 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 0.0 0.00 USD 2016-05-12T04:06:17-07:00  
7 no image location:United States, age:13 - 44, language:English (US), placements:Instagram Feed, people_who_match:interests:Christ's Commission Fellowship, people_who_match:interests:Jesus, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:Walk with Jesus, people_who_match:interests:The Bible (TV miniseries) 23408 54 https://www.facebook.com/Bat-240131319678646/ Conservative Christians. Pro—Iife/ gun/ police/ military. Follow! 45.89696 2868.56 RUB 2016-05-13T01:18:08-07:00  
2884 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:jesus love u, people_who_match:interests:I Am a Child of God, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 23244 2055 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Together we are a shining beacon of faithfulness! Join us and light your way to Jesus! 121.32096000000001 7582.56 RUB 2017-02-02T06:10:09-08:00  
2885 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:jesus love u, people_who_match:interests:I Am a Child of God, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 368065 28137 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Together we are a shining beacon of faithfulness! Join us and light your way to Jesus! Army Of Jesus 1425.29776 89081.11 RUB 2017-02-20T05:37:42-08:00  
2886 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:jesus love u, people_who_match:interests:I Am a Child of God, people_who_match:interests:Jesus Daily, people_who_match:interests:Knowing Jesus, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 19055 4469 https://www.facebook.com/savemeasap/ Our Lord is alive and He will never die for He is the truth, the way and the life! 8.0 500.00 RUB 2017-03-09T01:28:02-08:00 2017-03-10T01:28:02-08:00
2888 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Amenity, people_who_match:interests:Jesus Daily, and_must_also_match:interests:Jesus 277317 20426 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! 562.056 35128.50 RUB 2016-10-17T02:17:19-07:00  
2889 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:Amenity, people_who_match:interests:Jesus Daily, and_must_also_match:interests:Jesus 131913 5449 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! Army Of Jesus 383.1 23943.75 RUB 2016-12-08T00:30:32-08:00  
2893 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:News Feed on mobile devices, people_who_match:interests:Amenity, people_who_match:interests:Jesus Daily, and_must_also_match:interests:Jesus 0 0 https://www.facebook.com/Army-of-Jesus-1195795607160174/ At the Last Supper Jesus says: He said to them, “But now if you have a purse, take it, and also a bag; and if you don’t have a sword, sell your Cloak and buy one.” — Luke 22:36 What does that mean? Jesus always stood for peace and non-violence. But enemies often issued threats towards Him and His disciples. There's always was a risk for them to be arrested and subjected to a great violence, and be followed with rage and persecution; so that they might seem to stand in need of swords to defend them: the phrase is expressive of the danger they would be exposed to, and of their need of protection. And we, American Christians, should remember about it. Sometimes you have to arm yourself to protect your loved ones and friends. 0.0 0.00 USD 2016-10-17T02:14:28-07:00 2016-10-13T03:18:15-07:00
3001 location:United States, excluded_connections:Exclude people who like BIack_Baptist_church, age:18 - 65+, language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Martin Luther King, people_who_match:interests:Jr., people_who_match:interests:Baptism, people_who_match:interests:Black Church, people_who_match:interests:Jesus Daily, people_who_match:interests:Gospel 0 0 https://www.facebook.com/Black_|iberation_churCh-1160193507389202/ Hallelujah! Ministering and uniting all Black congregations Worldwide. Join our non denominational group! 0.0 0.00 USD 2016-10-18T04:42:28-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 1530.315ms · Data source: simonw/russian-ira-facebook-ads-datasette