No problem. The explanation will potentially make it sound even more technical, but I can give it a shot.
Metabase is for sure connected to some database that can be queried directly using SQL. That means a query could be written to just get the data for each account that you need.
If we connect Census to the same database, it can run that query on a scheduled basis, and then take that data and update your HubSpot Accounts.
So whenever someone checks the data in HubSpot, it's as recent as whenever the job in Census ran.
I'm happy to discuss your specific scenario with you if you'd like (totally free) Calendar Invite
Without knowing a bit more about your scenario, your Metabase is actually talking to some other database / data warehouse. If you're looking to get data from that database, calculate metrics, and push it into HubSpot, I've done this before with Census (https://www.getcensus.com/) . There's other platforms out there as well (RudderStack comes to mind), but I really enjoyed using Census.
Yes i obsiously not technical enough to understand the specs here. but i guess you are right.
I want an end result of a number from metabase to reflect in HS for the customer support team to be able to look on this instead of going to metabase and looking for the results.
can you share more guidance on how you did it with Census
No problem. The explanation will potentially make it sound even more technical, but I can give it a shot.
Metabase is for sure connected to some database that can be queried directly using SQL. That means a query could be written to just get the data for each account that you need.
If we connect Census to the same database, it can run that query on a scheduled basis, and then take that data and update your HubSpot Accounts.
So whenever someone checks the data in HubSpot, it's as recent as whenever the job in Census ran.
I'm happy to discuss your specific scenario with you if you'd like (totally free) Calendar Invite
