Sometimes the projects that seem the most simple can turn out to be the most involved. For instance, a request to create a dashboard to track sales leads. While it may have been less straightforward than just feeding data into some charts and graphs, the end result allowed our sales and marketing team to turn what had been a simple lead-tracking exercise into a tool to drive sales intelligence.
We use Hubspot at DOOR3, which generally does a good job of tracking sales and leads, but we wanted a dynamic way to actively show all the latest data in one place. We decided it was time to build a dashboard that could pull everything together for the team.
I started by exploring available out-of-the-box options. I experimented with a few platforms, such as Databox and Power BI, but ultimately found they could not do what we wanted. Existing platforms do provide their own tools for pulling data. However, we have seen that our team occasionally wants a feature that is very specific to our organization, and this meant having full control would be best. In particular, it offered us the ability to integrate other data sources in the future as well.
What we ended up with was a robust dashboard that allows users to click on a deal or company and go directly to that profile within Hubspot, where they can make changes that are dynamically reflected in the dashboard. This makes sales and marketing meetings more streamlined and gives the team the ability to easily see what everyone is working on. These dashboards are making our sales projections smarter and easier to generate too. At the same time, we are really benefiting from how easy it is to communicate around our dashboards. Since everyone on the team knows how to use Google Sheets, they can easily tell me how they wish to see data or any design improvements they want.
Even better, the code we created is a bare bones example of how to pull and manipulate data from Hubspot, and a great base for us to build on. Quite frankly it is what I wished I had in the beginning. For more on how the code works, including a link to the code repository, be sure to stay tuned for my next post.
Project managers are the unsung heroes of the development process. There’s so much more to shepherding a project to launch than just keeping the trains on schedule. Each role, from...
Sometimes the projects that seem the most simple can turn out to be the most involved. For instance, a request to create a dashboard to track sales leads. While it...