How a purpose-built CRM and project management platform replaced disjointed legacy systems — giving an industrial e-commerce subsidiary real-time visibility into pipeline velocity, equipment inventory, marketing attribution, and employee performance from a single interface.
An industrial e-commerce subsidiary operating at significant volume had a data fragmentation problem that was costing them in time, accuracy, and executive visibility. High-value equipment listings were tracked across spreadsheets. Buyer leads lived in email inboxes. Sales pipeline stages existed only in the memories of individual sales representatives. Marketing campaigns ran through one platform; performance tracking existed on another. Nothing talked to anything else.
The executive team had no real-time view into pipeline velocity — how many deals were in progress, at what stage, and moving at what pace. Equipment inventory management was a manual reconciliation exercise. Marketing attribution was impossible — there was no mechanism to connect a marketing campaign to a closed deal. Employee performance was tracked informally, if at all.
"The executive team was running a significant e-commerce operation entirely from memory, email chains, and spreadsheets. Real-time visibility into their own business didn't exist."
Off-the-shelf CRM platforms were evaluated and rejected. The specific combination of high-volume industrial equipment listings, multi-stage deal management, and the need for direct marketing integration required a purpose-built solution — not a generic platform configured to approximate their workflow. We built from zero.
A purpose-built HTML/CSS interface designed around the specific operational workflow of the business — not a generic template adapted to fit. Navigation, data entry forms, and dashboard views were all architected to reflect how the team actually works: deal stages, equipment categories, and reporting cadences specific to industrial e-commerce.
A Google Apps Script backend provides a serverless, cost-zero database layer with secure access controls — no infrastructure management, no database subscriptions, no third-party data exposure. Apps Script handles all CRUD operations, triggers automated notifications, and maintains the relational data model linking deals, listings, contacts, and campaigns.
Direct integration between the CRM and the client's active digital marketing campaigns enables attribution tracking from first ad impression through closed deal. Campaign performance data — impressions, clicks, leads, and conversions — surfaces inside the CRM alongside the corresponding pipeline stages, closing the attribution loop.
Sales Pipeline Tracker
The pipeline module implements a stage-based deal management system with configurable stage definitions, automated stage progression logic, and deal velocity tracking. Each deal record captures: contact information, equipment of interest, deal value, current stage, time-in-stage, last activity date, and assigned representative. Automated notifications trigger on stage stalls — deals that have not advanced past a configurable threshold period surface automatically in the executive dashboard as attention items.
Equipment Listing Management
The inventory module centralizes all equipment listings with structured data fields: make, model, year, hours, condition grade, asking price, listing status, and associated documentation storage. Listing status flows through a defined lifecycle — Draft, Active, Under Offer, Sold — with each transition logged and timestamped. Buyer inquiry routing links inbound interest directly to the corresponding listing record, eliminating the email inbox as an intermediary.
Employee Performance Dashboard
The performance module tracks KPIs per sales representative in real time: deals opened, deals advanced, deals closed, total pipeline value managed, average deal velocity, and conversion rate by stage. Managers access an aggregate view across the full team and drill into individual contributor performance without waiting for weekly reports or manual compilations.
Marketing Attribution Integration
Campaign data from active digital marketing channels is pulled into the CRM on a scheduled Apps Script trigger. Each inbound lead is tagged with its acquisition source — enabling the executive team to see, for the first time, which marketing channels are generating which deal stages and at what conversion rate. This attribution layer provides the data needed for marketing budget allocation decisions based on measured ROI rather than estimated performance.
For the first time, the executive team could see the real-time state of their entire business from one interface: active deals by stage and value, inventory status across all equipment, marketing attribution from campaign to close, and individual employee performance — all live, without a manual compilation step.
The elimination of spreadsheet-based tracking, email-based lead routing, and manual performance compilation recovered significant administrative time across the team. Deal stages that previously required phone calls to determine now surfaced in seconds through the dashboard.
Marketing budget allocation shifted from intuition-based to data-driven. With campaign-to-close attribution now tracked inside the CRM, the team could identify which channels produced deals — not just leads — and reallocate spend toward the highest-converting acquisition paths.
Pipeline tracked in spreadsheets. Leads in email. Listings managed manually. No marketing attribution. Employee performance invisible in real time. Executive decisions made on lagging, fragmented data.
Pipeline, inventory, marketing, and performance all centralized. Real-time executive visibility. Automated deal-stage notifications. Marketing attribution from campaign to close. Zero third-party SaaS overhead.
The instinct toward off-the-shelf CRM platforms is understandable — they exist, they're marketed aggressively, and they're deployable quickly. The problem is that generic platforms are built around the median business workflow, not yours. Every enterprise customization is an adaptation: a workaround, a plugin, a field renamed, a workflow forced into a process designed for a different industry.
For the industrial equipment e-commerce context of this engagement, no off-the-shelf CRM natively handled the combination of physical inventory lifecycle management, high-value equipment listing workflows, multi-representative commission tracking, and marketing attribution in a single coherent interface. The closest options required significant configuration, multiple integrations, and ongoing subscription costs that would have compounded annually.
The proprietary build addressed all of it natively, with a user interface designed around the specific mental model of the team using it — not a generic sales team. It costs nothing to operate beyond maintenance and requires no third-party data sharing.
Proprietary CRM development makes sense when three conditions converge: your operational workflow differs significantly from the generic sales process that off-the-shelf platforms assume; the customization required to make a generic platform fit your workflow would be extensive, expensive, or ongoing; and the cost of recurring SaaS subscriptions and the risk of third-party data exposure are meaningful concerns. For businesses with highly specific inventory types, unusual deal structures, or specialized performance tracking requirements — industrial equipment, real estate, law practices, financial advisory — purpose-built systems consistently outperform adapted generic platforms.
Google Apps Script provides a serverless execution environment natively integrated with Google Workspace — the productivity suite most small and mid-size businesses already operate within. For CRM applications of this type, it eliminates the need for database server provisioning, ongoing infrastructure maintenance, and database subscription costs. It handles the CRUD operations, scheduled triggers, and email notification logic required by a sales CRM with zero infrastructure overhead. Data lives in Google Sheets or Drive — accessible to the team through existing Workspace permissions, auditable, and exportable without proprietary lock-in.
Attribution works through source tagging at the point of lead entry. Each inbound lead record captures its acquisition source — organic search, paid campaign, specific ad set, referral, or direct — at the moment of entry. As the lead progresses through pipeline stages to a closed deal, the source tag travels with it. This enables downstream analysis: for any closed deal or set of deals, you can trace back to the originating channel. Campaign performance data pulled from ad platforms through scheduled Apps Script triggers enriches the picture — connecting impressions and clicks from specific campaigns to the leads and deals they generated.
A focused proprietary CRM build — covering core pipeline management, inventory tracking, and a basic performance dashboard — typically takes four to eight weeks from requirements definition to deployment. The timeline is driven primarily by the complexity of the data model (how many distinct object types and relationships need to be represented) and the number of integration points with external systems. The most time-intensive phase is typically requirements definition: precisely specifying every operational workflow the system needs to support before any code is written prevents rework during development.
A purpose-built system that fits your exact workflow outperforms any adapted off-the-shelf platform.
Discuss Your Build