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. Table sorted by revenue descending.

How it works 10 steps

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

Data fetch

▼ companies ?

▼

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

Settings 2 configurable

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

hubspot setting =

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