CRMConnect: Mindbody → HubSpot

56min

Version 1.50 - v 2.8

CRMConnect: Mindbody → HubSpot is a turnkey integration solution between Mindbody and HubSpot. This is a bi-directional sync between Mindbody and HubSpot, giving HubSpot timely visibility over each client's information and behavior, including profile information, purchases, visits, bookings, membership, and contracts.

Mindbody client → HubSpot contact matching rules

Purpose of the matching rules

CRMConnect uses specific rules to match Mindbody clients to HubSpot contacts. The purpose of these rules is to track each client individually in HubSpot.

The main challenge these rules are meant to solve is that clients in Mindbody can have the same email which is not possible in HubSpot. This can happen with the following scenarios:

1. Clients can have multiple profiles in Mindbody.

This can happen with third-party intake form apps or when clients and staff members create separate client profiles.

2. Clients can have separate profiles on multiple Mindbody sites with different client IDs.

This will happen with cross-regional installs of Mindbody where a business has multiple Mindbody site IDs connected and when clients are added across these sites.

3. Members of the same family will have separate client profiles in Mindbody sharing the same email.

This is a common practice, especially when clients are minors. The CRMConnect matching rules rely on the "Pays For" relationship feature in Mindbody to connect parents and children (or corporations and employees.) Please make sure these "Pays For" relationships are set up in Mindbody in order for CRMConnect to establish these relationships in HubSpot.

Matching rules

Matching Rule 1: Match the Mindbody SiteId~ClientId

When a match is established between a Mindbody client and a HubSpot contact, a combination of the Mindbody SiteID~ClientID is entered in the HubSpot custom property called Site Client ID. This field is used to search for a match first.:

Custom property "Site Client ID"
Custom property "Site Client ID"


Matching Rule 2: First, last, and email

If no contacts are found with Rule 1, a search is done to match the email, the first name, and the last name.

Once a match is made between a client in Mindbody and a contact in HubSpot using the email, first name, and last name, the link between them is cached by CRMConnect to ensure that future email and name changes in Mindbody are synced with the HubSpot contact.

This rule will connect the Mindbody client to the same HubSpot contact if:

  • The client has duplicate profiles in Mindbody
  • The client has profiles on separate Mindbody systems (cross-regional)

This rule also ensures that the link isn't broken between the Mindbody client and the HubSpot contact when client profiles are merged in Mindbody to eliminate duplicates (a recommended practice.)

Matching Rule 3: Match if the Mindbody client and HubSpot contact have the same email and an empty "Site~Client Id" custom HubSpot property

If a HubSpot contact is found with an empty "Site~Client ID" property and the same email as the Mindbody client, a match is made.

Matching Rule 4: Relationship: "Pays For" = Company

All clients with the relationship "Pays For" or "Is Paid for by" in Mindbody are added to the same company in HubSpot. The relationship is used to add a HubSpot custom association label between the contact and the company.

Mindbody clients in HubSpot company
Mindbody clients in HubSpot company

Custom association lables are added
Custom association lables are added


When creating companies in HubSpot the [First name] + [Last name] + "Family" of the client who pays for others is used to name the company, like this: John Smith Family

The word "Family" used in the naming of the company in HubSpot is customizable in the CRMConnect integration settings. For example, it can be changed to "Company" for corporate clients, like this: Acme Company but the "Pays For" relationship should still be used in Mindbody when connecting employees to their company in order for CRMConnect to create the HubSpot company and associate the contacts to that company.

Company-triggered workflows can be used in HubSpot to send automated emails to the contact who pays for other contacts with no emails.

Matching Rule 5: Email is empty if already taken

If the email for a contact is already taken and the First and Last names do not match in HubSpot, the contact is added without an email and the Mindbody email is added to the custom property called "Email in Mindbody".

HubSpot property "Email in Mindbody"
HubSpot property "Email in Mindbody"


Contact record syncing features

Feature 1: Correcting Mismatched Contacts between Mindbody (MBO) and Hubspot

