Bureau of Labor Statistics
A direct pull of U. S.
When to use it
- Showing a 10-year trend of unemployment and labor force around a deal location.
- Tracking inflation (CPI) over an underwriting horizon.
- Underwriting a market by job mix - which sectors are the dominant employers in a county.
- Quantifying recent employment momentum (3-metric YoY panel) to support rent-growth assumptions.
How it works
- 1Drop a Bureau of Labor Statistics action into an automation (or click the BLS ribbon button for ad-hoc).
- 2Pick the category: Employment, Industry Breakout, or Employment Growth (CPI is configured via the BLS form on the ribbon).
- 3Bind an Address range (cell with the address) and an Output range.
- 4Choose Always use latest year or pin a year; for Employment Growth, set Number of years (the YoY window).
- 5Optionally toggle Print charts (Employment Growth only) and Apply formatting.
- 6The action geocodes the address, resolves the county/MSA, hits the BLS public API, formats a table, and (for Employment Growth) inserts a line chart.
Tips & shortcuts
- Use Always use latest year in automations. The latest year provider walks the requested BLS series back until it finds a year with published data, so saved deals keep refreshing without manual updates.
- The ad-hoc Employment dialog lets you change Area type (state, MSA, county, etc.), measures, seasonal-adjustment, and yearly vs monthly. The automation form is intentionally simpler - it always pulls all 4 measures, Seasonally Adjusted, Yearly Average.
- Industry Breakout uses QCEW CSV (not the JSON BLS series API), so it requires the address to resolve to a U.S. county. International addresses won't work.
- Employment Growth charts are line charts with circular markers. The chart name embeds the automation ID so re-runs update the chart in place instead of stacking new ones.