Custom ERP Integration For Client Internal Reporting Needs

Posted by: Nolan Barger Date Posted: October 13, 2023
Back to Case Studies

Issue

The WebFX team was spending 3+ hours every week on reporting. The client really wanted it automated.  We were able to do this though integrationsFX.

Solution

They use another vendor for programmatic advertising.  They also wanted reports automated.

To do this, we:

  • Updated their programmatic advertising tracking snippet so it grabs the session ID (SID) from the LocalStorage of the site.  This is generated by the MarketingCloudFX snippet and stored in the back end of MarketingCloudFX.
  • Then, we worked with the client to determine exactly what data they found valuable.  Once we had that list, Nolan and Ariel created a custom integration that passes to an endpoint the client created for us.  The data we pass is email, phone, first visit source, last visit source, first visit medium, last visit medium, session ID, and MROI channel.
  • Now the client can build reports internally based on our raw MCFX data that meets their exact needs.
  • Better yet, since their programmatic agency collects our session ID and sends them daily exports of data, they can better gauge results of their progammatic.  Before they had nothing but anonymized events and they just had to trust the reports.  Now they’ll be able to see exactly what appointments saw a programmatic ad prior to scheduling an online appointment.

We went above and beyond for delivery, and everyone on the C-suite (CEO, CMO, and CTO) were happy with the end results.  The CTO was particularly impressed that we were able to complete this and a  little upset their programmatic agency can’t integrate (just send manual exports daily) because it creates more manual work for their team.

Achievement

We successfully integrated their custom ERP/CRM solution (built in-house) to send them MarketingCloudFX data to serve as their “Source of Truth” for internal reporting.

Snippet/Screenshot/Link