This client does not use one CRM well. They actually are on the hunt for a CRM (Nutshell was not a good fit). And so getting revenue exports was a challenge in the first place just because there is not one defined digital location for all of their revenue records. I worked with the client on how we could get this data and where we could pull it, and we could not come up with a source with the data points we needed for the integration and import.
Felipe completely bossed this task up, by making a custom solution, using our new ability to map orderID and orderValue fields, to map these booking forms the client has on their website. He created a custom GTM event to fire once the user submits the last step of the form submission, which holds the orderID, and Value. This data then searches for the most recent booking form submission that captures the PII data, which allows us to attribute all of this revenue we are driving for this client!
Completing an “e-commerce like” integration with our clients custom website CMS. The CMS itself is managed by their team overseas, so it took some finesse to get the access we needed, paired with their team’s cooperation to get our codes implemented for GTM and MCFX!
Picture of the Order Submission Forms: https://webpagefx.mangoapps.com/msc/MTg5OTYyNV8xMzg1MjQ2NQ
We can see here that the booking forms precede the ultimate final order submission form as the order forms are representative of the last step of this client’s multi-step form.
We can see that the code Felipe added for the e-commerce dataLayer, is almost identical the GTM events we set up for our normal MCFX events!