HubDB best approach for a benchmark tool recomendations

SOLVE
Top Contributor | Gold Partner | HubSpot Certified Trainer

Hi family Smiley Wink

 

I´m looking to create a benchmark tool with hubdb. 

 

Input will be :  Turnover:  selection from a table of 5 options. each table will have the following information:

Sesions, leads, MQLs, Clients. 

 

I will use a form to capture input for the user : sesions, leads,MQLs, clients.

 

I will like to operate with the capture information in order to create the benchmark in terms of % difference and to be recorded in hubspot contact information for example ( not a floating data)

 

My idea is to use Hubdb to host the becnhmark information bud i´m not sure about how to operate it.

Any idea will be great!!

thanks in advance family!

JP Smiley Wink)

 

 

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Highlighted
Top Contributor | Gold Partner | HubSpot Certified Trainer

Hi i just find a way in a walk arround is not the best way, bad it works.

 

Here it is.

 

- Create a form with the labels you want.

 

 

Go to Zapier.  ( we will create 3 zaps)

 

1.- Zap .- Hubspot to Google Sheets

Captura de pantalla 2018-03-06 a las 9.34.13.png

 

2.- Second Zap.  Lookup spreadsheet Row  - Create spreadsheet row

Captura de pantalla 2018-03-06 a las 9.34.58.png

 

3.- ZAP  Lookup spreadsheet row and update contact information in Hubspot.

Captura de pantalla 2018-03-06 a las 9.36.58.png

 

 

Summary what is done.

 

- push information to a google spreedsheet 

- look for data row selector in the same google spreedsheet ( what it should be the bechmark data )

- Get the raw data of the selection and push in a separate sheet all information including calculate rows.

- Post all the raw in hubspot as an update contact information.

 

From this point in hubspot i´m going to create a thank you page where i will use all the data to create a Interactive Funnel Graphic ( this is going to be this week)

 

Will keep you post it!

JP

Smiley Wink

 

 

 

Reply
0 Upvotes
3 Replies 3
Community Manager

Hey @jpsanchez do you have a preview/live page you are working on or code snippets to share? I'll dig into this and see who we can connect you with to lend their knowledge Smiley Happy

Reply
0 Upvotes
Top Contributor | Gold Partner | HubSpot Certified Trainer

Nop at this point. I have found another walk arroud:

 

A LP with a form asking for the data.

 

ZAPIER

get data from Hubspot and put data in a google spreedsheet.

OTHER ZAPIER

will select the data in order to calculate in the spreedsheet. 

Push results to Hubspot. ( custom properties) 

 

I´m not pro with zapier so i just hire an expert yesterday in order to create this two zapier. ( will be happy to share with you when it´s done)

I understand this is not the best way.

KR

JP 

 

 

Reply
0 Upvotes
Highlighted
Top Contributor | Gold Partner | HubSpot Certified Trainer

Hi i just find a way in a walk arround is not the best way, bad it works.

 

Here it is.

 

- Create a form with the labels you want.

 

 

Go to Zapier.  ( we will create 3 zaps)

 

1.- Zap .- Hubspot to Google Sheets

Captura de pantalla 2018-03-06 a las 9.34.13.png

 

2.- Second Zap.  Lookup spreadsheet Row  - Create spreadsheet row

Captura de pantalla 2018-03-06 a las 9.34.58.png

 

3.- ZAP  Lookup spreadsheet row and update contact information in Hubspot.

Captura de pantalla 2018-03-06 a las 9.36.58.png

 

 

Summary what is done.

 

- push information to a google spreedsheet 

- look for data row selector in the same google spreedsheet ( what it should be the bechmark data )

- Get the raw data of the selection and push in a separate sheet all information including calculate rows.

- Post all the raw in hubspot as an update contact information.

 

From this point in hubspot i´m going to create a thank you page where i will use all the data to create a Interactive Funnel Graphic ( this is going to be this week)

 

Will keep you post it!

JP

Smiley Wink

 

 

 

Reply
0 Upvotes