Missing out on the full scope of revenue for the company & inaccurate revenue metrics, impacting ROI metrics.
We adjusted our integration to include Orders from Dynamics, which are often orders from inbound phone calls and even email correspondence! We only wanted to pull in inbound phone and email orders, which may seem simple at first glance; however, this client uses a ‘bridge order’ system causing “duplicate” orders to appear. Essentially, you could have a contracted amount in the opportunity (total deal) and the orders would be different shipments, adding up to the opportunity sum. We identified this issue after numerous discussions and were able to appropriately filter out bridge orders from the integration. Along the way, we also identified that not all orders are closed immediately! They work through their own pipeline within the orders object with different statuses (in some cases, they even become closed lost). We went back to the specs again to appropriately identify particular statuses.
Additionally, during our integration testing, we found that expected revenue was not accurate! There was another field unlocked when an opportunity closes, prompting actual revenue. Initially, we were pulling estimated revenue. As an example, we had an opportunity logged for $2,500, but in actuality, it closed for just over $4,000. This is a huge discrepancy when looking at ROI and truly capturing lifetime value of a lead. We updated the integration to pull from expected revenue until the opportunity is marked as closed.
By making these updates, we were able to provide a full picture during our in-person meeting at the end of June and display the ROI behind our efforts and campaigns. Ultimately, with the accurate reporting, we were able to justify reallocating spend on SEO and taking away some budget from PPC based on the information we were able to gather and review.
Pulling in orders from Microsoft Dynamics & updating our revenue field for more accurate reporting with numerous rounds of edits!
Orders Project Specs: https://webpagefx.mangoapps.com/msc/MTgyNzY1OV8xMzcwMTY4Nw
Opportunity Project Specs: https://webpagefx.mangoapps.com/msc/MTgyNzY2MF8xMzcwMTY4OA
Marketing-Driven Sales Pipeline Report: https://app.webfx.com/marketingcloudfx/24736/analytics/reports/pipeline