<invoke name="query_sql"> <parameter name="sql">SELECT WEBSITE, COUNT(*) AS n, COUNT(DISTINCT "PAGE URL") AS urls, SUM(CASE WHEN "ENTRANCES" > "PAGE VIEWS" THEN 1 ELSE 0 END) AS ent_gt_pv, MAX("PAGE VIEWS") AS max_pv, SUM(CASE WHEN "PAGE PATH" <> TRIM("PAGE PATH") OR "PAGE URL" <> TRIM("PAGE URL") THEN 1 ELSE 0 END) AS ws_issue, SUM(CASE WHEN "PAGE URL" NOT LIKE 'http%' THEN 1 ELSE 0 END) AS nonhttp, SUM(CASE WHEN "PAGE VIEWS" = 0 THEN 1 ELSE 0 END) AS zero_pv FROM raw.Website_Analytics GROUP BY WEBSITE ORDER BY n DESC</parameter> <parameter name="purpose">Per-website profile of impossible entrances>views, outliers, URL format issues</parameter> </invoke> </tool_call> </invoke>