Skip to main content

Google Analytics

Tables in the google_analytics schema, populated from the CanadaLogin GA4 property. The two meta_ tables come from a separate meta-analytics property, which measures readership of Signal Check, the published dashboards, and this Cookbook. partner_portal_page_traffic comes from the CanadaLogin Partner Portal property, and is not available until the Partner Portal reaches production. Three scheduled Lambdas write into this schema each night, all in the canadalogin-reporting-data-pipeline repo’s google_analytics Terraform module:

funnels_current and funnel_metrics_current are views over funnels and funnel_metrics respectively, resolving each date to its current funnel version.

Tables

Table Description
google_analytics.property_traffic Property-wide daily GA4 traffic, one row per day.
google_analytics.page_traffic Daily GA4 traffic by page title, path, and data stream.
google_analytics.partner_portal_page_traffic Not available yet. Daily GA4 traffic to CanadaLogin Partner Portal pages, by page title and path.
google_analytics.error_events Daily count of errors CanadaLogin flags to GA4.
google_analytics.meta_page_traffic Daily readership of Signal Check, the dashboards, and the Cookbook, by page and session source.
google_analytics.meta_page_events Daily GA4 events on Signal Check, the dashboards, and the Cookbook, by page and event name.
google_analytics.funnels Step-by-step counts for each defined GA4 funnel.
google_analytics.funnels_current Funnel step counts, resolved to the current funnel version for each date.
google_analytics.funnel_metrics Metrics derived from funnel rows, such as task success rate.
google_analytics.funnel_metrics_current Funnel metrics, resolved to the current funnel version for each date.
No matching items

Export lag

All four tables are pulled with a deliberate two-day lag - the nightly sweep that runs the morning of August 5, 2026 lands a window ending August 3, 2026, not August 4, because GA4 takes 24 to 48 hours to finish processing a day’s events. Each day is written once and never re-pulled, so a window read too early would stay artificially low forever.

Two of these tables - funnels and funnel_metrics - are defined by version-controlled YAML rather than a fixed schema. For what a funnel step or a derived metric actually measures, the YAML on GitHub is the single canonical source, not this catalog: steps get renamed, re-scoped, or added as CanadaLogin’s own pages change, and the table pages describe the table shape rather than the current step names. See funnel_src/funnels/ in the pipeline repo.