GoodAnalytics.Core.Funnels.Query (GoodAnalytics v0.1.1)

Copy Markdown View Source

Builds funnel analysis SQL queries.

Generates one CTE per funnel step joined sequentially on canonical visitor identity with inserted_at bounds on every CTE for partition pruning. Canonical visitor identity is COALESCE(ga_visitors.merged_into_id, ga_visitors.id).

Summary

Functions

build_sql(funnel, opts)

Builds a parameterized SQL query and params list for funnel analysis.

Functions

build_sql(funnel, opts)

Builds a parameterized SQL query and params list for funnel analysis.

Options

  • :window_start - DateTime, start of analysis window (required)
  • :window_end - DateTime, end of analysis window (required)
  • :cohort_source_filter - optional map with platform/medium/campaign