Syncing ServiceTitan Campaign Source/Medium Data For Deal Attribution Troubleshooting & Custom Reporting

Posted by: Melissa Shoff Date Posted: January 13, 2025
Back to Case Studies

Issue

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.

Solution

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.

Achievement

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.

Snippet/Screenshot/Link

https://lookerstudio.google.com/reporting/6fcb0ff3-9748-4740-b827-b0cdee262da7