Reporting and Dashboards | Entry 75
HubSpot makes reporting more approachable by letting teams begin with a question, select the right data, add filters, choose a visualization, and save the answer. Once built, focused reports can update with CRM data, live on role-specific dashboards, and be distributed automatically.
Reporting can feel intimidating when a blank screen seems to require knowledge of every object, property, association, filter, formula, and visualization. That pressure often sends teams back to a recurring export, spreadsheet cleanup, pivot table, and email routine.
HubSpot gives nonprofit teams several visual paths for turning clear questions into reusable reports.
HubSpot offers report templates, single-object reports, the custom report builder, funnels, attribution, customer journey reporting, AI-generated reports, and specialized analytics. Available builders, sources, filters, refresh schedules, visualizations, and custom-report limits depend on subscription and permissions.
Accessible tools do not remove the need to define the question, understand the data, validate filters, and interpret results responsibly.
| Weak reporting request | Strong reporting question |
|---|---|
| Show me donor data | How many first-time donors gave last month? |
| Show revenue | How much closed-won donation revenue did we record this quarter? |
| Show campaigns | Which campaign generated the most first-time donors? |
| Show volunteers | How many active applicants are waiting for approval? |
| Show memberships | Which memberships will expire within 60 days? |
| Show events | Which event had the highest attendee-to-donor conversion rate? |
| Show grants | What grant revenue is expected to close this fiscal year? |
A clear question reveals what should be counted, which record contains the answer, which date and filters matter, how the result should be grouped, and what decision should follow.
Imagine that the Executive Director asks every Monday how many new donors arrived last week, how much revenue came in, and which campaign produced the most donations. Without connected reporting, the team may export donors and transactions, reconcile platforms, match campaigns, remove duplicates, calculate totals, create charts, and repeat the work next week.
With relative filters and connected data, focused HubSpot reports can continue updating without rebuilding the analysis each Monday.
| Question | Recommended report |
|---|---|
| How many new donors did we have? | KPI report |
| What was total revenue? | KPI or summary report |
| Which campaign generated the most donations? | Ranked bar chart or table |
| How did this compare with the prior period? | KPI comparison or time-series report |
| Who were the new donors? | Drill-down table or saved CRM view |
A dashboard brings related answers together. A single visualization does not need to answer every question.
Prebuilt reports cover common website, marketing, sales, revenue, service, contact, deal, and campaign topics. Templates can be searched by source or visualization and saved to a library or dashboard, making them a practical starting point for new users.
Use these when the answer primarily lives on one record type, such as contacts, companies, deals, tickets, activities, payments, quotes, feedback, line items, or custom objects. They generally update faster because they query the live CRM database.
Combine a primary source with related records, activities, assets, or events. Examples include contacts with donation deals, companies with sponsorship opportunities, members with payments, volunteers with activities, campaigns with assets, or deals with line items.
Funnels measure progression, such as prospect to donor or applicant to volunteer. Attribution reports examine recorded interactions that contributed to contact creation, deal creation, or closed-won revenue.
Describe the goal in ordinary language, then review and refine the generated report. Include the object, metric, date range, grouping, and filters in the prompt.
| Question | Likely primary source |
|---|---|
| How many new contacts did we acquire? | Contacts |
| How much donation revenue closed? | Deals |
| How many payments were completed? | Payments |
| Which campaigns performed best? | Campaigns |
| How many volunteers are active? | Volunteer custom object or Contacts |
| How many memberships are expiring? | Membership object, Subscriptions, or Deals |
| How many donor calls were completed? | Activities |
| Which companies sponsored the gala? | Companies or Deals |
Contacts count people, deals may count donations or opportunities, and payments count transactions. Those answers are not interchangeable.
The custom report builder joins data sources through available associations. Additional sources may be included automatically when needed to connect selected data. A report linking deals with blog activity, for example, may also require contacts and web-activity sources.
Use HubSpot's join information and preview table to confirm which records are included or excluded, how sources relate, and whether the primary source is appropriate.
One donor might have three gifts, two email clicks, four page views, and an event registration. Joining those sources without careful aggregation can repeat rows.
Decide whether the report counts unique donors, households, gifts, deals, payments, activities, or interactions. “Number of Donors” should normally count unique donor records; “Number of Donations” should count the approved transaction record.
A new donor could mean a contact created last week, a person who made a first gift last week, a newly changed lifecycle stage, a first-giving household, or a donor newly acquired by the organization regardless of when the CRM record was created.
Contact create date is not a reliable substitute. The record may represent a volunteer, subscriber, participant, registrant, sponsor prospect, or an existing donor imported late.
Calculated and rollup properties can make the definition easier to report consistently.
Revenue might mean closed-won deal amount, processed payments, gross or net payments, donations, sponsorships, memberships, grants, cash received, committed revenue, or recognized revenue.
A closed-won deal can represent a commitment rather than cash received. A payment may represent collected funds but exclude offline checks. A subscription may represent expected future revenue.
The answer may be based on direct campaign association, a campaign form, influenced contacts, first-touch attribution, last-touch attribution, multi-touch revenue attribution, UTM values, appeal codes, donor acquisition, or the final campaign before a gift.
The report title should make the method visible because association, influence, and attribution answer different questions.
Document significant filters in the report description so another user can understand the population.
Use ranges such as last week, this month, last quarter, this year, previous fiscal year, last 30 days, or next 60 days. Verify how the portal timezone, week boundaries, and fiscal-year settings affect the result.
| Visualization | Best use |
|---|---|
| KPI | One important number |
| Bar or column chart | Compare categories or periods |
| Line or area chart | Show volume or change over time |
| Pie or donut chart | Show a simple composition with few categories |
| Table | Display exact values and record-level details |
| Pivot table | Summarize across rows and columns |
| Combination chart | Compare metrics or scales |
| Funnel | Show progression through stages |
| Gauge | Compare performance with a target or range |
| Scatter plot | Examine relationships between numerical variables |
Executive reports should use plain-language titles, limited colors, visible dates, concise descriptions, and consistent definitions. “Donation Revenue Closed Last Week” communicates more clearly than “Deal Amount by Close Date.”
A dashboard should collect the focused reports used by a specific team or decision-maker.
HubSpot states that single-object reports generally update faster because they query the live CRM database. Advanced custom reports may refresh approximately every two hours and can take longer because of their complexity. Eligible dashboard reports can also be refreshed manually.
Leadership reports should document the expected refresh behavior.
Depending on configuration, reports can be shared through email, Slack, Google Chat, CSV, Excel, or image exports. Recurring report emails can be scheduled daily, weekly, or monthly. HubSpot notes that scheduled data may be captured approximately two hours before delivery.
A stronger prompt includes the object, metric, date range, grouping, and filters. For example: “Show the total amount of closed-won deals in the Individual Donations pipeline last week, grouped by associated HubSpot campaign.”
After generation, verify the primary and secondary sources, properties, date field, range, filters, aggregation, unique count versus record count, visualization, name, and access. A polished AI chart can still answer the wrong question.
Generated summaries may highlight trends, changes, high performers, or possible patterns. Check data quality, sample size, missing records, seasonality, changing definitions, program context, external events, and anomalies before treating them as final analysis.
Custom-report creation requires appropriate Create/own and Edit report permissions. Subscription limits govern the number and types of custom reports, and equivalent limits from several subscriptions do not necessarily combine.
Report visibility does not override a user's underlying access to restricted CRM data.
A well-built report may correctly reveal that the underlying data is inconsistent. That discovery is useful because it identifies where architecture and process need attention.
A beautiful chart cannot repair an unclear metric.
| Team or area | Practical reports |
|---|---|
| Development | New donors, returning donors, revenue, average gift, recurring gifts, reactivation, campaign revenue, retention, and designations |
| Grants | Opportunities, stages, expected revenue, deadlines, reports due, funders, and awarded versus requested amount |
| Sponsorships | Open opportunities, event revenue, agreements, payments, renewals, and benefits fulfillment |
| Membership | Active members, new memberships, renewals, lapses, revenue, renewal rate, and membership types |
| Volunteers | Applicants, background checks, approvals, active volunteers, hours, programs, inactivity, and donor conversion |
| Events | Registrations, attendance, ticket revenue, sources, constituent types, sponsors, post-event gifts, and donor conversion |
| Marketing | New contacts, email, landing pages, forms, campaign influence, social, ads, and revenue attribution |
| Programs | Enrollment, participation, completion, waitlists, referrals, requests, outcomes, and geography |
A practical naming convention is: Metric | Population | Timeframe | Grouping.
Sensitive data should not be casually uploaded, inferred, or used to create audiences.
Thoughtful HubSpot reporting helps nonprofits answer recurring questions without repeated exports, start with templates or AI, combine related CRM data, create clear visuals, keep dashboards current, schedule delivery, assign appropriate access, identify data problems, improve executive visibility, and build confidence among non-analyst users.
The goal is not to produce more charts. It is to make trustworthy answers easier to find and use.