Latest / MBA Training Marketing / Composable CDP: build it on your data warehouse
Transcript
- 0:00Host: Welcome to the Leaders Insights podcast.
- 0:07Host: Today's episode, Building a Composable CDP on Your Data Warehouse, a CMO's playbook.
- 0:13Host: The Composable CDP just crossed into boring and mainstream territory this year, and that's
- 0:18Host: exactly when I get suspicious.
- 0:21Host: Salesforce paid roughly a billion dollars for a data integration startup called OWN back
- 0:25Host: in 2024.
- 0:28Host: Because the package thing quietly bills you for a copy of data you already own.
- 0:39Expert: A CDP, customer data platform, the system that stitches every customer touchpoint into
- 0:44Expert: one profile, traditionally means you ship your data into a vendor's black box and rent it
- 0:50Expert: back.
- 0:51Host: Composable means the profile lives in your warehouse, the snowflake or BigQuery you already
- 0:56Host: pay for, and the tools just read from it.
- 1:09Expert: Correct, and that's the real fight.
- 1:11Expert: The playbook's whole premise is that you're not building anything new.
- 1:15Expert: You're borrowing infrastructure that finance and product already trust.
- 1:19Expert: When I did this at a mid-size retailer, the win wasn't technical.
- 1:23Expert: It was walking into the data team and saying, I don't want my own database, I want a schema
- 1:29Expert: in yours.
- 1:30Expert: That sentence turned a nine-month turf war into a three-week project.
- 1:34Host: Fine, but the old sales pitch for a package CDP was speed.
- 1:39Host: Marketers can't wait on a data engineering backlog to launch a campaign.
- 1:43Host: Doesn't Composable just move the bottleneck?
- 1:45Expert: It would if you stopped at the warehouse.
- 1:48Expert: You need what's called reverse ETL, a tool that pushes data out of the warehouse
- 1:53Expert: back into your ad platforms and email, the opposite of the usual pull-it-in direction.
- 1:59Expert: Census and high touch are the two names here.
- 2:02Expert: That layer is what lets a marketer build an audience without filing a ticket.
- 2:06Expert: The engineers own the data.
- 2:08Expert: Marketing owns the activation.
- 2:10Host: You just named two vendors, so we're back to paying somebody.
- 2:13Expert: Sure, but the bill is different in kind.
- 2:16Expert: A traditional CDP like a segment or an Adobe deal starts around six figures a year, and
- 2:22Expert: the price scales with how many customer records you store.
- 2:25Expert: You get punished for growing.
- 2:27Expert: Reverse ETL tools charge on how many times you sync, not how much data you hoard.
- 2:33Expert: One company I advised went from a quoted $240,000 a year to about $40,000, and that pricing's
- 2:39Expert: from the vendors, so take the exact numbers with salt, but the shape of it is real.
- 2:44Host: What breaks?
- 2:45Host: Nobody builds this in sales off happily.
- 2:48Host: Where's the two-in-the-morning phone call?
- 2:50Expert: CD resolution.
- 2:52Expert: Deciding that the person who bought on the app and the person who abandoned a cart on the
- 2:55Expert: website are the same human.
- 2:58Expert: Packaged CDPs hide that logic.
- 3:01Expert: Composable means you write it yourself in SQL, the query language your data team already
- 3:06Expert: speaks.
- 3:07Expert: Get it wrong, and you email a customer a welcome offer the day after they spent $900.
- 3:13Expert: That's the failure that gets a CMO fired, not the tech bill.
- 3:16Host: So the honest version is, you trade a vendor's black box for your own homework.
- 3:21Expert: Yes, and I'd argue that's the point.
- 3:23Expert: When the matching logic lives in your warehouse, you can actually see why two profiles merged.
- 3:29Expert: In the black box, when it's wrong, you file a support ticket and pray.
- 3:34Expert: I'll take homework I can inspect over magic I can't.
- 3:37Host: Give me the number that tells a CMO this was worth it, not just cheaper.
- 3:41Expert: Time from idea to live audience.
- 3:43Expert: Before, at that retailer, a new segment took 11 days because it round tripped through the
- 3:48Expert: vendor.
- 3:49Expert: After, under a day.
- 3:51Expert: Cost went down and speed went up, which almost never happens together.
- 3:55Expert: So I don't blame anyone for being suspicious.
- 3:58Host: Last thing, one move a CMO makes Monday morning.
- 4:01Expert: Book 30 minutes with whoever owns your warehouse and ask one question.
- 4:06Expert: Where do our customer profiles actually live today?
- 4:09Expert: And who can read them?
- 4:10Expert: If nobody can answer cleanly, you don't have a CDP problem.
- 4:14Expert: You have a plumbing problem and no vendor will fix that for you.
- 4:18Host: That's your five.
- 4:19Host: The full CMO track, structured no fluff, is at MBA-training.com.