The problem
A media group planned its own content and its clients' sponsored content in separate spreadsheets. Each client had limits on how often they could appear, and those limits were checked by hand.
This is in-house work, built by Rob Dale, who runs Above Threshold, in his employed role. The employer is not named because this is an internal system.
What was built
- One plan. Every article, post and email sits in one database, with a calendar staff can drag items around on.
- Rules that check themselves. The limits for each client and each title are written into the app. Drag an item to a date that breaks a rule and it tells you before you let go.
- A portal for each client. Each client signs in with a link sent to their email and sees only their own plan, approvals and results. Asking for another client's page returns the same "not found" as a page that does not exist.
- An assistant in the portal. Clients can ask where a piece has got to. The assistant answers only from a fixed list of that client's own information. Internal notes never reach it, and an automated test checks that they cannot.
- Jobs that keep it current. Twenty-two scheduled jobs pull in post statuses, ticket sales, pipeline and site figures, so the picture stays current without anyone copying numbers across.
It went into production in November 2026.
What it proves
That a small team can replace a tangle of spreadsheets with one tool built around its own rules, and that an AI assistant can be given to customers safely when what it is allowed to see is decided first.