%
SELECT
  toStartOfDay(session_start) as day,
  uniqExact(uuid) as count_visitors,
  count(session_id) as count_sessions,
  countIf(pageviews=1)/count(session_id) as bounce_rate,
  avg(session_duration_sec) as avg_session_duration
FROM session_data_mv
WHERE session_start >= {{DateTime(start_datetime, '2022-06-01 00:00:00', description="Get all data from this datetime to now", required=True)}}
{% if defined(end_datetime) %}
  AND session_start < {{DateTime(end_datetime, description="The end date for data", required=False)}}
{% end %}
GROUP BY day