If you find that an MBO contact is linked to the wrong Hubspot contact, you can easily correct this:

  1. Navigate to the contact's profile in Mindbody.
  2. Assign the client index "Reset sync in HubSpot" and set it to ON.
  3. Save the changes.

By doing this, the system will automatically reset the MBO contact, prompting it to resynchronize with a new Hubspot contact record.

Feature 2: Handling MBO Contacts with Duplicate Email Addresses

In cases where multiple MBO contacts (e.g., family members like a Mother, Daughter, and Son) share the same email address but have different names:

  1. A new Hubspot account will be created for each MBO contact.
  2. The email property in the newly created Hubspot account will be left blank.
  3. Instead, the Hubspot property labeled "Email in Mindbody" will be populated with the shared email address from the MBO account.

Special Case: If one of these contacts, let's say the Son, has another account in a different MBO site but uses the same email address:

  1. The system will prioritize matching based on the First Name, Last Name, and the "Email in Mindbody" property.
  2. If these details match, even if the MBO contact has different client IDs across sites, it will be recognized as the same client in Hubspot.

This ensures that the same client is not duplicated in Hubspot due to having accounts in multiple MBO sites with the same email address.

HubSpot custom left sidebars

Custom properties created by CRMConnect are grouped by topics in custom left sidebars for contacts and deals.

HubSpot contact custom left sidebar
HubSpot contact custom left sidebar

HubSpot deal custom left sidebar
HubSpot deal custom left sidebar


CRMConnect creates and syncs more than 100 custom properties between Mindbody and HubSpot. Not all custom properties created by CRMConnect are added to custom left sidebars. To view all properties created by CRMConnect for contacts and deals, click Actions / View all properties and expand the Mindbody property group.

Document image

Document image


HubSpot Contact record left sidebars

Contact left sidebar: Mindbody Profile

Hubspot left sidebar
Hubspot left sidebar








Contact left sidebar: Mindbody Membership

HubSpot left sidebar
HubSpot left sidebar




Contact left sidebar: Mindbody Contract

HubSpot left sidebar
HubSpot left sidebar




Contact left sidebar: Mindbody Visits



HubSpot left sidebar
HubSpot left sidebar






Contact left sidebar: Mindbody Classes



HubSpot left sidebar
HubSpot left sidebar






Contact left sidebar: Mindbody Appointments

HubSpot left sidebar
HubSpot left sidebar


Contact left sidebar: Mindbody Appointment Related Service



HubSpot left sidebar
HubSpot left sidebar






Contact left sidebar: Mindbody Sales

HubSpot left sidebar
HubSpot left sidebar




Contact left sidebar: Mindbody Appointment Series

HubSpot left sidebar
HubSpot left sidebar




Contact left sidebar: Mindbody Indexes

HubSpot left sidebar
HubSpot left sidebar




HubSpot Deal record left sidebars

Deal left sidebar: Mindbody Appointment

HubSpot left sidebar
HubSpot left sidebar




Deal left sidebar: Mindbody Appointment Related Purchase

HubSpot left sidebar
HubSpot left sidebar




Deal left sidebar: Mindbody Sale

HubSpot left side bar
HubSpot left side bar




List of HubSpot Custom Properties

90 custom properties for the contact record



HubSpot custom properties
HubSpot custom properties






20 custom properties for the deal record for appointments

HubSpot custom properties
HubSpot custom properties




22 custom properties for the deal record for sales

HubSpot custom properties
HubSpot custom properties




Appointments Pipleline Overview

The Appointment Pipeline ensures that appointments from Mindbody are regularly updated every 15 minutes and seamlessly converted into Hubspot deals. This pipeline lists each appointment as a deal, providing comprehensive information, including relevant purchase details. Furthermore, every deal is automatically updated to reflect any changes, such as schedule adjustments, status updates, or remaining counts for appointment series.

Sales Pipeline Overview

Sales from Mindbody are processed every night, and all the sales from the day are converted into Hubspot deals. This pipeline, created by CRMConnect, allows you to measure and itemize every purchase made by your clients. By connecting revenue to activities such as newsletters, coaching, and sales activities, you can finally measure the effectiveness of everything your company and staff do. Please note that as of now, CRMConnect does not capture updates for Mindbody Comps and Account payment transactions. Only sales involving cash equivalents are recorded to avoid double-counting the sales amounts.

