Retail Store Sales – IntegrationsFX How I Did It

Posted by: Nate Moser Date Posted: January 15, 2025
Back to Case Studies

Issue

This client is a big cheerleader for the work WebFX does, however they have two challenges with getting IntegrationsFX started for them.

  1. They are retail – this industry is very hard to stitch this data together because orders are usually stored in platforms like POS systems (point of sale) systems that rely on the sales clerk collecting their email/phone number data (more on this later).
  2. This clients POS system is very outdated. At one point we were chatting about the opportunity to use a Datapro upgrade to try and integrate, but there were lots of issues there, and ultimately we decided against that. And tuned our attention to getting this data import in progress.

Solution

We asked the client to send us an export from their POS system, and I have to give a huge shoutout to Noah the AM. He took the time to consolidate the rows of orders that came from the same order number, so we could avoid the risk of having duplicates/orders just looping open to closed. Now there was a pretty large issue with their email recording, many of the emails were not complete, or some parts that seemed like they just did not store correctly. So in my testing, we had about 40% of the emails filled out in our annual deals report sheet, but we had phone numbers, and that was our saving grace. The phone numbers were almost perfect on the deals export, and this really proved to help with the matching.

 

Something that is important to note is the amount of “CRM Data Cannel” revenue there is. I am almost 100% sure half of these deals would be SEO/other channel if we got clean email data from their system. This is something I mentioned to our POC as a point of improvement. This is a perfect example of a small change that can be a HUGE quick win.

Achievement

We were able to report on the closed won deals report over the past year and show some very very strong ROI numbers from our efforts.

Snippet/Screenshot/Link

Annual Results: https://webpagefx.mangoapps.com/msc/MjEyNTg0NF8xNDQzNjE2OA