HubDB best approach for a benchmark tool recomendations
resolver
Hi family 😉
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.
HubDB best approach for a benchmark tool recomendations
resolver
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
2.- Second Zap. Lookup spreadsheet Row - Create spreadsheet row
3.- ZAP Lookup spreadsheet row and update contact information in Hubspot.
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)
HubDB best approach for a benchmark tool recomendations
resolver
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 🙂
HubDB best approach for a benchmark tool recomendations
resolver
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
2.- Second Zap. Lookup spreadsheet Row - Create spreadsheet row
3.- ZAP Lookup spreadsheet row and update contact information in Hubspot.
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)