The brief
McCord Media sells advertising on digital out-of-home (DOOH) screens across shopping centres around Australia. To sell a screen, a business development manager (BDM) needs to know what exists, where it is, and the detail behind it — which centre, which suburb, which state, which format.
That information lived in spreadsheets. More than one. Different versions on different laptops.
Two problems came out of that:
- No single source of truth. Each BDM worked off their own copy of the list. When the network changed, the copies drifted. Nobody was certain which spreadsheet was current.
- No control over sensitive data. The full screen-location list is the map of the entire network — commercially sensitive. Spread across email attachments and personal drives, there was no way to control who held it or to revoke access once it was out.
So the team was both slowed down (hunting through files to answer a simple “do we have a screen near here?”) and exposed (the crown-jewels list sitting in a dozen uncontrolled places).
What we found in the audit
The data already existed. It was just fragmented.
Across the spreadsheets sat thousands of screen records — over 4,000 — each carrying the same core fields: the centre, the suburb, the state, the format. The work was not to gather new data. It was to consolidate the data into one place and put a lock on it.
The audit made the build target obvious: one map, one dataset, one controlled point of access.
What we built
An interactive map. Every screen McCord sells, plotted on a single map of Australia.
A BDM opens one link, pans and zooms the map, and clicks a pin to see the centre, suburb, state, and format for that screen. No spreadsheet. No version confusion. No personal copy to keep in sync.
- Consolidated the 4,000+ screen locations from the scattered spreadsheets into one clean dataset.
- Plotted every location on an interactive map the team can explore visually instead of scrolling rows.
- Put the whole thing behind access control, so the full network data is only visible to the people who should see it.
- Made it the single source of truth — the data updates in one place, and everyone sees the same current view.
The stack
- Leaflet for the interactive map and pin layer
- McCord’s existing screen inventory, consolidated from the scattered spreadsheets into one structured dataset
- Deployed as a single, access-controlled internal tool — one link for the whole team
The results
- One source of truth. 4,000+ screens, one map, one link. The spreadsheets are retired.
- Locked down. Access to the full network is controlled in one place, not copied across personal drives and email threads.
- Instant lookup. A BDM finds any screen by panning the map, not by searching through files and hoping the file is current.
- Always current. The data updates once and everyone sees the same thing — no more drift between copies.
Why this build matters for sales teams with spreadsheet sprawl
Almost every sales team has a version of this problem: the core data the team sells from — the inventory, the territory list, the price book — gets copied and re-copied until nobody trusts any single version, and gets shared in ways nobody can control or claw back.
Centralising that data into one access-controlled tool fixes both problems at once. The trust problem goes away because there is only one current view. The security problem goes away because there is only one place the data lives, and you decide who reaches it.
OFO Collective ships internal tools like this on the 30-day trial. For a similar build, book a call.