Microsoft Dynamics 365 is one of the most capable revenue platforms on the market. It’s also one of the most underutilized. The gap between what Microsoft Dynamics can do and what most organizations actually get from the platform isn’t a technology problem – it’s an architecture problem.
At Coffee + Dunn, we’ve seen the same six gaps show up over and over. They’re not dramatic, but they quietly drain revenue potential month after month while everyone assumes the platform is “working just fine.”
The good news is that none of the gaps require a heavy, time intensive re-implementation. Most can be resolved in a focused sprint. With Microsoft Copilot now embedded across the Dynamics suite, organizations that close these gaps aren’t just stabilizing, they’re building a genuine competitive advantage.
Let’s evaluate those important gaps.
GAP #1: Data Lives Everywhere But Works Nowhere
The Fragmented Customer Record Problem
The most common finding in any Dynamics audit is that customer data is in the system but it’s wrong, incomplete, or duplicated. Contacts may exist in multiple records, company names have variable spellings, and account ownership hasn’t been updated. Customer lifecycle fields may also have been populated once and never touched again.
This isn’t just a data quality constraint – it’s a revenue architecture problem. When your CRM doesn’t reflect the reality of your buying environment, every downstream process including segmentation, scoring, forecasting, and Microsoft Copilot insight is operating on a broken foundation.
✦ Microsoft Copilot Opportunity
Copilot in Dynamics 365 Sales can surface data inconsistencies and flag duplicate accounts, missing contact fields, and stale opportunity records without requiring a manual data audit. But Copilot’s suggestions are only as good as the schema it works from. Before relying on any AI, be sure to clean your field definitions and enforce your data entry standards.
| WHAT WE TYPICALLY FIND | THE FIX |
| • Duplicate account and contact records | • Deduplication rules + merge strategy within Microsoft Customer Insights – Data |
| • Customer lifecycle stage fields lack governing logic or thresholds | • Business rules need to enforce field requirements by stage |
| • No master data management policy | • Ownership and record governance policy is established and governed |
| • Custom fields are built but never used | • Phased data remediation sprint is activated |
GAP #2: The Marketing-to-Sales Handoff Is Still a Prayer
Lead Lifecycle & Qualification Architecture
In most Dynamics 365 environments, a “handoff” means someone sends a list of “MQL’s” to sales and hopes for the best. There’s really no definition of a qualified lead versus what a genuine revenue opportunity may look like within the CRM application. Likely, there’s also a lack of automated workflows or escalation when a qualified lead demonstrates intent. There’s also generally no visibility or coordination into what needs to collectively happen across revenue teams to drive conversion.
Sales ends up blaming Marketing for bad leads…Marketing blames Sales for not following up – and both are usually right (and wrong). Unfortunately, the data to resolve the argument doesn’t exist because the “handoff” never happened.
This is the single highest-leverage fix in most Microsoft Dynamics environments. A well-designed pipeline with agreed lead qualification definitions, scoring thresholds, automated routing, and SLA tracking can transform how the revenue team operates within 30–60 days.
✦ Microsoft Copilot Opportunity
Copilot in Dynamics 365 Customer Insights can now recommend the next best journey action based on engagement signals, but it can only optimize handoff timing if the handoff itself is defined. Once you’ve built a structured lead management process, Copilot becomes a powerful signal interpreter and can identify the right moment to transition a prospect to Sales based on behavior patterns, not just arbitrary lead scoring thresholds.
| WHAT WE TYPICALLY FIND | THE FIX |
| • No documented lead qualification definition or conversion rules | • Co-designed lead/opportunity definition with revenue teams (sales, marketing, CS) |
| • Manual, inconsistent handoff process or parallel GTM motions amongst teams | • Lead qualification model in Dynamics Customer Insights |
| • No lead routing rules or established “next best action” based on prospect behavior | • Automated routing and assignment queues in Dynamics Sales |
| • Zero visibility into the customer lifecycle, SLAs, and funnel activity | • SLA tracking dashboard developed with rep-level visibility |
GAP 3: Journeys That Launch and Die
Automation Architecture & Engagement Continuity
Microsoft Dynamics Customer Insights – Journeys is one of Microsoft’s most powerful Dynamics tools, though many don’t realize it. It’s also the application that’s typically the least utilized within the revenue engine architecture. Organizations need to resist simply building a simple engagement journey at go-live only to declare automation success and never touch it again. It’s the mentality of “upload a list and blast an email” that must die.
When that happens your prospects fall into dead ends where existing customers who are looking to expand their relationship with you get the same nurture content as cold prospects. We also typically see retargeting sequences for churned accounts don’t exist, and behavioral trigger-based journeys may be on the roadmap but never get built.
The consequence is a marketing engine that sends volume but generates little qualified or attributable revenue. High send rates and low engagement aren’t a creative problem – they’re a revenue engine architecture problem.
✦ Microsoft Copilot Opportunity
Copilot’s content generation capabilities within Dynamics Customer Insights–Journeys can dramatically accelerate journey build time – generating email copy, subject line variants, preliminary journeys and segment criteria from natural language prompts. Organizations that previously couldn’t maintain more than two or three active journeys can now operate a journey portfolio without adding headcount.
| WHAT WE TYPICALLY FIND | THE FIX |
| • One or two journeys may be active, but many others are abandoned | • Journey architecture maps across the full customer lifecycle |
| • No trigger-based or behavioral automation exists | • Trigger catalog is expanded to align with CRM workflows and customer behavior |
| • No re-engagement or lifecycle stage logic exists | • Segment governance includes refresh schedules via Customer Insights – Data |
| • Segments are built once and never updated | • Copilot-assisted content production workflow is utilized |
GAP 4: Pipeline That Feels Good But Doesn’t Forecast
Opportunity Management & Sales Process Integrity
If you ask most sales leaders if their pipeline is healthy, they’ll likely say yes but if you pull their Dynamics data, you’ll likely find that up to 40% of their opportunities haven’t been touched in 45 days. You’ll likely also see that close dates continuously roll forward, and customer lifecycle stage progress means nothing. The focus is on activity metrics rather than bottom-line revenue performance.
A pipeline that can’t be used to forecast is worse than having no pipeline at all because it creates a false sense of confidence that delays corrective action.
✦ Microsoft Copilot Opportunity
Copilot for Sales can summarize meeting notes, flag stalled deals, suggest next best actions, and draft follow-up communications – all inside the sales team’s existing workflow in Outlook and Teams. Recommendations are only useful if the underlying opportunity data is trustworthy, so organizations need to focus on optimizing the data first and let Copilot amplify from there.
| WHAT WE TYPICALLY FIND | THE FIX |
| • Business Process Flows lack operational governance and discipline | • Business process flow redesign with milestone conversion criteria |
| • Lack of deal close timing governance or escalation triggers | • Automated deal alerts and manager notifications |
| • Forecast categories that don’t reflect actual sales confidence | • Forecast category training and field governance |
| • Lack of deal review cadence tied to CRM data | • Copilot for Sales enablement tied to pipeline inspection |
GAP 5: Reporting That Describes But Doesn’t Decide
Revenue Intelligence & Performance Visibility
Most Dynamics environments have value measurement dashboards but very few have decision-grade intelligence. The difference is that descriptive reporting tells you what just happened, but revenue intelligence tells you what to do next and why.
Leadership may be able to evaluate pipeline by stage and rep, but what they likely don’t see is sales velocity by segment, conversion rate by lead source, marketing attributed revenue, customer lifetime value trends, or churn risk signals for vulnerable accounts. The data to answer those questions exists in Dynamics, but it’s just not connected in a way that produces insight.
✦ Microsoft Copilot Opportunity
Copilot in Power BI allows non-technical users to query their data in plain language and receive instant visualization. This is a genuine democratization of analytics, but natural language queries only work when the underlying data model is clean, relationships are properly defined, and semantic labels make sense to someone who isn’t the organization’s CRM administrator.
| WHAT WE TYPICALLY FIND | THE FIX |
| • Out-of-box dashboards are not used by leadership | • Revenue intelligence framework is aligned to leadership KPIs |
| • No attribution model is built to connect marketing to revenue | • Dataverse-to-Power BI data model is built with proper relationships |
| • Power BI is deployed but disconnected from other Microsoft Dynamics data | • Multi-touch attribution logic is configured in Dynamics Customer Insights – Data |
| • Reporting is done in Excel instead of within the platform | • Copilot-enabled executive dashboard with plain language querying is built and utilized |
GAP 6: Adoption That Peaked at Go-Live
User Enablement & Sustained Value Realization
This is the one gap that nobody wants to say out loud. The system isn’t the problem – humans are. They were trained at go-live on a system that looks nothing like the one they used previously. Processes probably changed, fields were added, and marketing journeys were modified – but the training didn’t stick.
The result is a team that developed workarounds for features they didn’t understand, avoided parts of the system that felt intimidating, and settled into the 20% of Microsoft Dynamics that felt familiar. The other 80%, including most of the AI capabilities, still sits untouched.
Adoption isn’t a launch-day event. It’s an ongoing practice, and it’s the most direct lever on time-to-value for every capability in the platform.
✦ Coffee + Dunn AI Opportunity
Coffee + Dunn’s proprietary Microsoft Dynamics AI Powered Knowledge Hub is a powerful knowledge management tool in the hands of users who want to understand how to best use the Microsoft Dynamics Revenue Engine applications (Dynamics Sales, Customer Insights, Customer Service, Power BI) and how they can realize speed to value, revenue growth, and better customer engagement outcomes with Microsoft Dynamics.
| WHAT WE TYPICALLY FIND | THE FIX |
| • No/limited post-go-live training program with the organization | • Role-based enablement tracks (marketing, sales, leadership) and Knowledge Hub |
| • Copilot features licensed but employees are not empowered or trained to use them | • Copilot feature activation + contextual training |
| • High-value CRM modules are avoided due to perceived complexity | • Power user certification program |
| • No internal champion or power user network exists | • Quarterly adoption review and ongoing DUNN Right Services tied to platform KPIs |
How Does Your Revenue Engine Score?
Typical findings in mid-market Dynamics 365 environments, based on Coffee + Dunn Revenue Engine Assessment data.
| Clean, unified customer data | ███████████████████ 28% |
| Structured lead/opportunity orchestration | ████████████████████ 34% |
| Active multi-stage journey automation | █████████████████ 22% |
| Trustworthy pipeline & forecast data | ███████████████████ 31% |
| Decision-grade revenue intelligence | ████████████████ 19% |
| Sustained platform adoption & Copilot use | █████████████████ 24% |
Organizations scoring below 50% across three or more dimensions typically have significant unrealized revenue potential from their existing Microsoft Dynamics investment.
The Bottom Line on Copilot
Microsoft has made extraordinary investments in embedding Copilot across the Dynamics 365 suite — in Sales, Customer Insights, Marketing, and Power BI. Natural language querying, deal summarization, content generation, next best action recommendations, and autonomous journey optimization are all within reach.
But here’s what we tell all of our clients: “Copilot amplifies your revenue architecture. It doesn’t replace it.” If your data is dirty, Copilot surfaces dirty insights faster. The organizations that will extract the most value from Microsoft’s AI investments in the next 18 months are the ones that close these six gaps now because a clean Microsoft Dynamics revenue engine foundation will turn Copilot into a revenue multiplier.
You already own the platform. The question is whether you’re getting what you paid for it.
Find Your Gaps in 90 Minutes — Free
Coffee + Dunn will offer you a complimentary Revenue Engine Assessment for free. Let us map your current architecture against all six dimensions, understand your maturity, and deliver a prioritized action plan — no sales pitch, no obligation.
Request your assessment: coffee-dunn.com

