With the reporting add-on in HubSpot, you have the flexibility of building your own custom reports and adding them to a dashboard of your choice. This custom report builder provides many filters for customization which will be covered in this article.
Please note: Sales Professional users can create custom reports and edit any template or custom report without the reporting add-on.
Options you choose in the Filters section will determine the dataset to pull into the report.
- Object: this is what type of record (or object) you want to report on.
- Date property: this filter will look at all contact properties you have in your HubSpot account that are, specifically, date properties. This date is controlled by the range set on your dashboard.
- Date range: this filter allows you to restrict the data to a particular time range. Choose from one of the default date ranges or select Custom date range to set specific dates for your report.
- Actions > Add saved filters: this allows you to filter based on any saved filters you have.
- Add filter: use this option to add filter criteria right into your report based on properties of your selected object type. For example, if you select Deals as your Object type, then you can click Add filter to add criteria based on deal properties.
Once you've set up your filters to your liking, you can decide what information you want to see from those filters.
- First, choose which associated property you want to group your records by. This is your x-axis.
- Now you can decide which number property will actually be charted on your report. This is your y-axis.
- Choose the plus sign to include an additional series to plot (on a number property).
As you set up your filters and measurements, you'll start to see a chart developing in the Visualization section. Within this area, you can set a few parameters to control how your chart displays.
- Style: the options here include Bar, Column, Line, Area, Doughnut, Pie, Summary, and Table. Not all styles will be available, as this depends on the data you're reporting on.
- Color: change up the color of your chart style.
- Display options: this menu provides more advanced options like if you want to see your chart stacked or cumulative. Things such as goals and comparisons will also live within this menu. Learn more about comparisons here.
Now that you know how to set up your filters and measurements for custom reporting, take a look at some helpful custom reports to get you started here.