Solution: mapping 18m postcodes in Salesforce

Case Study

Charity/ NFP

Media

All Industries

Engineering

Our client owns an advertising network with a nationwide presence, managing advertising assets across 150+ locations. Their legacy system couldn’t keep up with growth or modern campaign needs, leading to inefficiencies in proposal generation and location-based sales.

Location

United Kingdom

TEAM

Sales Operations

Challenges faced

Complex location-based media planning needed innovative solutions.

Primary challenge: The client had no unified way to visualise or filter advertising assets across its locations.

Other challenges: Sales teams relied on a dated, on‑premise postcode mapping tool with limited functionality.

Time‑consuming manual searches and CSV manipulations resulted in administrative delays, cutting into selling time.

20250731_1735_Postcode Data Landscape_simple_compose_01k1g5vk43fpr8wrqfyhg5cstw

What we did

We implemented a phased transformation for the client, starting with Phase 1, which focused on immediate improvements using Salesforce-native mapping tools.

In Phase 2, we expanded the solution's capabilities by integrating the Google Maps API. We ingested over 1.8 million UK postcode records through the ONS API and developed a custom component, which provided powerful search functionality along with CSV upload and export features.

This enabled the sales team to efficiently search for locations by town, county, postcode, region, or drive-time radius, streamlining the process of generating location-based proposals.

BUILDING BLOCKS OF SUCCESS

Salesforce-native mapping

Leveraged Salesforce’s native mapping tools for quicker, immediate improvements in location discovery.

Google Maps API integration

Deeper mapping functionality enabled through Google Maps API, enriching location data for enhanced decision-making.

Data ingestion

Over 1.8 million UK postcode records were ingested through the ONS API, providing accurate and comprehensive postcode data.

Custom Salesforce component

Designed a powerful custom component for postcode search, CSV uploads, and easy location-based exports.

Impact

The result of our collaboration

The location-based solution radically changed the way proposals were created.

75% reduction in time spent generating location-based proposals.

Sales teams could offer location‑specific options within seconds, boosting brand trust and conversion.

Enabled sellers to identify all sites within a given radius or drive‑time, facilitating smarter conversations with national and local buyers.

Fully adopted by the sales team as a daily tool in their sales process.

Function

Services

Outcomes

Technologies