home / russian-ads

display_ads (view)

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

10 rows where an ad_target was and_must_also_match:interests:Jesus

id img targeting impressions clicks url text spend_usd spend_amount spend_currency created ended
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
2887 location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:on pages: News Feed on desktop computers, placements:Instagram Feed, placements:News Feed on mobile devices, placements:Right column on desktop computers, people_who_match:interests:Evangelism, people_who_match:interests:Catholicism, people_who_match:interests:Protestantism, and_must_also_match:interests:Jesus 1518 0 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Take up your cross and follow Jesus! 13.647680000000001 852.98 RUB 2016-10-14T08:09:03-07: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  
2890 location_living_in:United States, age:18 - 65+, placements:News Feed on desktop computers, placements:Right column on desktop computers, people_who_match:interests:jesus love u, people_who_match:interests:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 0 0 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! Army Of Jesus 0.0 0.00 USD 2017-01-10T02:20:28-08:00  
2891 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:| Have Decided to Follow Jesus, and_must_also_match:interests:Jesus 163358 15590 https://www.facebook.com/Army-of-Jesus-1195795607160174/ Let's stand united to defend our faith as an army of Jesus! Army Of Jesus 556.68128 34792.58 RUB 2017-01-10T02:20:56-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
2894 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:| Have Decided to Follow Jesus, 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 2017-01-10T02:20:28-08:00 2016-10-13T03:18:15-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 1254.666ms · Data source: simonw/russian-ira-facebook-ads-datasette