{"queries":[{"id":"date_bounds","compiledQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'","inputQueryString":"SELECT MIN(date) as min_date, MAX(date) as max_date\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'","compiled":false,"inline":true},{"id":"traffic_over_time","compiledQueryString":"SELECT\n date,\n sessions,\n users,\n pageviews,\n conversions,\n bounce_rate,\n avg_session_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nORDER BY date","inputQueryString":"SELECT\n date,\n sessions,\n users,\n pageviews,\n conversions,\n bounce_rate,\n avg_session_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nORDER BY date","compiled":false,"inline":true},{"id":"traffic_sources","compiledQueryString":"SELECT\n source,\n medium,\n SUM(sessions) as sessions,\n SUM(users) as users,\n SUM(conversions) as conversions,\n ROUND(100.0 * SUM(conversions) / NULLIF(SUM(sessions), 0), 2) as conversion_rate\nFROM analytics.traffic_sources\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY source, medium\nORDER BY sessions DESC","inputQueryString":"SELECT\n source,\n medium,\n SUM(sessions) as sessions,\n SUM(users) as users,\n SUM(conversions) as conversions,\n ROUND(100.0 * SUM(conversions) / NULLIF(SUM(sessions), 0), 2) as conversion_rate\nFROM analytics.traffic_sources\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY source, medium\nORDER BY sessions DESC","compiled":false,"inline":true},{"id":"source_summary","compiledQueryString":"SELECT\n CASE\n WHEN medium = 'organic' THEN 'Organic Search'\n WHEN medium = 'cpc' THEN 'Paid Search'\n WHEN medium = '(none)' THEN 'Direct'\n WHEN medium = 'referral' THEN 'Referral'\n ELSE 'Other'\n END as channel,\n SUM(sessions) as sessions,\n SUM(users) as users,\n SUM(conversions) as conversions\nFROM analytics.traffic_sources\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY channel\nORDER BY sessions DESC","inputQueryString":"SELECT\n CASE\n WHEN medium = 'organic' THEN 'Organic Search'\n WHEN medium = 'cpc' THEN 'Paid Search'\n WHEN medium = '(none)' THEN 'Direct'\n WHEN medium = 'referral' THEN 'Referral'\n ELSE 'Other'\n END as channel,\n SUM(sessions) as sessions,\n SUM(users) as users,\n SUM(conversions) as conversions\nFROM analytics.traffic_sources\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'\nGROUP BY channel\nORDER BY sessions DESC","compiled":false,"inline":true},{"id":"current_metrics","compiledQueryString":"SELECT\n SUM(sessions) as total_sessions,\n SUM(users) as total_users,\n SUM(pageviews) as total_pageviews,\n SUM(conversions) as total_conversions,\n ROUND(AVG(bounce_rate), 3) as avg_bounce_rate,\n ROUND(AVG(avg_session_duration), 1) as avg_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","inputQueryString":"SELECT\n SUM(sessions) as total_sessions,\n SUM(users) as total_users,\n SUM(pageviews) as total_pageviews,\n SUM(conversions) as total_conversions,\n ROUND(AVG(bounce_rate), 3) as avg_bounce_rate,\n ROUND(AVG(avg_session_duration), 1) as avg_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'\n AND date <= '${inputs.date_range.end}'","compiled":false,"inline":true},{"id":"previous_metrics","compiledQueryString":"SELECT\n SUM(sessions) as total_sessions,\n SUM(users) as total_users,\n SUM(pageviews) as total_pageviews,\n SUM(conversions) as total_conversions,\n ROUND(AVG(bounce_rate), 3) as avg_bounce_rate,\n ROUND(AVG(avg_session_duration), 1) as avg_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'::DATE - ('${inputs.date_range.end}'::DATE - '${inputs.date_range.start}'::DATE)\n AND date < '${inputs.date_range.start}'","inputQueryString":"SELECT\n SUM(sessions) as total_sessions,\n SUM(users) as total_users,\n SUM(pageviews) as total_pageviews,\n SUM(conversions) as total_conversions,\n ROUND(AVG(bounce_rate), 3) as avg_bounce_rate,\n ROUND(AVG(avg_session_duration), 1) as avg_duration\nFROM analytics.ga4_traffic\nWHERE client = '${params.client}'\n AND date >= '${inputs.date_range.start}'::DATE - ('${inputs.date_range.end}'::DATE - '${inputs.date_range.start}'::DATE)\n AND date < '${inputs.date_range.start}'","compiled":false,"inline":true}]}

Ceiling Pro

Traffic

No Results