When managing customer relationships, having a dynamic and flexible dashboard that allows you to filter reports by different companies is invaluable. In this HubSpot Hack, we'll show you how to create a custom "Company Dashboard" that, using the Quick Filters feature, enables you to easily view and analyse key metrics for each of your customers. This will not only streamline your reporting process but also ensure you're making data-driven decisions tailored to each client's needs.
Imagine you're running a consulting firm that works with multiple companies across various industries. You have different projects, revenue streams, and customer engagement metrics for each client. Wouldn't it be convenient to have a single dashboard where you can instantly filter reports to focus on one company at a time? This hack will help you achieve just that, making your workflow more efficient and your data analysis more targeted.
We won't show you how to build out each of your reports in this Hack, however we will give you some reports we recommend including.
These reports will give you a comprehensive view of each company’s relationship with your business, helping you tailor your strategies accordingly.
First, create a new dashboard in HubSpot by navigating to the Reports tab and selecting "Dashboards." Click "Create dashboard" and choose "Start from scratch." Give your dashboard a name, such as "Company Overview," and select the "Private" option to restrict access if needed.
Now, let's add the key reports mentioned earlier to your new dashboard. Use HubSpot's report library or build custom reports based on your specific needs. For example, to create a "Revenue by Company" report, go to Reports > Reports > Create report > Single object report. Select "Deals" as the object and group your data by "Company Name."
Repeat this process to add the other reports - just make sure the Company Object is always used.
With your reports in place, the next step is to leverage HubSpot's Quick Filters to make your dashboard more interactive.
At the top of the dashboard, click on the "Advanced filters" button, then the "Quick Filters" tab. Set up your quick filter by selecting "Company" from the list of properties. This will allow you to filter all reports on your dashboard based on the selected company quickly and easily!
Finally, if you want your team members to have access to these insights, you can share the dashboard with them. Go to your dashboard settings and select the "Manage sharing" option. Here, you can choose to share the dashboard with specific users or make it public for your entire team.
Creating a custom Company Dashboard with Quick Filters empowers you to manage multiple customer relationships more effectively. Instead of juggling different reports or manually filtering data, you now have a streamlined, interactive dashboard that provides instant insights into each client’s performance.
Whether you're monitoring revenue, tracking deals, or analysing engagement, this hack will help you stay organised, make informed decisions, and ultimately improve your client management process.