Handling Duplicate Order Submissions in LeadmanagerFX

Posted by: Nolan Barger Date Posted: June 20, 2023
Back to Case Studies

Issue

Our Ecomm integrations can be tricky because essentially what we do is create custom javascript that syncs order data to LeadmanagerFX.  Every time the website order thank you page gets refreshed, it’ll essentially fire a new “Form submission” to LeadmanagerFX.   This causes leadmanagerFX to have duplicate order submissions.

The issue scaled when users refresh the thank you page, because our automation in workato that marks order submissions as closed won was marking all order submissions as closed won.  So 1 order could be marked as 2 or 3 sales, if the person refreshed their page that many times.  Then all of our reporting numbers are off in MarketingCloudFX.

Solution

The solution here was to tweak our workato automation marking leads as closed won.  We now store “Order ID” which is a field we grab with our custom javascript.  So now, even if leadmanagerFX has 3 “leads” for 1 actual order, we only count revenue for 1 of them.  So customer360FX will have accurate data on lifetime revenue, and so will the MROIDashboardFX.

Achievement

We found a way to not overcount revenue for Ecomm Integrations.

Snippet/Screenshot/Link

Ariel’s solution –> https://webpagefx.mangoapps.com/msc/MTI1ODc5OF8xMTg0OTM5Ng

Workato automation –> https://app.workato.com/?fid=10216155#assets