If you’ve ever tried pulling reports in HubSpot and ended up with misaligned metrics or fragmented data, you’re not alone. Marketing tracks campaigns in Marketing Hub, sales relies on deal data, and service works with tickets, but bringing it all together for accurate reporting often feels like stitching a quilt from mismatched threads. Manual exports create gaps, disconnected dashboards delay decisions, and inconsistent definitions lead to team confusion.
HubSpot datasets offer you a smarter way to report. Rather than building every report from scratch across multiple objects, you can first create a dataset: a streamlined data table with the exact fields, filters, and formulas you want. This keeps reporting consistent, reduces errors, and creates a shared foundation for analytics across your teams.
In this guide, you’ll get a practical breakdown of how datasets work in HubSpot, how to build them correctly, and how to use them to sharpen accuracy in your revenue operations reporting. You’ll walk away able to define datasets, understand their structure, and avoid common mistakes, based on real use cases from teams like yours.
Build Custom Reporting Engines with HubSpot Datasets
Think of a HubSpot dataset as the connective tissue between your CRM data and the reports your teams rely on. It’s a reusable table that lets you preselect specific objects (like Deals or Tickets), add custom calculations, and apply filters, all before building a single chart. In short, it gives you a clean, ready-to-use base for reliable reporting.
You’ll find the option to create datasets by navigating to Reporting > Datasets in your HubSpot portal. It’s available in HubSpot Enterprise accounts and integrates with the custom report builder, giving you control over the fields and metrics that matter.
Because each dataset pulls live data directly from your CRM, there’s no need for spreadsheets or API syncing. You can include properties like deal amounts or contact source, and enrich the dataset with fields you define, such as calculated lead conversion times or average resolution durations.
What makes datasets especially powerful is that they support relational joins across objects. For example, you can link Contacts to Deals, or Tickets to Companies, allowing you to generate cross-functional insights without cobbling together reports from scratch.
How It Works Under the Hood
HubSpot datasets follow a predictable structure that puts you in control of every layer: what data goes in, how it’s shaped, and where it’s used.
Here’s how the process unfolds:
- Select your primary data source: Start by choosing a main object, like Deals, Contacts, or Tickets. From there, HubSpot lets you connect related objects via predefined CRM relationships.
- Define your fields: Choose which properties you want to include. These might be standard fields like deal stage or contact source, or custom ones created for your organization.
- Apply filters: Narrow the focus to exactly the right data slice. For instance, filter for “Deals in Closed Won stage” or “Contacts added in the past 90 days.”
- Add calculations: Create new properties through calculated fields. Examples include deal cycle time or lead velocity.
- Output to reports: Once your dataset is saved, it becomes a selectable data source inside the custom report builder, where you can create visualizations like charts or pivot tables.
The system supports refresh options and join configurations, giving you fine-tuned control over how live CRM data flows into your reports. Because datasets are powered by real-time data, any changes to CRM records are automatically reflected in your analytics, eliminating outdated snapshots and tedious data cleanup.
Main Uses Inside HubSpot
Once you grasp how datasets work, you can standardize reporting across teams rather than building each chart individually. Here are the core use cases that services, sales, and marketing teams use to streamline performance tracking.
Consolidating sales performance metrics
Sales managers need to track metrics like revenue, pipeline health, and cycle length, but they also need to trust that those metrics are defined consistently. That’s where a sales-focused dataset pays off.
Example: You create a dataset pulling from Deals and Companies. You add properties like region, pipeline, stage, owner, and deal amount, and include calculated metrics such as average days to close and weighted pipeline value. The result? A performance dataset that powers all sales dashboards, from high-level quarterly revenue to individual rep performance, using a trusted, unified structure.
Measuring marketing effectiveness
Proving marketing ROI often depends on linking contact engagement to conversions, and that means working across multiple objects. The right dataset allows you to bridge those gaps cleanly.
Example: Build a dataset connecting Contacts to Deals. You add the lifecycle stage, original source, and first conversion date. Next, create a calculated field, like lead-to-customer duration, by subtracting the contact create date from the deal close date. That gives marketing clear visibility into which campaigns move leads fastest and which sources drive high-value results.
Tracking service performance and customer retention
Customer support analytics often fall apart when raw ticket data isn’t connected to company profiles or filtered by relevant segments. Datasets bring structure to your service reporting.
Example: Build a dataset using Tickets and associate them with Companies. Include ticket status, timestamps, and a custom calculation for average resolution time. Then add customer type to distinguish new from existing accounts. Reporting becomes straightforward: which customer types generate the most tickets, and how responsive is your service team?
Common Setup Errors and Wrong Assumptions
Even if you’ve been using HubSpot for years, it’s easy to make reporting mistakes when creating datasets, especially if you skip planning or misjudge object relationships. Watch out for these common missteps:
- Using unrelated objects in one dataset
Trying to connect Deals to unrelated objects, such as Ads (which have no defined link), results in failed joins or blank values.
→ Always check object associations in your CRM schema before adding sources. - Duplicating calculated fields across multiple datasets
Calculating “average deal size” differently in three places makes dashboards misleading.
→ Centralize common calculations in one dataset and reuse it across reports. - Leaving data unfiltered
A dataset without filters might include years of unused records, slowing reports and clouding insights.
→ Apply filters for time, lifecycle stage, or active pipeline to stay focused. - Expecting instant values to show after edits
CRM values are live, but complex joins or formulas may take a few moments to update in visualizations.
→ Save, close, and reopen datasets to verify recent changes pulled through.
Getting the logic clean up front saves hours of backtracking and preserves your team’s trust in the numbers.
Step-by-Step Setup or Use Guide
Ready to build your first dataset? Follow these steps to do it right the first time:
Step 1: Navigate to Reporting > Datasets
Inside your HubSpot portal, go to Reports and select “Datasets.” Click “Create dataset.”
Step 2: Choose your primary object
Decide on the core CRM object your report will focus on, typically Deals, Contacts, or Tickets.
Step 3: Add related objects
Use “Add source” to connect other objects with a defined relationship. For example, connect Deals to Companies or Contacts where applicable.
Step 4: Pick your fields
Use the search and checkboxes to select relevant properties. Custom fields will appear alongside native ones.
Step 5: Apply filters
Filter data to keep your dataset lean and relevant, e.g., closed Won deals for FY24 or tickets assigned to tier 1 support.
Step 6: Add calculated fields
Click “Add field,” choose “Calculated field,” and enter your formula. HubSpot supports operators like DATEDIFF and IF statements.
Step 7: Preview your output
Confirm the dataset preview shows the right values before saving. Catching errors here saves time later.
Step 8: Save and name clearly
Use a naming convention like “Marketing_Effectiveness_Q2” to help users identify the purpose. Save the dataset.
Once saved, the dataset will appear as a data source when using the Custom Report Builder. No need to start from raw data again.
Measuring Results in HubSpot
To know whether your datasets are improving reporting, you’ll want to track more than just visual dashboards. Here’s what to monitor:
- Report accuracy
Compare visuals powered by datasets versus those built from raw sources. If numbers conflict, revisit filters, formulas, or property mapping. - Dashboard performance
Lighter, well-scoped datasets improve load times, especially for revenue or service dashboards. - Team adoption
Check how many reports are powered by each dataset. Higher reuse means teams are aligning on shared definitions. - Data freshness
Look for recent CRM entries in your dashboards. If values are missing, check the filters or confirm that the associations are intact. - Metric consistency
Shared KPIs like MQL-to-SQL rate or monthly bookings should match between sales and marketing reports, provided they’re using the same dataset.
Within HubSpot’s Reporting settings, you can also review dataset usage and ownership, giving you visibility into who’s editing or relying on which versions.
Short Example that Ties It Together
Let’s say your RevOps team needs a snapshot dashboard showing revenue, deal velocity, and source performance.
You head to Reporting > Datasets and create a new one. Set Deals as your primary source and connect Contacts to pull in lead origin. Add fields like amount, owner, create date, close date, and contact source. Include a calculated field “Days to Close” using DATEDIFF between create and close dates. Filter for deals that closed during the current fiscal year, and save the dataset as “FY24_Revenue_Source.”
In the Custom Report Builder, use this dataset to produce:
- Total revenue by contact source
- Average deal cycle by lifecycle stage
- Bookings by rep
Add the visualizations to a dashboard, publish to leadership, and done, you’ve built a live, auto-refreshing report that connects sales and marketing performance to real data.
How INSIDEA Helps
Building datasets that drive clarity across departments means more than just knowing HubSpot; it requires aligning your CRM architecture, business objectives, and reporting logic. That’s where INSIDEA comes in.
We work with companies like yours to create HubSpot datasets that aren’t just technically correct but strategically useful. From setup to optimization, our certified experts align objects, properties, and reports around your goals.
What we offer:
- Customized HubSpot onboarding: Get your portal structured right from day one
- Clean CRM management: Ensure your properties, associations, and records are always ready for reporting
- Strategic workflow automation: Turn clunky processes into scalable workflows
- Analytics alignment: Make sure datasets reflect KPIs that matter across teams
- Dataset creation and validation: Design reporting layers that hold up under scrutiny
- Performance audits: Spot inefficiencies and inconsistencies before they spread
If your reporting feels inconsistent, bloated, or siloed, INSIDEA can help reset the foundation. Book a no-cost consultation with one of our experts or check out INSIDEA’s HubSpot consulting services.
