Metabase vs Tableau for DTC Brands: Inventory and CAC

Most DTC brands run on Shopify plus one or two ad platforms plus a fulfillment or 3PL system, none of which natively talks to the others in a way that answers a founder's real questions. Metabase connects to a database or warehouse that a sync tool fills from each platform's API, and lets you write the join once: orders to ad spend by UTM source, and orders to remaining inventory by SKU. That single query answers both the marketing question and the operations question from the same underlying data, instead of maintaining two separate spreadsheets that inevitably drift out of sync with each other.

A sensible build order for the first version:

1. Use a sync tool to copy Shopify, ad platform, and fulfillment data into one database or warehouse.
2. Write the join once, connecting orders to ad spend by UTM source and to the specific SKUs those orders contain.
3. Calculate blended CAC from your own order data instead of trusting each platform's reported number.
4. Add a days-of-inventory-remaining view for top SKUs, so scaling ad spend never outruns available stock.
5. Join return data to the same product and channel dimensions, so margin reflects returns and not only revenue.

Say a campaign on a specific channel is performing well and the team wants to scale ad spend on it. Without an inventory-aware dashboard, that decision gets made on marketing performance alone. A Metabase dashboard joining that channel's orders to the specific SKUs it is driving shows the campaign is about to sell through the last of a popular size or color combination within days at the current pace. Scaling spend into that gap wastes budget acquiring customers for a product that will be out of stock before it ships, and worse, damages customer trust when an order gets canceled for lack of inventory. Catching this before scaling the budget, not after the stockout emails start going out, is the entire value of joining these two data sources.

Every ad platform reports its own CAC using its own attribution logic, and every platform's number looks better in isolation than the blended reality of a customer who saw three different ads before converting. Build a single blended CAC calculation from your own order data, total ad spend across every channel divided by new customers acquired in the same period, and use platform-reported numbers only for channel-level optimization within that broader reality. Brands that make scaling decisions off platform-reported CAC alone tend to discover their true blended CAC only once cash flow tightens, which is a worse time to learn it than now.

A high-return-rate product can still show up as a top revenue performer on a standard sales dashboard, because returns often get netted out weeks later in a separate accounting process rather than reflected in the same view a merchandising decision gets made from. Join return data to the same product and channel dimensions as your sales dashboard so a category with a quietly high return rate shows its true net contribution, not its gross sales number, before you decide to feature it more prominently or scale its ad spend further.

A single-brand DTC operation run by a small team can handle all of this in Metabase without much friction, since everyone who needs the numbers can also write or read a SQL query when necessary. A multi-brand portfolio, or a brand bringing on investors or a board that expects polished, consistent reporting on a fixed cadence, benefits from Tableau's governed, presentation-ready output and its ability to scope access by brand for a team managing more than one label under one roof.

Disqualifier: skip Tableau if you are still a single brand with an internally-facing team. The setup cost buys polish and governance you do not yet have an audience for.

Inventory-heavy DTC brands often carry a line of credit or a term loan to fund purchase orders ahead of a selling season, and that financing is typically priced off the prime rate, which sits at 6.75% as of this writing¹. A dashboard that ties inventory turns and cash conversion cycle to the same view as sales and ad spend gives a founder a much better sense of how much of that financing capacity is actually needed for the next purchase order, rather than guessing and either over-borrowing or running short at the worst possible moment before a seasonal peak.