Short answer: Every company I build runs on one relational database that holds the facts, one task system that holds the work and one chat layer that holds the conversation. Each fact lives in exactly one place, everything else links to it, and nothing is copied. That rule, more than any tool, is what lets a multi-brand company move fast without contradicting itself.
The problem with “it’s in there somewhere”
Most growing companies do not have a data problem. They have a duplication problem. The brand guide lives in a slide deck, a doc, a designer’s folder and someone’s memory, and all four disagree. The pricing lives in a spreadsheet and three email templates. The process lives in a document nobody has opened since it was written.
When you add AI to that, it gets worse, not better. An agent will happily read the outdated copy and act on it with total confidence. Garbage in, polished garbage out.
So before I automate anything, I fix where the truth lives.
The three layers
The facts: a relational database. Companies, brands, people, decisions, rules, platforms and automations each get their own table, with linked records instead of copied text. A brand’s voice rules exist once, in that brand’s row. Everything that needs them, whether that is a person, a workflow or an agent, reads them from there every time, live.
The work: a task system. Every piece of work is a task with one owner, a due date, a status and a description written so a new person could pick it up cold. Agents and people share the same queue, so there is one answer to “what is happening right now?”
The conversation: chat. Channels follow a naming system by company, department and purpose, so updates go where the people who need them already are, and alerts never drown out decisions.
Rules that keep it honest
A data model is only as good as the habits around it. These are the ones I enforce everywhere.
- One location, no duplicates. If something is moved, the old copy is deleted. Backups that nobody maintains become the next source of contradictions.
- IDs are never reused. Every decision, rule and record gets a permanent ID. When something is retired, its number retires with it, so history stays readable.
- Log the decision, not just the outcome. Every meaningful choice is written down with the date, who made it and why. Six months later, the why is the part you need.
- Read live, never cache. Agents and workflows pull the current version at the moment they act. Nobody works from a pasted summary.
- Verify by reading back. After any write, read the record again from the live system and compare it to what you meant to write.
Building on top of it
Once the foundation is clean, building gets fast.
When I needed a way to track how every brand shows up across search and social over time, I built a small internal app on a no-code platform that syncs from the database every day and on demand. It took days, not months, because the data was already structured and trustworthy.
The same foundation runs my scheduled operating checks: inbox triage, event tracking, presence monitoring, portfolio reviews. Each one reads the same source of truth, writes back to it, and reports in the same format. Adding a new brand means adding rows, not rebuilding systems.
For ecommerce, this is everything
Commerce multiplies the cost of bad data. A product described three ways across three channels is three chances to lose a sale or start a return. A customer record split across a storefront, a help desk and an email platform is a customer you cannot actually see.
The fix is the same: decide where each fact lives, link everything else to it and make the systems read from the source. Your storefront, your marketing and your support team should all be telling the same story because they are reading the same record.
Start here
If your company is still running on scattered docs and memory, do three things this week:
- List the ten facts your team looks up most often. Pricing, brand rules, process steps, who owns what.
- Give each one exactly one home, and delete or redirect every other copy.
- Make every new workflow, human or AI, read from that home.
It is unglamorous work. It is also the reason everything built on top of it works.
Lo Dixon builds ecommerce brands and the technology behind them. She has spent a decade in technology, building companies and the systems that run them. Connect at linkedin.com/in/bylodixon.
Read the Comments +