Data & BI2025Anonymised

Field Sales Tracking System

A sales team with no reliable view of activity in the field, and managers who each needed to see only their own region.

Services
Custom Software · Data Analytics & BI
Stack
PostgreSQL · Row-level security · Mobile-first · Excel export

Published anonymised at the client's request. The problem, approach and stack are described; the client and their data are not.

The story

What happened

The challenge

A field sales team was reporting activity through calls and messages, which meant managers had no reliable view of what was happening day to day. It also meant a genuine access problem: each regional manager needed their own region's data and nobody else's.

Our approach

Mobile-first, because the people entering data are standing in a shop, not sitting at a desk. Row-level security in the database rather than in the interface, so the access rule holds no matter how the data is queried.

What we built

  • A mobile-first tracker for field reps to log activity on the move
  • KPI dashboards for managers, scoped to their own region
  • PostgreSQL row-level security enforcing access at the database layer
  • Excel export for the finance team's existing workflow

The result

Managers see current activity for their region instead of reconstructing it from messages. Because access control sits in the database rather than the UI, the rule holds regardless of how the data is reached — which matters more than it sounds when reporting gets extended later.

Notable

Details worth calling out

  • Built for a phone in the field

    Entry is fast on mobile, because that is where the data is actually created.

  • Security in the database

    Row-level security means the access rule cannot be bypassed by a new query or report.

  • Fits existing workflow

    Excel export, because finance already had a process that worked.

Something similar in mind?

Tell us what you need. You will get an itemised quote, not a vague estimate.