Mockup of two printed market books: a dark cover reading National Client, New Hampshire Market Book 2025 with an orange state shape, beside a Webster Square property summary and demographics spread.

US Market Books

Editorial & Production Systems

|

2025

Design, Production

Overview

A site-selection series for a national cellular client’s US expansion, organized by state and city: twelve volumes over six months, from a template built to run as many as the client asked for. Each book mapped available spaces against demographic and traffic targets and doubled as a tour book, with the sites in driving order.

Challenge

The client was weighing cities for new sites across the country and wanted a business-ready report on each market. Each book drew on the listing flyers, the sales team’s notes, and GIS maps and demographic work I did myself. Turning those into something a client could use every time took an assembly line.

Medford market book, pages 12 and 13: a green trade-area map with radius circles at left, and a satellite view at right with six numbered properties above a table of address, size, rent, and delivery.
Medford market book, pages 12 and 13: a green trade-area map with radius circles at left, and a satellite view at right with six numbered properties above a table of address, size, rent, and delivery.

Medford, Oregon, pages 12 and 13. The trade-area overview beside the one-mile aerial, the six sites numbered in driving order above their table.

New Hampshire market book, pages 16 and 17: a Nashua area map with a five-mile radius and three marked properties at left, and a 65-plus population density map with a color legend at right.
New Hampshire market book, pages 16 and 17: a Nashua area map with a five-mile radius and three marked properties at left, and a 65-plus population density map with a color legend at right.

Nashua, New Hampshire, pages 16 and 17. The area overview beside the 65-plus population density overlay, the demographic target shaded by blockgroup.

Approach

The pipeline ran through GIS software for the demographic overlays, retail aerials, and competitor maps, then Excel for property details, and finally InDesign for layout. The property spreadsheet was organized to match the InDesign tables, and the demographic tables were built to mirror the GIS export, so the data went across in a single paste.

Six map types per market, each with its own palette, crop, and annotation. The same demographic data appears as shaded map overlays and as a table. Production fell from fifteen hours per volume to six on the assembly line.