Follow

ID259 - HubSpot Quarterly Business Review Overview & Sample:

Pull CEO Juice QBR via HubSpot

Jump to Overview | Samples | Variables | Alert Functionality | Linking to HubSpot |  Related Alerts |

Click to Subscribe

Overview

Overview

HubSpot is the most popular marketing automation solution within our client base. It is also a very competitive CRM. This provides Sales Rep ability to request Quarterly Business Review from HubSpot as CRM. 

Run Schedule: On Demand (every 10-min)

 

 

*  *  *

Sample

Sample

Lease Info (Object linked to Customer):

ID259Sample.png

 

 

*  *  *

Variables

Variables

ID978Variables.png

Variable1: Point this variable (by using drop down or link to 'Profile/Integrations section' to link to your HubSpot System Credentials entered on website under Integrations. See Linking to HubSpot instructions below on how / where to set.

VariableY: Enter Branch Numbers to consider to filter out branches or leave blank for ALL

 

 

*  *  *

Alert Functionality

Alert Functionality

1. To use, a HubSpot user would go to the Company and edit the QBR property (select "yes"). Within 15-minutes the QBR will be emailed to the email address associated with HubSpot User and the object will reset to blank so another can be sent when requested in future.

2. Be sure record-level HubSpot security is set up to prevent a user from accessing a Company that they should not have QBR info for.

3. Use THIS LINK for a detailed explanation of each page within the QBR.

4. Will only send IF the Company Record in HubSpot contains the corresponding eAuto Customer Number

ID259CustomerNumber.png

5. Will include 36-months of data for each request  AND will start with end of last month (does not include data from this month since billing and service activity may not completed for the month).

 

 

 

*  *  *

 

Linking to HubSpot

Linking to HubSpot

In order for us to be able to write / insert to your HubSpot, the following steps are required:

Step 1: Create HubSpot user for CEO Juice under astrid@ceojuice.com. At a minimum, we need "standard user" rights just to see records and verify. If we have to create custom fields (or objects) for them, we will need admin rights.

Step 2: Create a Private App for CEO Juice in HubSpot. This will need to be done by your HubSpot Administrator:

Go to settings / Select Private Apps under Integrations:

Image__2_.png

Give it name of CEO Juice ID978:

Image__3_.png

Set these Scopes with needed Read / Write permissions exactly as shown in screenshot:

Image__4_.png

After creating the new app, it will show this screen. Select "show" and then "copy" the token to enter on CEO Juice website (Step 3 below):
Image.png
Step 3: Enter the HubSpot Private App Token on CEO Juice website under Profile / Integrations: https://www.ceojuice.com/CustomerAdmin/Integrations into HubSpot NOT HubSpot Legacy Authentication. This will need to be done by someone with Admin rights to our website.
ID978Integrations1.png
ID978Int1.png
ID978Token.png
Step 4: Set Variable1 on your ID259 subscription to this Integration Name:
ID978Var1.png
Step 5: Let us know at help@ceojuice.com these steps are completed.

 

*  *  *

Related Alerts

Related Alerts

ID258 - OnDemand SSRS QBR

ID774 - Power BI QBR

ID978 - HubSpot eAuto Integration

 

*  *  * 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk