Data source: simonw/russian-ira-facebook-ads-datasette
This data as JSON, CSV (advanced)
| id | img | targeting | impressions | clicks | url | text | spend_usd | spend_amount | spend_currency | created | ended |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | |
location_living_in:United States, interests:News broadcasting, interests:Political party, interests:Breaking news, interests:Politics and social issues, age:18 - 51, language:English (US), placements:Instagram Feed | 358 | 6 | https://instagram.Com/us_daily/ | Instgogogo | 2.5796799999999998 | 161.23 | RUB | 2015-10-25T06:28:33-07:00 | 2015-10-27T23:59:00-07:00 |
| 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 | |
| 10 | |
location:United States, interests:United States Senate, interests:Election, interests:Government, interests:Politics, age:18 - 65+, language:English (US), placements:Instagram Feed | 1625 | 11 | https://instagram.Com/gov_spending/ | Unbelievable amount of the US government's waste. Join us to learn more about Goverment spending statistics! The US Gov Spending Stats Instalol | 10.59824 | 662.39 | RUB | 2015-11-16T05:49:20-08:00 | |
| 12 | no image | location:United States, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Martin Luther King, people_who_match:interests:Black Power, people_who_match:interests:Black Arts Movement, people_who_match:interests:Fight the Power, people_who_match:interests:Black Panther Party, people_who_match:interests:Afrocentrism, people_who_match:interests:My Black is Beautiful, people_who_match:interests:Black is beautiful, people_who_match:interests:Malcolm X, people_who_match:interests:HuffPost Black Voices | 44111 | 625 | https://www.facebook.com/Bat-240131319678646/ | It's time for us to understand that we do deserve all best. It's time for our people to stand up and use all the opportunities of this life. Follow black pride us, if you agree! | 78.29952 | 4893.72 | RUB | 2016-08-17T04:17:52-07:00 | |
| 14 | |
location:United States, interests:United Nations Assistance Mission in Afghanistan, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed | 1598 | 10 | https://instagram.Com/veterans_us/ | This military campaign is very ambiguous given that it has cost nearly 2,500 American lives and hundreds of billions of dollars. The goal was to "disrupt the use of Afghanistan as a terrorist base of operations." Well, the intervention deprived aI-Qaida of a sanctuary. But aI-Qaida — even after its leader Osama bin Laden was killed by US. commandos — has spawned cells elsewhere and inspired other extremists in Syria and Iraq. And now ISIS is rising as the most powerful terrorist organisation in the world. So, the question is whether it's worth to risk the lives of thousands of American soldiers for the mission that hardly can be called successful? It seems that Obama should review his military strategy without delay.Joih us! Veterans USA ( @veterans GovSpending | 10.55264 | 659.54 | RUB | 2015-11-16T05:17:56-08:00 | |
| 15 | |
location:United States, interests:Tax, interests:Republican Party (United States), age:20 - 65+, language:English (US), placements:Instagram Feed | 1614 | 12 | https://instagram.Com/gov_spending/ | And what would you Choose if u were a president: to create 11200 military- related jobs or to create 26700 jobs in education? Join us! Learn more! The US Gov Spending Stats Instalol | 9.54608 | 596.63 | RUB | 2015-11-17T07:07:36-08:00 | |
| 16 | |
location:United States, age:14 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Wounded Warrior Project, people_who_match:interests:Support our troops, people_who_match:interests:Veterans, people_who_match:interests:AMVETS, people_who_match:interests:Disabled American Veterans, people_who_match:interests:Chris Kyle, people_who_match:interests:Supporting Our Veterans, and_must_also_match:interests:Paralyzed Veterans of America, and_must_also_match:interests:Veterans Day, and_must_also_match:interests:Wounded Warrior Project, and_must_also_match:interests:Support our troops, and_must_also_match:interests:Veterans, and_must_also_match:interests:AMVETS, and_must_also_match:interests:United States Army Reserve, and_must_also_match:interests:Patriotism, and_must_also_match:interests:Disabled American Veterans, and_must_also_match:interests:The Veterans Site, and_must_also_match:interests:Chris Kyle, and_must_also_match:interests:Supporting Our Veterans | 21093 | 53 | https://www.instagram.Com/veterahs_us/ | A Wounded Warrior and his service dog. Support our Veterans - Follow! The US Gov Spending Stats Instalol | 34.10304 | 2131.44 | RUB | 2016-05-12T02:37:39-07:00 | |
| 17 | |
location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed | 1872 | 2 | https://instagram.Com/veterans_us/ | What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending | 5.86256 | 366.41 | RUB | 2015-11-18T02:43:22-08:00 | 2015-11-21T10:28:00-08:00 |
| 18 | |
location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed | 0 | 0 | https://instagram.Com/veterans_us/ | What do you know about PTSD? There is no greater agony. PTSD affects a person's memory, emotional responses, intellectual processes and nervous system. Nearly 31% of veterans fight this agony every day. Do you want to learn more? Click here! Veterans USA ( @veterans GovSpending | 0.0 | 0.00 | USD | 2015-11-19T05:18:16-08:00 | 2015-11-21T10:28:00-08:00 |
| 19 | |
location:United States, interests:Homeless shelter, politics:US politics (liberal), politics:US politics (moderate), age:18 - 65+, language:English (US), placements:Instagram Feed | 2115 | 8 | https://instagram.Com/gov_spending/ | Who will save the Children? Click Learn more! The US Gov Spending Stats Instalol | 15.6504 | 978.15 | RUB | 2015-11-19T05:35:36-08:00 | |
| 20 | |
location:United States, interests:Patriotism, behaviors:facebook_access_(mobile):all mobile devices, age:14 - 65+, language:English (US), placements:Instagram Feed | 514 | 0 | https://www.instagram.Com/veterahs_us/ | Click Learn More if you really love your country! A small puppy wandered up to US. Marines from Alpha Company. After following the Marines numerous miles, a soft hearted Marine picked the puppy up and carried the puppy in his drop pouch. Veterans USA ( @veterans GovSpending | 0.0 | 0.00 | USD | 2015-12-16T04:26:55-08:00 | |
| 22 | |
location:united_states:Chicago (+40 km) Illinois, behaviors:African American (US), age:18 - 65+, language:English (US), placements:Instagram Feed | 9555 | 32 | https://www.instagram.com/black_america_today/ | Click learn more! See the latest breaking news photos and videos! Black America Blacklivessss | 24.80656 | 1550.41 | RUB | 2015-12-01T07:37:28-08:00 | |
| 23 | |
location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed | 10785 | 6 | https://www.facebook.com/GovSpending-1651761351759857/ | TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! | 12.897440000000001 | 806.09 | RUB | 2016-04-19T08:23:46-07:00 | |
| 24 | |
location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed | 77759 | 9 | https://www.facebook.com/GovSpending-1651761351759857/ | TAG YOUR PHOTOS WITH #TXagainst Send us the reason why don't you want illegals in Texas. Comments, photos, and videos are welcomed! | 105.892 | 6618.25 | RUB | 2016-04-20T00:07:11-07:00 | |
| 25 | |
location:United States, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed | 3970 | 35 | https://instagram.Com/veterans_us/ | Homeland of brave. Support our veterans! Join us! Veterans USA GovSpending | 22.4288 | 1401.80 | RUB | 2015-11-09T05:01:08-08:00 | |
| 26 | |
location:united_states:Latitude 38.89 Longitude -77.03 Washington (+16 km) District of Columbia, location:united_states:Gallup (+40 km) New Mexico, interests:Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed | 1721 | 6 | https://www.instagram.Com/veterans_us/ | Home of the Brave. Support our Veterans! Click Learn More! Veterans USA ( @veterans GovSpending | 14.37376 | 898.36 | RUB | 2015-12-01T05:51:31-08:00 | |
| 27 | |
location:United States, interests:Tea Party Patriots, interests:Justice, age:18 - 65+, language:English (US), placements:Instagram Feed | 2616 | 6 | https://instagram.Com/gov_spending/ | Why our government wastes $11 MLN per day on |S|L Instead of saving more than 1300 lives of vets. Why do we engage in another conflict when we have so many unsolved problems in the US? It is a shame that our vets are treated so badly. They do not receive proper health care and unemployment benefits. They do not receive the respect they deserve. I do not want our government to create new veterans in such conditions. Join us for more statistics! Click learn more! The US Gov Spending Stats Instalol | 7.473920000000001 | 467.12 | RUB | 2015-11-18T03:33:41-08:00 | 2015-11-19T08:26:00-08:00 |
| 28 | |
location:United States, interests:Tax, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed | 15398 | 46 | https://www.instagram.Com/gov_spending/ | How to know the truth? Click learn more! Wouldn't it be better to solve the internal problems first? The US Gov Spending Stats Instalol | 33.12672 | 2070.42 | RUB | 2015-12-16T06:45:58-08:00 | |
| 29 | |
location:United States, interests:Patient Protection and Affordable Care Act, interests:Supporting Our Veterans, age:18 - 65+, language:English (US), placements:Instagram Feed | 3527 | 33 | https://instagram.Com/veterans_us/ | What do you know about PTSD? Do you know that US Military deaths since 1999 count 6,904, while veterans suicides since 1999 account for 128,480? We'are losing 18 times more warriors in Civilian life than on the battlefields! Learn more! Follow us! Veterans USA ( @veterans GovSpending | 24.09936 | 1506.21 | RUB | 2015-11-12T04:38:35-08:00 | |
| 30 | |
location:United States, interests:Independence, interests:Patriotism, age:18 - 65+, language:English (US), placements:Instagram Feed | 0 | 0 | https://instagram.Com/veterans_us/ | Click learn more! People don't want to look at the homeless. But maybe they will look at, or think about, or support dealing with homelessness once they know that 12% of the homeless adult population are veterans. Join us! Veterans USA ( @veterans GovSpending | 0.0 | 0.00 | USD | 2015-11-19T05:20:22-08:00 | 2015-11-21T10:28:00-08:00 |
| 31 | |
location:United States, age:13 - 35, language:English (UK), language:English (US), placements:Instagram Feed, people_who_match:interests:Afro—American religion, people_who_match:interests:Malcolm X | 23670 | 235 | https://www.instagram.com/black_america_today/ | Quiz from EBONY magazine April 1952. Which is Negro? Which is White? Passing for white is a direct consequence of how race works in America. Because of the One Drop Rule if you look at all part black African you are seen as “black” by “whites” and suffer all the racism that goes with that. Click "Learn More" Black America ( @black Blacklivessss | 64.64272 | 4040.17 | RUB | 2016-03-11T04:54:05-08:00 | |
| 32 | |
location:united_states:Alabama, location:united_states:Arkansas, location:united_states:Florida, location:united_states:Georgia, location:united_states:Louisiana, location:united_states:Mississippi, location:united_states:North Carolina, location:united_states:South Carolina, location:united_states:Tennessee, location:united_states:Texas, location:united_states:Virginia, age:18 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:Confederate Flag, people_who_match:interests:Flags of the Confederate States of America, people_who_match:interests:confederate states america, people_who_match:interests:United Daughters of the Confederacy, people_who_match:interests:Confederate States of America, people_who_match:interests:Sons of Confederate Veterans, people_who_match:interests:Confederate States Army, people_who_match:interests:Robert E. Lee, people_who_match:interests:Southern United States, people_who_match:interests:Redneck Social Club | 12727 | 375 | https://www.instagram.com/south_united/ | Heritage not hate y'all! Our flag has nothing to do with racism! The Federal Government shouldn’t be able to dictate what we can and cannot do. Go follow Confederate page #1 on Instagram south united if you are proud of our southern heritage. God bless Dixie! Confederate page #1 on Instagram! No racism, no hate! The south will rise again! https://twitter.com/March_for_Trump South United GovSpehding | 49.700480000000006 | 3106.28 | RUB | 2016-08-18T08:31:16-07:00 | |
| 33 | |
location:united_states:Massachusetts, interests:Liberalism, age:18 - 65+, language:English (US), placements:Instagram Feed | 2404 | 6 | https://instagram.Com/gov_spending/ | Unbelievable amount of the US government's waste. Click Learn More! The US Gov Spending Stats GovSpending | 15.200000000000001 | 950.00 | RUB | 2015-12-01T05:57:42-08:00 | |
| 34 | |
location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Conservatism, people_who_match:interests:Veterans Day, people_who_match:interests:Tea Party Patriots, people_who_match:interests:Veterans, people_who_match:interests:Republican Party (United States), people_who_match:interests:Supporting Our Veterans | 0 | 0 | https://www.instagram.Com/veterans_us/ | A Wounded Warrior and his service dog. Support our Veterans - Follow! Black America ( @black Instalol | 0.0 | 0.00 | USD | 2016-05-12T02:31:30-07:00 | |
| 35 | |
location:United States, age:13 - 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics | 0 | 0 | https://www.instagram.Com/veterahs_us/ | There are some people who will always support you! And unfortunately, the VA is not on the list. There are numerous examples of disgusting treatment of our Veterans by the VA employees. And there is little Chance the situation will Change in the near future. The failure of the Defense Department and VA to create a joint electronic health record, despite spending $1 billion for development is just another example of it. Click Learn More! Veterans USA ( @veterans GovSpending | 0.0 | 0.00 | USD | 2016-01-14T06:25:20-08:00 | |
| 36 | |
location:United States, age:13 — 35, language:English (US), placements:Instagram Feed, people_who_match:interests:Military, people_who_match:interests:Veterans, people_who_match:interests:Politics | 143644 | 496 | https://www.instagram.com/veterans_usl | He's lucky to return home to reunite with his family for the holidays. But he's just one of a few servicemen to do this. For many of our brave troops stationed abroad and far from their loved ones. Our brave servicemen and servicewomen will continue to make sacrifices for our great country while the VA employees will be having their dinner and laughing at the VA backlog. Click to Learn More! Veterans USA ( @veterans GovSpending | 133.42592000000002 | 8339.12 | RUB | 2016-01-14T07:18:30-08:00 | |
| 37 | |
location:United States, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed | 56837 | 216 | https://www.instagram.com/black_america_today/ | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black | 64.49296 | 4030.81 | RUB | 2015-12-22T03:42:46-08:00 | |
| 38 | |
location:United States, interests:HuffPost Black Voices, behaviors:African American (US), age:14 - 65+, language:English (US), placements:Instagram Feed | 24866 | 95 | https://www.instagram.com/black_america_today/ | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss | 28.743840000000002 | 1796.49 | RUB | 2016-01-06T01:45:12-08:00 | |
| 39 | |
location:United States, age:13 - 65+, language:English (US), placements:Instagram Feed, people_who_match:interests:HuffPost Black Voices, and_must_also_match:behaviors:African American (US) | 95140 | 300 | https://www.instagram.com/black_america_today/ | Join us to learn more! Why aren't white hoods and white supremacist propaganda illegal here in America? Why are Germans ashamed of their bigotry, while America is proud of it? Black America ( @black Blacklivessss | 146.57407999999998 | 9160.88 | RUB | 2016-01-14T06:07:11-08:00 | |
| 40 | |
location:United States, interests:Independence, interests:Patriotism, age:14 - 65+, language:English (US), placements:Instagram Feed | 12476 | 25 | https://www.instagram.com/veterans_us/ | Let's make America great again for the future generations! Click Learn More! Veterans USA ( @veterans GovSpending | 19.25616 | 1203.51 | RUB | 2016-01-06T03:11:48-08:00 | |
| 43 | |
location_living_in:United States, interests:Cop Block, age:18 - 65+, language:English (US), placements:Instagram Feed | 0 | 0 | https://instagram.Com/Cop_block_us | Together we can stop them. Join the fight. Follow @COp_b|OCk_US Cop block is a grassroots organization working to make police accountable for their actions. Cop Block Us (@COp_b|OCk_US) - Instagram photos and videos | 0.0 | 0.00 | USD | 2015-10-13T02:27:35-07:00 | 2015-10-15T23:59:59-07:00 |
| 44 | |
location_living_in:united_states:Texas, age:18 - 65+, language:English (US), placements:Instagram Feed | 0 | 0 | https://instagram.Com/south_lone_star | You can go to hell or follow @south_lone_star instead! Texas is where you always want to be! We are Texans and we're not like the rest! Follow us! Lone Star State Rebels (@south_lone_star) - Instagram photos and videos | 0.0 | 0.00 | USD | 2015-10-13T01:34:37-07:00 | 2015-10-15T23:59:59-07:00 |
| 49 | no image | custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 4405 | 716 | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters | 12.51552 | 782.22 | RUB | 2016-06-20T08:22:58-07:00 | |
| 50 | |
custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices | 92618 | 6555 | https://blackmattersus.com/ | Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters | 215.33584 | 13458.49 | RUB | 2016-06-21T07:09:02-07:00 | |
| 51 | |
custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices | 12653 | 393 | https://b|ackmattersus.com/?utm_source=facebook&utm_medium=Cpc&utm | Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters | 18.69296 | 1168.31 | RUB | 2016-07-06T07:18:32-07:00 | |
| 52 | no image | custom_audience:tesy, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 4544 | 724 | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | The head of Chicago’s IPRA, Sharon Fairley, has recommended an on-duty officer to be fired for calling President Obama a n****r. According to Chicago Sun-Times, the racist remark was made during a meeting to decide on “who would cover the president’s detail for a Bulls game”. The Independ Chicago Cop To Be Fired For Calling Obama N-Word | Black Matters Black Matters | 13.555040000000002 | 847.19 | RUB | 2016-06-20T08:03:12-07:00 | |
| 53 | |
location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 0 | 0 | https://www.facebook.com/blackmattersus/ | Join us because we care. Black Matters! | 0.0 | 0.00 | USD | 2015-07-13T07:13:40-07:00 | |
| 54 | |
location:united_states:Atlanta (+20 km) Georgia, location:united_states:Maryland, location:united_states:Ferguson (+20 km), St. Louis (+20 km) Missouri, location:united_states:Virginia, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 201428 | 12127 | https://www.facebook.com/blackmattersus/ | Join us because we care. Black Matters! | 854.7991999999999 | 53424.95 | RUB | 2015-07-13T07:20:58-07:00 | |
| 55 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 812 | 73 | https://www.facebook.com/blackmattersus/ | Fast-growing black community. Latest news and everyday updates! | 3.4312 | 214.45 | RUB | 2015-10-06T08:22:34-07:00 | |
| 56 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 3251 | 211 | https://www.facebook.com/blackmattersus/ | Fast-growing black community. Latest news and everyday updates! | 11.70832 | 731.77 | RUB | 2015-11-05T23:17:06-08:00 | |
| 57 | |
location:united_states:South Carolina, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 7457 | 304 | https://www.facebook.com/events/1730167210590258/ | Stand up, South Carolina! Let’s stop the propaganda of hate and white supremacy! Not My Heritage | 74.72 | 4670.00 | RUB | 2016-07-21T05:32:28-07:00 | 2016-07-23T05:32:25-07:00 |
| 58 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 16322 | 2446 | https://www.facebook.com/blackmattersus/ | Black Matters. Black community. | 76.76944 | 4798.09 | RUB | 2015-10-06T08:25:00-07:00 | |
| 59 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 359345 | 24838 | https://www.facebook.com/blackmattersus/ | Black Matters. Black community. | 934.5356800000001 | 58408.48 | RUB | 2015-11-05T23:17:06-08:00 | |
| 60 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 967 | 113 | https://www.facebook.com/blackmattersus/ | Fast-growing black community. Latest news and everyday updates! | 5.08096 | 317.56 | RUB | 2015-10-06T08:22:34-07:00 | |
| 61 | |
location:United States, interests:BlackNews.com, interests:HuffPost Black Voices, behaviors:African American (US), excluded_connections:Exclude people who like Black Matters, age:18 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 115604 | 10292 | https://www.facebook.com/blackmattersus/ | Fast-growing black community. Latest news and everyday updates! | 552.01728 | 34501.08 | RUB | 2015-11-05T23:17:06-08:00 | |
| 62 | |
location:united_states:Charleston (+70 km) South Carolina, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 42890 | 2182 | https://www.facebook.com/events/257074994652475/ | One year ago nine people were killed by a gunman, including the senior pastor, state senat Remember Victims of Charleston Shooting | 230.37904 | 14398.69 | RUB | 2016-06-01T06:03:23-07:00 | 2016-06-19T06:03:19-07:00 |
| 63 | |
custom_audience:Lookalike (US, 1%) - newtestaudit, location:United States, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:Third-party Apps and Websites on mobile devices, placements:News Feed on mobile devices | 0 | 0 | https://b|ackmattersus.com/ | Get breaking news and analysis on the life of African American community in the US. Black Matters 4 Cops On 1 Teen: Brutality Against Juveniles L. A. County probation officers brutalize teen in detention center. Fox News Hosts Believe Charleston Shooting Wasn’t Hate Crime “Fox & Friends” hosts declare that the shooting was motivated by religious hatred towards Christians, but not racism. Brutal Alabama Cop Fatally Shoots Black Teen Holding Cellphone A mobile police officer fatally shot a 19-year-old black teen, Michael Moore, during a traffic stop Monday, June 13 in Toulminville, Alabama. Black Matters | 0.0 | 0.00 | USD | 2016-06-21T07:08:44-07:00 | |
| 64 | |
location:united_states:Chester (+20 km) Arkansas, location:united_states:Washington (+20 km) District of Columbia, location:united_states:Atlanta (+20 km) Georgia, location:united_states:New Orleans (+20 km) Louisiana, location:united_states:Baltimore (+20 km) Maryland, location:united_states:St. Louis (+20 km) Missouri, location:united_states:Cleveland (+20 km) Ohio, location:united_states:Philadelphia (+20 km) Pennsylvania, location:united_states:Memphis (+20 km) Tennessee, location:united_states:Richmond (+20 km) Virginia, location:united_states:Milwaukee (+20 km) Wisconsin, excluded_connections:Exclude people who like Black Matters, age:18 - 65+, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 500 | 25 | https://www.facebook.com/BlaCk-Matters-1579673598947501/ | Join us. Because we care | 5.44544 | 340.34 | RUB | 2015-07-10T01:03:31-07:00 | |
| 66 | |
location:united_states:Detroit (+70 km) Michigan, interests:HuffPost Black Voices, age:15 - 54, language:English (UK), language:English (US), placements:News Feed on desktop computers, placements:News Feed on mobile devices | 3 | 0 | https://www.facebook.com/events/1727519624184050/ | A rally in loving memory of Aiyana Jones May 16 will mark the sixth anniversary of the br The 6th Anniversary Of The Aiyana Jones’ Death | 0.01312 | 0.82 | RUB | 2016-05-06T01:00:41-07:00 |
CREATE VIEW display_ads AS
select ads.id,
case when image is not null then
json_object("img_src", "https://raw.githubusercontent.com/umd-mith/irads/master/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