HubSpot
- Chris McFarlane (Deactivated)
Projector provides a one-way sync from HubSpot into Projector. When you add new deals or companies in HubSpot, they can be automatically detected and brought into Projector. With this information in hand you can now forecast future revenue based on your sales conversion rates. There is also much more an integration can provide.
- Import HubSpot.com companies as clients into Projector, including client names, hierarchies, address and billing information.
- Import HubSpot.com deals as both non-billable business development and billable projects.
- Avoid double data entry between Projector and HubSpot
The HubSpot.com integration is specific to each organization's business requirements. You can choose what data will be synchronized, when that data will be synchronized, and when synchronization will stop. A professional consultant from Projector will work with your Projector and HubSpot administrators to configure your installation around your business' needs.
The HubSpot Integration settings are configured within the Management Portal by choosing View | Integration | CRM Systems | Integration Settings. Once properly configured (see below), checking the box for Enable automatic import of CRM data into Projector will have you up and running.
Permissions and Settings
HubSpot.com Professional Edition or higher is required for use with Projector.
HubSpot sandbox testing may require the assistance of Projector support to set up. This is to set the proper end point for web service calls.
Access to the integrations tab in Projector requires the global permission System Settings set to Update.
You can optionally notify people when the HubSpot integration fails through the system notification CRM Automation integration disabled due to a failure and when entities fail a migration.
Engagements are only updated if the engagement stage permission Allow Updates from CRM Automation is enabled.
Projects are only updated if the project stage permission Allow Updates from CRM Automation is enabled.
Imports are scheduled every hour by default. If you require a custom schedule, please contact Projector support.
When you run reports, projections can be based on estimates or bookings. This is driven by the project stage permission Base Projections On.
An underlying user must be chosen to run the HubSpot integration. We recommend setting up a generic user that will never leave the organization. This prevents cutover issues if a user were to leave your organization. It also creates a clear audit trail about what changes were done via automation and which were done interactively. Whichever user you choose, they should have the following permissions:
- Cost center permission Create projects and engagements
- Cost center permission Maintain Advanced Project and Engagement Setup
- Cost center permission Maintain Projects and Engagements
- Global permission Clients
On the HubSpot side of the house, the following permissions are necessary for the HubSpot integration user:
- TBD
Automatic Import Editor
This section describes each of the controls on the page. One important term you should understand before proceeding is what we mean when we talk about Entities. There are both Projector Entities and HubSpot Entities. Because the terms in the two systems differ, we use this generic descriptor. The idea is to map each HubSpot entity to a Projector entity. So in HubSpot you might have a lead. That lead maps to a Projector project. Each is considered an entity.
General
See the table below for a description of the controls boxed in red.
| Control | Description |
|---|---|
| Enable automatic import of CRM data into Projector | Tick the checkbox to start importing data on a set schedule. If this is disabled, then you many not be authorized by HubSpot or the CRM module may be disabled in Projector. |
| Set Credentials | Credentials for Projector's HubSpot integration are set through an OAuth process in which you are asked to authorize a connection between HubSpot and Projector. Once you allow access, you must provide the username and password for your integration user's HubSpot account. After allowing the connection and authenticating with valid credentials, you can return to Projector, refresh the page content (refresh button bottom right of page), and you should be good to go. |
| Start Import Now | Skip the schedule and start a sync right now |
| Reenable Import | If there is an error during import then the Start Import Now button becomes disabled, the status reads as disabled, and an ellipsis button can be pressed to get the error details. Click Reenable once you have resolved the issue. |
| Refresh | Refresh the Import Status and Migration Status areas |
Import Status
The import status area shows information about your current run or previous run.
| Field | Description |
|---|---|
| Status |
|
| Last Run | The last time a run was attempted |
| Next Run | The date your next run will occur on. If your last run failed, or you have not configured your schedule yet, this will be blank. If you need to change the schedule that integration runs on, please contact the Projector support desk. |
Migration Status
The migration status area shows you how successful Projector has been at fetching your CRM data and translating it into Projector data. When talking about data, we really mean entities. A HubSpot.com entity is a piece of data that has been retrieved by Projector. This piece is then translated into a Projector entity. For example, you may have a HubSpot Account called Acme Corp. You want this to become a Projector client also called Acme Corp. The five categories below provide feedback on the data retrieval and translation process.
There are two columns in this area, one for HubSpot and one for Projector. You'll find that the numbers between the two columns don't match up. For example, we may detect 100 HubSpot entities, but 150 Projector entities. That occurs when a HubSpot entity maps to more than one Projector entity. For example, we detect one HubSpot Deal from which may result in multiple Projector entities (e.g. client, engagement, project). At any time you can click the ellipsis button (...) to see the details of the HubSpot and Projector entities.
| Status | HubSpot Column | Projector Column |
|---|---|---|
| Total Imported | Shows the number of entities that we want to pull data from. | Shows the number of Projector entities that we will update based on the HubSpot data we found |
| Processed Last Run | The number of HubSpot entities we processed last run | The number of Projector entities we processed last run |
| Pending Migration | When a sync starts, all the entities start as pending. As each is processed, this number will tick down to zero. | Same as HubSpot column |
| Migrated | The number of entities that were successfully synced | Same as HubSpot column |
| Failed Migration | The number of entities that could not be imported into Projector | Same as HubSpot column |
Import Entities
Five types of entities can be created in Projector based on a HubSpot entity. When you inspect a table of entities, these are what you will find references to. They are described in the table below.
| Entity Type | Description |
|---|---|
| Client | A business you do work for |
| Engagement | A collection of contract line items with a client |
| Project | Work that is done on a particular contract |
| Estimate | Estimates are a value pulled into Projector from HubSpot . The estimate is a monetary amount that is then applied to a special title in your installation. The rate on that title divided into the contract value determines the number of hours of work. Finally, these hours are spread across a date range on a project. At this time there is no user interface into the contract amount, title, or date range. If you need this information you should review your HubSpot.com implementation notes. |
| EstimateLineItem | There is currently a one-to-one relationship between Estimates and EstimateLineItems, so the definition for an estimate also fits the definition for here. This may change if more granular HubSpot estimates are introduced. |
Import Details
To view the details of each import through the integration interface, use the ellipsis button to the right of the Migration Status table to pop up the Import Details dialog.
In Practice
This section makes the assumption that you have set up your integration through the Projector implementation team, your password is set, and the integration is running. If your integration is not set up yet, then contact the support team to see how it can be enabled. If your integration is set up, but not running, see the troubleshooting section.
Once a HubSpot integration is running, you mostly shouldn't need to do anything at all. At a set interval, Projector will pull information from HubSpot and update your clients, engagements, projects, and project estimates. If you want to trigger a new run immediately then click the Start Import Now button.
Occasionally something will go wrong with the integration though. If this happens, failure notifications will be sent to Projector users configured to receive CRM Automation Integration failure messages.
Troubleshooting
Some common problems with the HubSpot Sync
Disabled
Look to the Failed Migration section. Look at the details and see if you can figure out why those entities failed. If you cannot figure it out on your own, ask the Projector support team for help. Once the issues are resolved, click the Reenable Import button then click Start Import Now to test whether the fix worked.
Stuck
Occasionally it may seem that the import is stuck. This is most likely not the case. The import runs asynchronously so as not to disrupt users actively on the system. If the Pending Migration values have not changed for several hours, then please contact the support team for assistance. For large engagements each entity import may take several minutes.
Set Credentials Grayed Out
Tick the Enable Automatic Import checkbox. If that is also disabled, then you don't have the HubSpot module enabled. Contact Projector support to have them turn it on.