our data was everywhere.
billing in Mantle. product usage in PostHog. AI costs and attributed revenue in our database. payment history in the Shopify partner dashboard.
every time a customer messaged us or i got on a call, i'd check all of them separately. open mantle, find the customer, check their plan and churn risk. open posthog, search for their shop, look at engagement events. run a query in our database for conversations, revenue, AI costs. sometimes check shopify for payment history.
by the time i'd pieced things together, the call was half over.
i kept thinking there had to be a better way. CDPs exist, but they're expensive and built for bigger teams. i didn't need a product. i just needed my data connected.
so i built one in my openclaw.
it's an openclaw skill that talks to all four data sources. type a customer name, it searches mantle first to find their shopify id. then uses that id to pull from everything else. posthog events, database queries, billing data, shopify transactions.
it compiles into one report. billing status, usage trends over 12 months, AI costs by model, attributed revenue, engagement patterns, review history, contact info. takes a few seconds.
i use it on slack now while i'm on calls. support, sales with existing customers. just type their name. i know their plan, usage trend, whether their AI costs are healthy, how many conversations they had this month versus last.
what i didn't expect is how much it helps with selling to existing customers. when you can see conversations growing month over month and attributed revenue climbing, you know when to talk about upgrading. you're not guessing.
it also catches things i used to miss. a customer whose usage dropped 40% over two months. AI costs spiking relative to revenue. stuff that's obvious in a report but invisible when you're checking four tools one at a time.
built it in about two hours. use it every day.