skysuite

Esri Demographics

A direct pull of Esri Business Analyst demographic enrichment data into the active worksheet - current-year and 5-year-forecast population, income, household, and housing metrics.

When to use it

  • Pulling 1-mile / 3-mile / 5-mile demographics around a deal address for an underwriting page.
  • Building a market study with current-year and 5-year-forecast medians (income, home value, household size).
  • Comparing ZIP-code-level or MSA-level demographics for site selection.
  • Refreshing forecast figures inside an automation - the action auto-resolves current/forecast year variable IDs.

How it works

  1. 1
    Add an Esri Demographics action to an automation.
  2. 2
    Pick a Geography type: Radius / ZIP / County (FIPS) / Tract (FIPS) / Block Group (FIPS) / MSA (CBSA) / State (2-letter) / Place (FIPS).
  3. 3
    Pick a Template: Population & Income, Housing, or Population Growth (legacy).
  4. 4
    Bind an Input range (the cell with the address/lat-lng/FIPS/ZIP) and an Output range (top-left cell for the table).
  5. 5
    For Radius mode, set Radii (CSV) - default 1,3,5 miles.
  6. 6
    The runner resolves lat/lng (geocoding the input if needed), calls the SkySuite-proxied Esri enrichment API per radius (or once for non-radius geography), and writes a label-spacer-data table.

Tips & shortcuts

  • For Radius mode, the input cell can be either "latitude, longitude" (parsed directly) or a free-form address (geocoded). Multiple radii are run as separate API calls and merged into a single side-by-side table.
  • Growth-rate rows are written as live Excel formulas referencing the CY and FY cells in the same table - =IFERROR((FY-CY)/CY*100,""). If you delete a CY or FY row the formula breaks gracefully (shows blank).
  • The output table layout is: column A = variable label, column B = blank spacer, columns C+ = one column per geography (or per radius). Number formats are applied per variable: $#,##0 for money, #,##0 for counts, 0.0 / 0.00 for ages and household size, 0.00"%" for growth rates.
  • Non-radius geographies expect a code, not a name - e.g., 06037 for Los Angeles County, 90210 for the ZIP, 06 for California, 31080 for the LA-Long Beach-Anaheim MSA.