ddanieltan

select -- 5. Summarize
aoh.location_id,
count(clks.paid_cpc_cents_usd) as clicks,
count(aoh.gbv_usd) as conversions,
cast(count(aoh.gbv_usd)as decimal)/count(clks.paid_cpc_cents_usd)as cvr,
avg(aoh.gbv_usd) as avg_gbv_usd,
avg(clks.paid_cpc_cents_usd) as avg_spend
FROM
	(select -- 3. Pull conversion stats
	cc_provider,