Reporting and Dashboards | Entry 77
HubSpot single-object reports analyze one record type and its properties. They help nonprofit teams answer focused operational questions with straightforward counts, totals, averages, comparisons, trends, and action lists without introducing unnecessary data sources or relationships.
A volunteer manager may need the number of inactive volunteer records. A fundraising manager may need every donation above $5,000. A membership director may need memberships grouped by renewal status.
Each question can be answered by analyzing one type of record. Single-object reporting keeps the focus on that object and the structured properties that describe it.
This reporting method is not a broader explanation of cross-object reporting, dashboards, attribution, or CRM architecture. Those topics matter only when they help determine whether a single-object report is the right choice.
Custom-object reporting requires an eligible Enterprise subscription, and other reporting availability depends on HubSpot subscription and permissions.
A single-object report analyzes records from one HubSpot object using the properties that belong to it. It can filter, group, count, compare, or summarize contacts, companies, deals, payments, subscriptions, events, tasks, tickets, invoices, calls, meetings, or eligible custom nonprofit records.
A donation report might use amount, donation date, donation type, campaign, fund designation, payment status, gift category, and assigned development officer.
If every field required to answer the question belongs to the donation record, another data source is unnecessary.
These reports are particularly useful for day-to-day management because they can show what happened, what is currently true, and what requires attention without requiring staff to understand multi-source joins.
| Team | Question | Possible object |
|---|---|---|
| Development | How many donations exceeded $5,000 this quarter? | Donations or deals |
| Volunteer management | Which volunteer records are inactive? | Volunteer object or contacts |
| Membership | How many memberships expire next month? | Membership object |
| Programs | How many enrollments are currently active? | Enrollment object |
| Finance | What is the total value of unpaid invoices? | Invoices |
| Grants | Which grant opportunities are due this quarter? | Grant records or deals |
| Events | How many event records are scheduled this year? | Marketing events or event object |
| Operations | How many overdue tasks belong to each team member? | Tasks |
| Constituent services | How many open requests are in each status? | Tickets |
| Revenue | How much recurring revenue is represented by active subscriptions? | Subscriptions |
| Sponsorships | How many opportunities are in each pipeline stage? | Deals |
| Leadership | How many constituents are in each lifecycle stage? | Contacts |
A fundraising manager wants to know how many completed donations of at least $5,000 were received during the current fiscal year. If donations are represented as deal records, Deals can serve as the single object.
Use KPIs for the number and total, a bar chart for designations, a line chart for change over time, and a table for individual records. Donor demographics, household information, or membership status would turn the question into cross-object reporting.
A single-object report works when each volunteer record contains a maintained last participation date, most recent shift, last event attended, status, total hours, or completed-shift count.
The volunteer object can then be filtered for active status and a last volunteer date more than six months ago. Blank dates may be included when the organization wants to identify people who have never participated.
If participation exists only on separate event registrations, attendance records, or volunteer shifts, the report requires multiple objects. A reliable rollup property or automation could maintain the most recent participation date on the volunteer record and simplify future reporting.
| If you are counting or analyzing | Start with |
|---|---|
| People | Contacts |
| Organizations | Companies |
| Donations or opportunities | Deals or donation records |
| Recurring payments | Subscriptions |
| Transactions | Payments |
| Memberships | Membership records |
| Volunteer profiles | Volunteer records |
| Volunteer shifts | Shift or participation records |
| Grants | Grant records or deals |
| Requests for assistance | Tickets |
| Staff follow-up work | Tasks |
| Scheduled conversations | Meetings |
| Event records | Marketing events or event records |
| Outstanding balances | Invoices |
The wrong object may still produce a chart, but it may not answer the intended question.
HubSpot can support date and advanced filters, visual customization, eligible comparisons, export, and summarized or unsummarized data review.
| Reporting question | Recommended visualization |
|---|---|
| How many records meet the criteria? | KPI |
| What is the total amount? | KPI |
| How has the total changed over time? | Line or area chart |
| How do categories compare? | Bar or column chart |
| What percentage falls into each category? | Donut or pie chart |
| Which records require action? | Table |
| How does this period compare with the previous one? | Comparison-enabled chart |
| How are records distributed across stages? | Bar or funnel report, depending on the question |
HubSpot's smart chart functionality may suggest a chart based on selected fields, but the report builder remains responsible for choosing a format that communicates the answer clearly.
| Use a saved view when | Use a single-object report when |
|---|---|
| Staff need a working list of records | Staff need a count, total, average, comparison, or trend |
| Users need to open, edit, assign, or update records | Leadership needs a visual summary |
| The goal is operational record management | The answer belongs on a dashboard |
| The team needs a reusable queue | The organization monitors performance over time |
| Action happens directly on the records | Summarized and unsummarized analysis is needed |
Both may be useful: the saved view helps the team do the work, while the report helps the team understand the work.
| Single-object report | Cross-object report |
|---|---|
| Uses one object | Uses multiple related sources |
| Focuses on properties of that object | Combines fields across connected records |
| Easier to configure | Requires closer attention to relationships |
| Reduces duplicated counts from joins | May create repeated rows through associations |
| Best for focused operational questions | Best for relationship-based questions |
| Cannot add secondary sources | Analyzes a primary source with related sources |
| Typically updates faster | May require more processing and interpretation |
Controlled dropdown properties are easier to report than variations such as “Inactive” and “Not Active.”
Record creation, donation, payment, close, deposit, and acknowledgment dates answer different questions.
A donation record is not necessarily money received, a registration is not attendance, and an invoice is not payment. Use meaningful stages or statuses.
Decide whether blanks should be included, excluded, reported separately, or corrected. A blank last-volunteer date could mean no participation or incomplete maintenance.
Review unsummarized data and compare sample records with their CRM pages before distributing the result.
Both may be useful: the saved view helps the team do the work, while the report helps the team understand the work.
“Major Donations” is vague. “Completed Donations of $5,000+ | Current Fiscal Year” tells the audience which records, threshold, status, and period are included before they open the report.
HubSpot currently documents single-object reporting for eligible Professional and Enterprise subscriptions, with custom-object reporting at Enterprise. Report limits vary by subscription, and single-object reports currently support a maximum of 20 metrics.
Single-object reporting helps nonprofit teams monitor focused operational metrics without unnecessary joins. With dependable properties, clear definitions, meaningful filters, appropriate visuals, and record-level validation, a simple report can provide the insight a team needs to act.
Both may be useful: the saved view helps the team do the work, while the report helps the team understand the work.