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.
The Migration of legacy systems may seem straightforward in concept, take information in an older system and put it in a newer one. The process of doing this however, is...
We are pleased to announce DOOR3 has received The Web Excellence Award in App and Mobile / Sustainability for our work with Retrievr UX mobile development. The Web Excellence Awards’...
The list of legacy system migration challenges for enterprises is extensive, as migrations can be a complex and challenging process, with many potential roadblocks and pitfalls along the way. For...