Bibliothèque

US-Canada Consumer-Macro Panel (derived)

US-Canada consumer-macro panel: inflation, unemployment, sentiment, retail

Monthly US-Canada consumer-macro panel: CPI inflation (level, MoM %, YoY %; US series seasonally adjusted, Canadian series not), unemployment rate (SA %, MoM/YoY point changes, deviation from the trailing 12-month average), consumer sentiment (US index + YoY %; Canada null — no comparable monthly series), and retail sales (SA, millions of local currency, MoM %/YoY %; US series excludes motor vehicle and parts dealers, Canadian total includes them), plus a deterministic demand_pressure_score = mean of trailing-24-month z-scores of retail YoY growth, falling unemployment and CPI YoY. Upstream: FRED keyless fredgraph.csv (CPIAUCSL, UNRATE, UMCSENT, RSXFS) and Statistics Canada full-table CSV downloads (tables 18-10-0004-01 vector 41690973, 14-10-0287-01 vector 2062815, 20-10-0056-01 vector 1446859483). One row per year_month x country_code (USA/CAN); growth columns are the cross-country-comparable fields. Who joins this: a sales team joins monthly macro to pipeline value on year_month; a subscription business joins it to MRR on year_month + country_code. Upstream gaps propagate as nulls (e.g. the US October-2025 unemployment and November-2025 CPI releases were never published during the federal shutdown); the score needs at least two of its three z-components.

• macroeconomics
• consumer-spending
• cpi
• inflation