11 tools, no single view of the customer. So I built a warehouse.

Eleven tools. No single view of a customer. Here is how I fixed it.

Orders lived in two web stores and two marketplaces. Email, ads, analytics and service each sat in its own tool. Every tool had its own reports, and its own time zone. Simple questions meant export, paste, fix, repeat.

So I brought it all into one cloud Postgres warehouse. One small loader per source runs every night: history first, then only what is new. Every load writes a row to an audit log. Raw data lands first. Then one customer key, and clean views. AI assistants wrote most of the code. I set the goals, the rules, and the approvals.

On the synthetic demo data, 63 percent of paid social orders came from customers who had already bought. Paid social looked like $41 per order, but $110 per truly new customer. The 180-day repeat rate fell from 28.5 percent to 20.6 percent.

At public list prices, a full CRM suite is about $45,000 to $57,000 a year. This approach is about $4,400 a year in tools. That is not a CRM. Builder time is not priced in that comparison.

What would you ask your data first?