Jeff Mikula
Senior Vice President, Advisory Services
A seasoned marketer with over two decades of marketing experience, Jeff is responsible for ensuring that our advisory products and services solve client go-to-market challenges, optimize marketing performance levels, and generate value across the customer experience.
Frequently Asked Questions (FAQs)
What are the most common gaps in a Dynamics 365 environment?
The most common gaps are fragmented customer data, broken marketing-to-sales handoffs, underdeveloped journey automation, inaccurate pipeline and forecast data, weak revenue intelligence, and low post-go-live adoption.
How does bad data affect Dynamics 365 performance?
When account, contact, and lifecycle data is incomplete, duplicated, or outdated, everything downstream suffers. Segmentation gets weaker, scoring becomes less reliable, forecasting loses accuracy, and Copilot insights become less useful.
How can we improve pipeline accuracy in Dynamics 365?
Pipeline accuracy improves when stages are clearly defined, deal progression is governed, close dates are managed consistently, and teams follow a regular review cadence based on CRM data. Clean opportunity data is the foundation of better forecasting.
Why is user adoption still a major issue after implementation?
Because go-live training is rarely enough. Teams often fall back on workarounds, avoid advanced features, and only use the parts of the platform that feel familiar. Without ongoing enablement, most of the system’s value stays untapped.
How does Copilot help inside Dynamics 365?
Copilot can help identify data issues, recommend next best actions, accelerate content creation, support journey development, summarize sales activity, and improve access to analytics. Its value increases when the underlying platform is well-structured.
What is the fastest way to get more value from Dynamics 365?
Start by fixing the foundational issues first: clean up customer data, define lead and opportunity processes, expand automation beyond one-off campaigns, improve pipeline discipline, and invest in role-based adoption and training.


