HubSpot Ideas

shivammishra

HubDB data in reports and workflows

Features like serverless functions to consume APIs and quering HubDB in Hubl makes hubspot a CMS to build more interactive applications quickly than just marketing websites. But we see one limitation in our use case where we are storing certain information in HubDB and need that information for marketing automation but its not accessible in workflows or in custom reports. Do you all think it would be nicer to have HubDB data made available in workflows and custom reports to create more customized experience for users?

34 Replies
chris_p_lukes
Contributor | Elite Partner

I agree.  As a Marketing/Sales Operations professional, I see so much potential for using HubDB for operational uses, such as referencing a look-up table in automation for controlling certain data mappings -- one example would be using a HubDB table to define Sales Territory Assignments for routing workflows, rather than building this out in workflow branches that are harder to maintain and review.

SteveHTM
Top Contributor | Partner

This is an concept I'd very much like to see  - perhaps as an option related to Operations Hub. The feature I really want is to use a Workflow step to set a value in a property through a HubDB table lookup.

 

For example: Set Property B via lookup of Property A in specific HubDB table

 

Seems like a fairly straightforward idea doesn't it?

yasiooy
Participant | Diamond Partner

This would work great for us and for our clients - seems like a good direction to go forward with!

roushan
Member

The worst mistake CRM users make is using custom properties to store data as then you end up with thousands of fields that are used by the system and don't benefit the user. This is where HubDB could come in, and remove the 'clutter of a thousand fields' but allowing users to store data in a relational data store and produce reports/workflows of the back of this.

jeremiahp
Member

I also agree with this. We are working on creating a community of trainers and we need to be able to expose their contact information on our website as we have more sign up. Right now we collect this information via form that fills contact properties, but since those cannot be placed on a public page we are using a HubDB table to fill in the information about our member trainers. That table must be manually updated when we have new trainers, and it would be nice to have a workflow fill in the table fields instead.

CarstenU
Contributor

Sounds great to me.

In my use case, i want to activate a workflow, if a hubdb is updated.

So I manually edit the table fields, after I klick on update now, that would trigger a workflow, where an email (only personalized with name) to the custoumer is send, to ask them to login in the hubspot cms site. ( I integrate the hubdb table in a dynamic page)

I vote for this feature 😉

 

Manobyte
Contributor | Diamond Partner

On an adjacent note, I would love to be able to add/update rows with workflows as well. Currently we have a mini user portal where people can login and update their company profile. These companies each have entries in hubDB that create public facing profile pages. They are just venders that the main company works with, So we don't really want to give them access to hubspot, or any of the other dealers. Currently we are setting up automatic updates using the API and an additional server, however it would be nice to have it all contained in hubspot.

tcxen
Contributor | Platinum Partner

This is a great idea and I just came across a use case for this today. What @SteveHTM said earlier in this thread:

Set Property B via lookup of Property A in specific HubDB table.

 

Please make HubDB data available in workflows and custom reports 😎

tommitchell
Contributor

Yes please to this. So many use cases in our daily Hubspot operations could benefit from this.

fiberpunk
Contributor

Oh yes, that would be super useful!

enorberg
Contributor

That'd be amazing. I currently use Zapier for this, which works (some of the time) but I would much prefer a native solution.

laurabren
Contributor

+1 +1 +1 to all of this! The Google Sheet lookup function in Zapier would translate so well to HubDB!

chrisupton
Member

This would make HubDB so valuable for us! 

04774
Member

This would be amazing and so helpful 

PNavarrete
HubSpot Employee

Creating reports based on Hub DB would allow to provide a more customized experience for end users. Hope to see this implemented in the near future!

cleabig1
Member | Platinum Partner

This would be epic!

chrisupton
Member
Right!? Its needed.
SRKelly
Participant

We absolutely need this. I'd love to have access to HubDB values for emails and landing pages. We have hudreds of thousands of users that may be connected to one company and we need to render those company properties in emails and landing pages. The problem is that there is a limitation on contact to company assocations (10K, I believe). Being able to link contacts to records in HubDB for emails, landing pages, workflows, setting properties, etc. would help us scale our use of Hubspot tremendously.

tmitch_sona
Participant

Commenting on this again a year on from doing the same in my last job. PLEASE let us have this functionality Hubspot - it would open up so many epic scaleable possibilities and solve loads of problems.

fairinstitute
Participant

We host our member only "Resource Library" through HubDB and I am interested to be able to see which resources are most viewed/downloaded. Being able to track page views on a daily/weekly/monthly/annually basis would be something I expect could be easy to create since everything is hosted on our HubSpot URL already.