
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, Oregon, pages 12 and 13. The trade-area overview beside the one-mile aerial, the six sites numbered in driving order above their table.
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.

