The client is tracking attribution in ServiceTitan and the leads/jobs being driven by various marketing ROI channels was not always aligning with what we were reporting out of RevenueCloudFX.
While were were tracking standard form submissions, we weren’t tracking scheduled events because the client was using the V2 scheduler. As such, jobs booked from there weren’t being attributed to PPC, but to CRM Data.
PPC leads were of most importance to iron out, but it was valuable to know where differences were for all leads/jobs.
We hopped on a call with the client POC to iron out he CRM mapping specs since the current Client POC was different than the POC we had when setting up the CRM integration.
Then, I requested an additional mapping setup for CRM source and CRM medium → Service Titan campaigns can be set up with a source and medium indicator. So while source and medium might not be directly applied to the job, the campaign is and we can pull source and medium of the campaign and apply it to the job.
Now that we have the ServiceTitan identified source and medium for the campaigns as they are being applied to jobs, we can more easily spot discrepancies between our data.
We also have the ability to provide some custom reporting leveraging the Service Titan attribution. You’ll notice in the linked Looker Report, we are missing quite a bit of revenue from jobs attributed to local SEO (GBP/GMB). This helps us to more accurately report on revenue per MROI channel while we aim to improve our tracking where needed.
Additionally, we have built more trust and comradery with the Client POC who sees the work we are putting into things on this end. She finds value in the troubleshooting and collaborative nature of our partnership as well as our ability to customize a solution to find the ultimate source of truth.
https://lookerstudio.google.com/reporting/6fcb0ff3-9748-4740-b827-b0cdee262da7