When 30,000 Unqualified Records Made a Firm's Salesforce Pipeline Impossible to Trust
Client Overview
Rehmann is a full-service advisory and asset management firm headquartered in Troy, Michigan, with more than 1,000 employees. It offers accounting, tax, wealth management, consulting, and technology services to businesses and individuals across the Midwest. Its marketing and demand teams use HubSpot and Salesforce to capture inbound interest and route it to advisors.
Industry: Accounting & Advisory (Professional Services)
Solution Delivered: HubSpot Marketing Hub Implementation & Salesforce Sync Governance
Products Used: Marketing Hub Professional, HubSpot–Salesforce Integration, HubSpot CRM
Client Contact: Samantha Bannasch, Associate Director of Demand & Engagement+
Key Outcomes
A Pipeline Sales Can Trust
Salesforce now holds only the contacts sales chose to pursue. Before, records synced in with no oversight.
30,000+ Duplicate Records Removed
Junk records no longer reach Salesforce. Before, manual cleanup could never keep pace with the volume.
Inquiries Reach the Right Advisor Automatically
Each inquiry routes to the right advisor automatically. Before, routing was manual and details got lost.
Campaigns Launch Without Rebuilding Lists
Marketing can send straight from a lifecycle segment. Before, every send meant building backup lists by hand.
Samantha Bannasch
Associate Director of Demand & Engagement
The Challenge
By early 2026, Rehmann ran a relationship-led sales motion on top of two CRMs with no single source of truth. HubSpot governed marketing, while Salesforce managed revenue. Between them sat an inclusion list, a separate form tool, and hours of manual cleanup. The systems worked in isolation, but the end-to-end flow leaned on human judgment and workarounds.
Missed Revenue From Leads That Sat in a Single Email Inbox
A website form created a lead in both HubSpot and Salesforce. The Director of Sales then worked the lead by hand from an Outlook inbox. If an email was missed, no system flagged the lead, and a potential client went unworked.
The Same Person Showed as a Client in One System and a Lead in Another
No clear rules governed what should sync into Salesforce or how records should match. So the same organization could appear as a client in one system and stray leads in the other. Marketing could not trust what the data was telling them.
Inquiry Routing Depended on a Second Tool and Manual Email Steps
HubSpot could not route submissions by inquiry type as it was configured to people who were not HubSpot users. So the team added Gravity Forms and routed each inquiry by hand. Some form fields never mapped into HubSpot, so detail needed to qualify the lead was lost.
No Way to Tell Which Campaigns Actually Produced Business
Once a lead was routed, follow-up happened in personal inboxes outside the CRM. Marketing only saw an outcome if a deal opened. Attribution was not tracked so there was no way to determine which campaigns produced revenue or where to spend next.
Hours Lost to Manual Cleanup That Never Caught the Duplicates
The team was overwhelmed by more than 5,000 duplicate company and contact records, requiring more manual labor than their capacity allowed. As new records continued to stream in, the team struggled to manage the volume, finding it impossible to resolve the backlog.
Nearly the Entire Database Synced Into Salesforce, Qualified or Not
The inclusion list synced 99.7% of HubSpot contacts to Salesforce. Spam, bots, internal associates, and unqualified leads all synced through. Roughly 30,000 unmatched records sat in Salesforce, and marketing stopped trusting the list.
Miranda Junga
Associate Director of Digital Marketing
The Solution
Mole Street partnered with Rehmann to turn two disconnected CRMs into one governed revenue model. The work focused on three main areas: controlling what enters Salesforce, clarifying which system owns each stage, and giving Marketing visibility it could trust. By meeting these objectives, Rehmann effectively governed the sync to Salesforce and restored operational visibility to the internal team..
Routed Revenue Inquiries to the Right Person With Full Context
Inbound routing now runs on HubSpot workflows rather than a separate form tool. Notifications carry the details the prospect submitted , the page URL, and company context. The right advisor acts on a real inquiry without digging through an inbox.
Set a Single System of Record for Each Stage to End CRM Conflict
This requirement was achieved by making Salesforce the owner of revenue objects and HubSpot the owner of marketing engagement. Contacts sync as Contacts, not Leads, matching current Sales processes. Each record now has one clear home.
Rebuilt Inbound Forms in HubSpot and Retired Gravity Forms
The Contact Us, Subscription, and Webinar forms now run natively in HubSpot. With Gravity Forms, some of what a prospect filled in never reached HubSpot, so Marketing lost details it needed to qualify the lead. Now every field is captured and each inquiry routes automatically.
Built Lifecycle Segments That Return Pipeline Visibility to Marketing
Six lifecycle segments track demand from Marketing-eligible using active clients. Marketing can now see pre-pipeline volume and report on it. The team no longer builds throwaway lists to compensate for one it did not trust.
Added a Sales Temperature Field to Replace Informal Prospect Lists
A Salesforce-owned Sales Temperature field captures how hard the team is pursuing each relationship. It sits alongside a lifecycle stage, which tracks structural progress. Together they replaced the informal top-prospect lists that lived outside the system.
Replaced the Full-Database Sync With a Revenue-Only Salesforce Gate
Sync only now activates when Sales creates the Account and associated Contact in Salesforce. That action writes back a Contact ID, which moves the record into HubSpot for marketing visibility. Form submissions, webinar signups, and associate emails no longer create Salesforce records.
Before and After Mole Street
Salesforce sync
Before
99.7% of contacts synced automatically
After
Only Sales-eligible contacts and beyond sync
Impact
CRM reflects pipeline, not engagement volume
Inbound forms
Before
Gravity Forms with manual email routing
After
Four native HubSpot forms with automated workflow routing
Impact
One system for capture and for routing
Lead visibility
Before
Lost once routed to an inbox
After
Lifecycle segments track every stage
Impact
Marketing can report on pre-pipeline demand
Duplicate records
Before
5,000+ flagged, cleaned by hand
After
Email matching plus a governed sync gate
Impact
Fewer duplicates created by design
Marketing confidence
Before
Extra lists built on every send
After
Trusted segments and lifecycle logic
Impact
Team operates HubSpot on its own
By: Harry Maule