CRMConnect: Mindbody → HubSpot
Link to the product page: https://apiant.com/mindbody-hubspot-integration-automation
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.
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.
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.:
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.
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.
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.
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".
If you find that an MBO contact is linked to the wrong Hubspot contact, you can easily correct this:
- Navigate to the contact's profile in Mindbody.
- Assign the client index "Reset sync in HubSpot" and set it to ON.
- Save the changes.
By doing this, the system will automatically reset the MBO contact, prompting it to resynchronize with a new Hubspot contact record.
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:
- A new Hubspot account will be created for each MBO contact.
- The email property in the newly created Hubspot account will be left blank.
- 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:
- The system will prioritize matching based on the First Name, Last Name, and the "Email in Mindbody" property.
- 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.
Custom properties created by CRMConnect are grouped by topics in custom left sidebars for contacts and deals.
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.
Contact left sidebar: Mindbody Appointment Related Service
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 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 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.
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.
Step 1: In the menu click Connections
Step 2: Click the Connect App button
Step 3: Click HubSpot from the apps listed
Step 4: Select the checkbox agreeing to give APIANT access to your HubSpot Hub and click Connect app
To access the CRMConnect Settings, click the drop down under your name at the top right of your screen
To navigate to different setting categories, click the All Settings drop down and select the settings you want
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.
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:
- 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.
- General Naming: Opt for a more generic name that broadly represents the site without focusing on specific locations.
- 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.
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.
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".
-
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".
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".
-
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
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.
-
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.