conversions_per_day.sql

Home / osgi-bundles / bundles / analytics / src / main / resources / reports / conversions_per_day.sql

create or replace view v_conversions_per_day as
select
  date_format(next_start_date, '%Y-%m-%d') as day
, count(*) as count
from bst
where prev_phase = 'TRIAL'
and next_phase != 'TRIAL'
and report_group = 'default'
group by 1
order by 1 asc
;