Visits Update Overview

Visits from Mindbody are processed every night, and all the visits from the day are updated to the Hubspot contact record. This information is crucial for automating your growth and allows you to know when a client last visited your location and for which service. You can use this information to personalize your communication and respond accordingly. Additionally, Hubspot will now know exactly when your client is scheduled to come in next for a class or appointment. This allows you to take various actions, such as sending automated preparation emails or removing them from a re-engage sequence. Knowing the upcoming class or appointment bookings is essential for sending the right message at the right time to the right client.

Mindbody Client Update Overview

Rest assured that your client profiles will be fully synchronized in both directions. You can trust that all the necessary information about your Mindbody clients will be automatically synced with HubSpot. Additionally, you have the flexibility to selectively choose HubSpot contacts and easily push them to any connected Mindbody site or location using the Hubspot Contact property "Push to Mindbody". Alternatively, you can use a workflow to efficiently complete this task. When the basic Mindbody client profile fields, such as Name, Email, Phone Fields, Address, Birthday, Gender, Referred By, Home Location, Send Promotional and Schedule Emails, Send Text reminders, and Profile Notes, are updated, you can be confident that they will be seamlessly synced to HubSpot.

Setup Guide

Connecting HubSpot to your CRMConnect account

Step 1: In the menu click Connections

Step 2: Click the Connect App button

Document image


Step 3: Click HubSpot from the apps listed

Document image


Step 4: Select the checkbox agreeing to give APIANT access to your HubSpot Hub and click Connect app

Document image


Accessing CRMConnect Settings

To access the CRMConnect Settings, click the drop down under your name at the top right of your screen

Document image


To navigate to different setting categories, click the All Settings drop down and select the settings you want

Document image


Greyed out settings are read-only. Contact support if you would like some changes

Move your mouse above each item to reveal help text

Entries are saved automatically. Be cautious when making changes.

General settings

Document image


Mindbody settings

Document image


HubSpot settings

Document image


Assigning Mindbody Site ID Name to HubSpot Owner

This support article outlines the methods for assigning a Mindbody site ID name to a HubSpot owner, ensuring effective and organized management of contacts and deals within the CRM system.

There are several approaches to assigning the Mindbody site ID name in HubSpot:

  1. Using the Master Site ID Name from Mindbody: Utilize the name assigned to the master site ID in Mindbody. This ensures consistency across both platforms.
  2. General Naming: Opt for a more generic name that broadly represents the site without focusing on specific locations.
  3. Site ID Number as Name: Directly use the Mindbody site ID number as the name in HubSpot.

The Site Name in HubSpot represents the complete Mindbody site, which may include multiple locations. To avoid confusion, it is recommended to:

  • Avoid using individual location names as the site name.
  • Choose a name that collectively represents all locations under the site.

Example: For a site ID like 148045, which includes locations such as Memorial, Red Ranch, East University, and River Bend, a suitable site name could be "Houston Area Studios" or "Citywide Wellness Centers". These names reflect the collective presence without being location-specific.

The following properties are created in HubSpot using the site name:

  • [Site Name] Create Date
  • [Site Name] Member Status
  • [Site Name] Total Visits

These properties help in tracking and managing customer interactions and activities across all locations under the site.

The HubSpot owner name should be the email of a user in HubSpot. This email is crucial for:

  • Assigning an owner to new contacts coming from Mindbody.
  • Managing deals (sales or appointments) created by CRMConnect.

Note: It is important that the HubSpot owner names correspond to actual user emails in HubSpot for accurate assignment and management of CRM records.

When integrating Mindbody with HubSpot, carefully consider the naming conventions for site IDs to ensure clarity and effective management within the CRM system. The chosen name should represent the collective identity of all locations under the site and align with a valid HubSpot user email for ownership assignment.

Creating Workflows and Lists for Clients with Future and No Future Appointments

General Overview:

