home / russian-ads

ads_with_targets (view)

0 rows where target_names contains "people_who_match:interests:African-American Civil Rights Movement (1954—68)"

✎ View and edit SQL

This data as json

target_names (array) ✖

id file clicks impressions text url spend_amount spend_currency created ended target_names 
CREATE VIEW ads_with_targets as select ads.*, json_group_array(targets.name) as target_names from ads
  join ad_targets on ad_targets.ad_id = ads.id
  join targets on ad_targets.target_id = targets.id
  group by ad_targets.ad_id
Powered by Datasette · Query took 1972.354ms