iconara

SELECT
  category,
  segment,
  SUM(exposures) AS exposures,
  SUM(impressions)/(SUM(exposures) - SUM(indeterminate_visibility)) AS impression_rate,
  SUM(engagements)/SUM(exposures) AS engagement_rate
FROM (
	  SELECT
	    date,
	    ad_id,