DTC Analytics for Home and Furniture Brands
See what each order earns after freight, damage and returns, and which ads lead to sales that take weeks to close. We load Shopify, freight, inventory and ads into one place every morning.
The short answer
What Makes Reporting Hard
- Freight and damage claims land after the sale and never reach the margin report.
- Backorders and supplier lead times live in email and spreadsheets.
- Customers browse for weeks before buying, so ad platforms miss the sale or claim it twice.
- A few large returns swing the month, and nobody can say which products cause them.
Reports We Build
- Margin After Freight and Damage
- Contribution margin by order and product after freight, white-glove delivery, damage claims and returns.
- Backorders and Lead Times
- Open orders waiting on stock, with the expected date from each supplier and how long customers have waited.
- Long-Cycle Attribution
- Ad spend next to orders placed weeks after the first visit, using a window that matches how long your customers take to decide.
- Returns by Product
- Returns and damage claims by product, carrier and reason, with the cost of each.
Data We Connect
- Shopify
- Freight and delivery partner invoices
- Supplier purchase orders
- Warehouse or 3PL inventory files
- Meta Ads
- Google Ads
- Financing provider reports
- Snowflake
Common questions
How do furniture brands calculate profit per order?
Subtract product cost, freight and delivery, payment and financing fees, ad spend, and an allowance for damage and returns from net revenue. Freight and damage are the costs most often left out because they arrive later.
How do I attribute ad spend when customers take weeks to buy?
Measure how long your customers usually take from first visit to order, and use an attribution window at least that long. Compare blended results by month as a check, since platform windows often run shorter.
How should backorders be reported?
List each open order waiting on stock with the supplier's expected date and the days the customer has waited, and update it when purchase orders change.
Do damage claims belong in the margin report?
Yes. Record each claim against the order and product it came from, so the products and carriers that cause the most damage show up.
Bring the report that eats your week
We'll look at it with you and say what a single source of numbers would save. No pitch deck.