HubSpot

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:

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.

ControlDescription
Enable automatic import of CRM data into ProjectorTick 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 NowSkip the schedule and start a sync right now
Reenable ImportIf 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.
RefreshRefresh the Import Status and Migration Status areas

Import Status

The import status area shows information about your current run or previous run. 

FieldDescription
Status
  • Idle - The system is waiting for your next scheduled run. See the Next Run time to find out when this will be.
  • Pending - Your request to start importing CRM data has been sent. When this request is processed the status changes to Running.
  • Running - Projector is retrieving data from HubSpot.com. This may take a while depending on the size of your HubSpot and Projector installations. When complete, the status changed back to Idle, but the integration is probably not complete yet. This status only covers the retrieval of CRM data, it does not cover the actual pushing of that data into Projector. The pushing of data is covered by the Pending Migration section covered next.
  • Disabled - An error was encountered (click the ellipsis button for error details).
Last RunThe last time a run was attempted
Next RunThe 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.

StatusHubSpot ColumnProjector Column
Total ImportedShows 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 RunThe number of HubSpot entities we processed last runThe number of Projector entities we processed last run
Pending MigrationWhen 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 syncedSame as HubSpot column
Failed MigrationThe number of entities that could not be imported into ProjectorSame 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 TypeDescription
ClientA business you do work for
EngagementA collection of contract line items with a client 
ProjectWork that is done on a particular contract
EstimateEstimates 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.
EstimateLineItemThere 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.


Show If macro has stopped working

Visibility for Confluence requires an active app subscription