Use “Accounts by Region Analyzer” in Recued. Groups US accounts into 5 regions (Northeast, Midwest, South, West, Other) using zip code prefix lookup. Computes account count, total revenue, and average deal size per region.

How it works 10 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Data fetch

▼ companies recued-core.hubspot.company.list

List company on hubspot

▼

Process (9 steps)

■ us_accounts filter

Filter by condition

■ valid_postal_code filter

Filter by condition

■ with_region_digit map

Extract from each item

■ with_region_name map

Extract region_digit from each item

■ valid_revenue filter

Filter by condition

■ region_stats group_by

Group by region_name

■ region_list to_list

Apply to_list

■ sorted_regions sort

Sort by

■ region_table to_table

Format results as a data table

▼

Output

table region_table

Settings 1 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

us country names choice = United States (United States, US, USA)