Paul Yang Heray

## content-scoring.sql
with threshold as (
  SELECT percentile_cont(0.25) within group (order by CTR desc) as threshold25,
   percentile_cont(0.50) within group (order by CTR desc) as threshold50,
   percentile_cont(0.75) within group (order by CTR desc) as threshold75,
  count(*) as total_items
  FROM items
),
final as (
  SELECT
  items.id,

## pbjs_amazon.html
<html>
<head>

<script>

    var PREBID_TIMEOUT = 400;

    var googletag = googletag || {};
    googletag.cmd = googletag.cmd || [];
	with threshold as (
	SELECT percentile_cont(0.25) within group (order by CTR desc) as threshold25,
	percentile_cont(0.50) within group (order by CTR desc) as threshold50,
	percentile_cont(0.75) within group (order by CTR desc) as threshold75,
	count(*) as total_items
	FROM items
	),
	final as (
	SELECT
	items.id,
	<html>
	<head>

	<script>

	var PREBID_TIMEOUT = 400;

	var googletag = googletag \|\| {};
	googletag.cmd = googletag.cmd \|\| [];