This guide will help you understand how to create workflows and lists to identify clients with future appointments as well as those with no future appointments. By implementing these workflows and lists, you can efficiently manage client appointments and identify those who need follow-up emails to encourage new bookings. These are template workflows and lists that you can use to build from. Do not delete the ones that are labeled APIANT, but clone them and then create new ones from there to enhance what is needed for your business.

Steps to Create Workflows and Lists:

To start, you'll need to create workflows that flag deals by evaluating the appointment date and time. This will determine whether the appointment is upcoming, in the past, or canceled. Follow these steps to set up the workflows:

Step 1: Access Your Hubspot Workflow Automation Tool

Step 2: Create a New Workflow "Deal-based trigger"

  • Name the workflow appropriately, such as "Flag upcoming appointments"

Step 3: Set Trigger Criteria

  • Set the trigger for the workflow based on the "MB Appointment date & time is more than 0 days from now" AND "MB Visit status is not equal to any of cancelled" AND "Pipeline is any of Mindbody Appointments".
  • Set the Action
    • Set property value: "Set 'Upcoming or Past' to Upcoming".
  • Document image
    

Step 4: Create a New Workflow "Deal-based trigger"

  • Name the workflow appropriately, such as "Flag past appointments"

Step 5: Set Trigger Criteria

  • Set the trigger for the workflow based on the "MB Appointment date & time is more than 0 days ago" AND "Pipeline is any of Mindbody Appointments".
  • Set the Action
    • Set property value: "Set 'Upcoming or Past' to Past".



Document image


Step 6: Create a New Workflow "Deal-based trigger"

  • Name the workflow appropriately, such as "Flag cancelled appointments"

Step 7: Set Trigger Criteria

  • Set the trigger for the workflow based on the "Deal stage is any of Cancelled (Mindbody Appointments)" AND "Pipeline is any of Mindbody Appointments".
  • Set the Action
    • Set property value: "Set 'Upcoming or Past' to Past".
  • Document image
    

Step 8: Access Your Hubspot Lists Tool

Step 9: Create a Contact-based Active list

  • Name the list appropriately, such as "Clients with future appt"

Step 10: Define Conditions

  • Add conditions to check if the appointment date is in the future or the past.
  • Contact is associated to: Any Deal AND associated Deal has all of: Upcoming or Past is equal to all of Upcoming AND Pipeline is any of Mindbody Appointments
  • 

    Document image
    

Step 11: Create a Contact-based Active list

  • Name the list appropriately, such as "Clients with no future appt"

Step 12: Define Conditions

  • Add conditions to check if the appointment date is in the future or the past.
  • "Total visits is greater than 0" AND "List membership" is not member of "Clients with future appt"

Step 13: Save and Use the Lists

  • Save the lists and use them to segment your clients for targeted communication. With your lists ready, you can now send follow-up emails to clients based on their appointment status.
  • Document image
    

Understanding Client Statuses in Mindbody

This guide is designed to help you comprehend the different client statuses you may encounter in Mindbody. These statuses are a crucial aspect of managing client relationships and can be found in the client profiles within your Customer Relationship Management (CRM) application. For a more detailed explanation, you can refer to the Mindbody support article here. Here's a breakdown of the various statuses: System Status: This is an automated status that reflects the client's current membership pricing option. Suspended: Indicates that the client's contract was active but is now suspended. This can be due to a suspension action taken on the Account Details screen or due to a scheduling suspension. Declined: This status is assigned when the client's most recent automatic payment, which should cover at least one membership pricing option, has been declined. It's important to note that this is a high-priority status. It will override other membership statuses on the client's account. For instance, if a client has an active membership and another with an expired credit card, the overall status on the client's Info screen will be shown as Declined. Active: The client has an active membership recorded in the system. Terminated: This status is used when a client's active contract has been terminated. This action is typically recorded on the Account Details screen. Expired: This status is assigned to clients who have previously purchased a membership pricing option, but the option has now expired or has been fully utilized. Non-member: Indicates that the client has never purchased any membership pricing option. Understanding these statuses is essential for effectively managing your client base in Mindbody. Each status provides key information about the client's current engagement level and membership state, allowing for better client service and management.

Document image