Hostname=vaccinesignup.mass.gov
is applied to the whole report, except to the 2 charts showing traffic to mass.gov on page 1.previous page path starts with www.mass.gov AND landing page contains vaccinesignup.mass.gov
landing page contains vaccinesignup.mass.gov
. Note that Mass.gov can't be a source, since this is cross-domain data. event action contains click
is applied.users - submitters
, and then to divide that by the total users.CASE WHEN REGEXP_MATCH(Page, '.16%.') THEN "Vaccine Signup Form Page 1" WHEN REGEXP_MATCH(Page, '.32%.') THEN "Vaccine Signup Form Page 2" WHEN REGEXP_MATCH(Page, '.50%.') THEN "Vaccine Signup Form Page 3" WHEN REGEXP_MATCH(Page, '.66%.') THEN "Vaccine Signup Form Page 4" WHEN REGEXP_MATCH(Page, '.100%.') THEN "Vaccine Signup Form Page 5" WHEN REGEXP_MATCH(Page, '.success.') THEN "Vaccine Signup Form Submitted" ELSE 'Page 1/2/3/4/5' END