Target Audiences by Optimization Goal

select
	"as".optimization_goal
	, sum(case when t.target_gender = 'female' then 1 else null end) as female_targets
	, sum(case when t.target_device_platforms like 'mobile%' then 1 else null end) as mobile_device_targets
	, sum(case when t.target_device_platforms like 'desktop%' then 1 else null end) as desktop_targets
	, sum(case when t.publisher_platforms = 'instagram' then 1 else null end) as instagram_targets
	, sum(case when t.targeting_optimization = 'expansion_all' then 1 else null end) as expansion_all_target_optimization
from
	fb_ads_adsets "as"
	left join fb_ads_adsets_targeting t on "as".adset_id=t.adset_id
group by 1;