IntegrationsFX Troubleshooting for a MROIDashboardFX Win!

Posted by: Melissa Shoff Date Posted: November 17, 2023
Back to Case Studies

Issue

We set up a Netsuite integration very early on in our adoption of Workato fallowing a very basic mapping structure and launched it in April 2023.

When reviewing the MROIDashboardFX revenue tab, we saw $11 million in revenue showed from June-August, but the client identified that number as being close to what they’ve closed for the entire YTD!

So we needed to investigate further.

After doing so, we found that our integration was pulling the total amount found in the Sales Order, but also adding in the individual line items causing a duplication of the revenue amount to show in MCFX. YIKES!

 

Solution

  1. We worked with the client’s CRM technical lead to develop the correct logic needed to query the Sales Order revenue amounts we needed to pull into MCFX.
  2. Integrations Development updated the original mapping to follow the new logic.
  3. We had to continue troubleshooting and tweaking the rules slightly until all the old data was removed/replaces and we had the Sales Order date used as the open and closed deal dates.

Achievement

We are more accurately pulling in revenue values with a small margin of error due to the custom nature of the logic! If anything we are slightly under-reporting as opposed to over-reporting.

We can confidently report that from January – October, RF has spent $32k on their SEO campaign with WebFX – which breaks down to a little over $3200 a month. It’s driven over $1.4 million dollars in revenue in that same time period. This is a 4,259% ROI.

If there are any questions about accuracy, all we need to do is check the deals!! The External Deal ID matches their Sales Order record ID in Netsuite.

With this CRM-backed data, the account manager and OST can pretty confidently present upsell opportunities that will further capitalize on what’s working for them and what’s not!

Snippet/Screenshot/Link

https://app.webfx.com/marketingcloudfx/1134/mroi-dashboard/revenue?startDate=2023-01-01