Custom Hubspot CRM/Zapier Integration

Posted by: Macenzi Barker Date Posted: August 27, 2024
Back to Case Studies

Issue

This client originally had a standard Workato Hubspot CRM integration, but was far exceeding a reasonable amount of task usage included in their MCFX Foundation Plan. Our main client contact/technical POC then left the company, which caused internal shifts in how the team used the CRM and the data we were receiving.

Background:

  • They had nearly 500k contacts, most of which have multiple deals (created mega-contacts)
  • The client has an interesting conversion model, where all users who book an appointment are considered ‘Customers’ regardless of whether or not they actually showed up to their appointments (interesting use case where ‘Customer’ was based on a specific action instead of revenue gained)
  • The main objectives of the initial integration were ROI by channel metrics and dynamic audiences for ad targeting – they specifically wanted to be able to filter who was included in their ads based on whether or not they scheduled an appointment previously, and could not keep up with manual data imports because their 50+ nationwide locations would gain new customers every single day
  • They no longer use Hubspot’s standard objects for contact records, and instead have a sync with their Zenoti booking tool to create a Zenoti ID within Hubspot

Solution

Our team was able to rebuild this integration through Zapier and pull contact details through the Zenoti ID object inside Hubspot. The client’s team no longer recorded revenue in the CRM, so the main objective shifted to solely building dynamic audiences to be used in ad targeting, which was achieved through their custom setup.

The client’s team does not use standard Hubspot Deal Stages, so the integration instead updates using “Zenoti Appointment Data: Status”.

It is not a best practice to update a Customer360FX contact record to the ‘Customer’ stage unless they specifically purchased from us, so as a workaround, we updated everyone who booked an appointment (anyone who has a Zenoti ID) to thumbs up lead quality, and anyone in the ‘Closed’ or ‘Confirmed’ status to ‘Customer.’ This ensures we have some segmentation in reporting for people who have booked vs. people who have actually fulfilled their appointments, which will be valuable data for conversion feeds and ad optimization.

  • In a case where a client uses Hubspot’s Deal object and Deal Stages, it would be a best practice to map those CRM stages to various contact stages in MCFX and filter based on the external deal stage (ex. anyone in any Deal Stage of the Appointments Pipeline is considered a customer to the client, but we still have the flexibility to drill into where exactly they’re at in the funnel -> “Appointment Scheduled” vs. “Appointment Confirmed”)

Since the ROI data was no longer available, the team deleted the mega-contacts and messy data from the client’s MCFX profile for a clean setup moving forward.

Achievement

The team was able to cut red tape and WOW our client by delivering a custom Hubspot CRM Zapier integration that powers dynamic audiences for ad targeting.

Snippet/Screenshot/Link

Zapier developer thread