views AS()

in super-mode-calculator/src/lib/build-query.ts [112:124]

• 13 lines of code
• 1 McCabe index (conditional complexity)

views AS (
		SELECT CONCAT(protocol,'://',host,path) AS url, region, COUNT (*) AS total_views
		FROM views_with_regions
		GROUP BY 1, 2)
SELECT acquisitions_agg.referrer_url AS url,
	   acquisitions_agg.region,
	   acquisitions_agg.sum_av_gbp AS totalAv,
	   acquisitions_agg.acquisitions AS totalAcquisitions,
	   views.total_views AS totalViews,
	   acquisitions_agg.sum_av_gbp / views.total_views AS avPerView
	FROM acquisitions_agg
	INNER JOIN views ON acquisitions_agg.referrer_url = views.url AND acquisitions_agg.region = views.region
	WHERE views.total_views > ${SUPER_MODE_MINIMUM_VIEWS}