Case Study:
CRM/Lead Management, Performance Visibility, Cross-functional Process:
Luxury Furniture Retailer
Overview
Building the system that captured the demand a furniture retailer was letting walk out the door.
Built a custom CRM and demand-capture system from scratch. Giving leadership real-time pipeline visibility, and turning captured demand into inventory and promotion decisions.
The Problem
The outlet organization had no system for capturing demand it couldn't immediately fulfill. When a customer expressed interest in a product that wasn't in stock, the interaction ended there, and the demand went unrecorded.
This created two compounding problems. First, hot leads with clear purchase intent were going unfulfilled and untracked, with no process to connect them to incoming inventory. Second, because unfulfilled interest was never captured, the business had no visibility into real demand. Out-of-stock product simply produced no sale, and no data. Leadership could not see how much revenue was being lost, or use that demand signal to inform merchandising, promotions, or inventory decisions.
The Solution
1. Build the CRM and demand-capture system
Because interested buyers were walking out whenever a product was out of stock, and that demand was disappearing unrecorded, I built a custom CRM and lead management platform from scratch in Smartsheet to capture that interest instead of losing it. The system recorded the demand and connected each lead to incoming inventory, so when product arrived, the interested buyer was already documented and could be automatically contacted to close the sale. What had been walk-away interactions became a tracked, fulfillable pipeline.
2. Built pipeline and demand visibility
Because leadership had no way to see the pipeline or quantify the demand being lost, I built the reporting and dashboards in Smartsheet and exported the data into Tableau. This gave leadership real-time visibility into pipeline status, sales KPIs, and for the first time captured demand for product not currently on the outlet floor.
3. Turned demand data into operational decisions
Because we now knew what customers actually wanted but didn't have, I used the captured demand data to direct the product team on which product to prioritize bringing to the outlet, and to inform how and when promotions were run. Demand that had previously been invisible now drove inventory allocation and promotional strategy — matching supply to where the proven interest actually was.
The Proof
First Year Incremental Revenue Increase
$1.5M+
From demand that was previously lost to a lack of leads tracking.
7000+
Leads generated
+30%
Average order value vs. store baseline
20%
Reduction in inventory time-on-floor
Summary
This engagement captured demand the business had been losing without knowing it. Interested buyers who wanted out-of-stock product used to walk out unrecorded; a custom CRM captured that demand instead, connected each lead to incoming inventory, and turned walk-away interactions into fulfilled sales. The same demand data gave leadership real-time pipeline visibility and told the team what product to prioritize and how to run promotions. Over 7,000 previously-lost leads were captured, and the recovered demand generated $1.5M+ in incremental first-year revenue.
The same principle applies to any sales operation. Most businesses only measure what actually sold, but the sales you didn't make hold just as much information. Every request for something you didn't have on hand, every customer who left without buying, every product someone asked about is an opportunity to tell you what to stock, what to promote, and where the demand actually is. Companies that only look at completed sales are working from half the picture. The ones that capture the signals around the sale, not just the sale itself, can act on demand before it walks out the door.
The same approach applies to any sales operation losing buyers it can't see or capture. It starts with an audit.