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:
- 06:30 ET - the funnel export, writing
funnels - 06:45 ET - the funnel metrics Lambda, deriving
funnel_metricsfrom the funnels the export just landed - 07:00 ET - the daily export, writing
property_traffic,page_traffic,error_events,meta_page_traffic,meta_page_events, andpartner_portal_page_traffic, then starting the crawler
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. |
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.