How to Create Reports in the Commerce Analytics Suite in HubSpot

How to Create Reports in the Commerce Analytics Suite in HubSpot?

If your ecommerce or RevOps team struggles to get clear answers from HubSpot, you’re not alone. Most teams know their CRM contains valuable commerce data, but turning that data into reports that actually support decision-making is where things break down.

Revenue numbers don’t always match finance records. Product performance feels unclear. Subscription growth looks strong one month and flat the next. These issues often stem from how reports are built rather than from missing data.

The Commerce Analytics Suite in HubSpot is designed to bring clarity to ecommerce reporting. It connects payments, orders, subscriptions, and products directly to your CRM records so teams can analyze revenue without switching tools or manually reconciling spreadsheets.

Still, many teams rely on default dashboards or misconfigured filters, which leads to incomplete insights and misleading conclusions. 

This guide walks through how to create reports inside the Commerce Analytics Suite in HubSpot, from understanding how the tool works to building reports that reflect real ecommerce performance.

 

How HubSpot Handles Commerce and Revenue Reporting

The Commerce Analytics Suite is HubSpot’s dedicated workspace for analyzing ecommerce and transaction-based data. It centralizes insights from HubSpot Payments, orders, subscriptions, and connected platforms such as Shopify, Stripe, or custom payment integrations.

Rather than relying on deal stages as a proxy for revenue, the Suite focuses on confirmed transactions. This allows teams to report on actual payments, recurring revenue, and product sales with greater accuracy.

You can access the Commerce Analytics Suite by navigating to:

Reports > Analytics Tools > Commerce Analytics

Within this workspace, you can:

  • Build custom commerce reports
  • Use prebuilt templates for common ecommerce metrics
  • Analyze payments, products, customers, and subscriptions
  • Add reports directly to dashboards used across teams

All reports pull from native HubSpot objects, including contacts, deals, payments, products, and subscriptions. This makes it easier to connect revenue outcomes with customer behavior and lifecycle data.

 

How the Commerce Analytics Suite Works Behind the Scenes

Understanding how HubSpot processes commerce data helps ensure reports are built on the right foundation.

At its core, the Commerce Analytics Suite analyzes structured transaction records. These records represent real financial activity rather than projected or assumed revenue.

Key data sources include:

  • Payment records, which represent completed transactions
  • Product and line item records, linked to payments
  • Contact records, identifying who made the purchase
  • Subscription records, tracking recurring billing
  • Date and revenue properties, logged per transaction

Using these inputs, HubSpot calculates metrics such as total revenue, average order value, monthly recurring revenue, and repeat purchase rates.

Reports can be segmented by time period, product, customer type, payment method, or subscription status. Visualizations can be displayed as tables, bar charts, line graphs, or summary metrics depending on how the data needs to be consumed.

Once saved, reports update automatically as new transactions occur. There is no need for manual syncing or external exports.

 

Key Use Cases for Commerce Analytics Reports

The Commerce Analytics Suite supports a wide range of operational and strategic reporting needs. Its real value lies in tying revenue directly to products and customers within the CRM.

Tracking Revenue Performance

Commerce reports allow teams to monitor the revenue actually processed over time. By filtering reports by payment date, teams can analyze daily, monthly, or quarterly revenue trends with confidence.

For businesses that support both one-time and recurring transactions, separate reports can be created for each. This helps clarify how much revenue comes from new purchases versus ongoing subscriptions.

Analyzing Product-Level Performance

Product-level reporting is one of the most common reasons teams adopt the Commerce Analytics Suite. By linking payments to line items, teams can see exactly which products contribute most to revenue.

Reports can group products by category, price tier, or purchase type. This makes it easier to identify top performers, underperforming SKUs, and products that drive repeat purchases.

These insights are especially useful for inventory planning, pricing adjustments, and campaign prioritization.

Understanding Customer Cohorts

Cohort analysis helps teams understand how customer behavior evolves over time. By grouping customers based on their first purchase date, teams can track retention, repeat purchases, and lifetime value.

For example, a cohort report might compare customers acquired in Q1 versus Q2. If Q1 customers generate higher repeat revenue, that insight can guide changes in acquisition strategy or onboarding processes.

Evaluating Checkout and Payment Completion

Commerce reports can also surface issues in the checkout process. By comparing initiated payments to completed payments, teams can identify where customers drop off.

If a high percentage of payments fail or remain incomplete, it may point to friction in checkout flows, payment methods, or automation gaps.

 

Common Setup Errors That Affect Reporting Accuracy

Most reporting issues stem from configuration mistakes rather than missing data. These are some of the most common problems teams encounter.

Relying on Deals Instead of Payments

Deals represent intent, not revenue. Commerce reports should be built using payment records. If deals are used as the primary data source, revenue totals may be overstated or incomplete.

Always confirm that revenue reports pull from completed payments.

Missing Product Associations

If payments are not linked to products or line items, product-based reports will not work. Transactions may exist, but reports will show zero sales by product.

Every payment should be associated with at least one product record.

Incorrect Date Filters

Using deal close dates instead of payment dates can shift revenue into the wrong reporting period. For ecommerce reporting, the payment date should always be the primary filter.

Removing Default Dashboards

HubSpot provides example commerce dashboards to demonstrate structure and metrics. Deleting them removes useful reference points. Cloning and modifying these dashboards is a better approach.

 

Step-by-Step Guide to Creating a Commerce Analytics Report

Before starting, confirm that commerce features such as Payments, Orders, or Subscriptions are enabled and that transactions are being recorded correctly.

Then follow these steps:

  1. Go to Reports > Analytics Tools > Commerce Analytics
  2. Click Create report
  3. Select a data source such as Payments, Products, Orders, or Subscriptions
  4. Choose a primary metric like total revenue or number of payments
  5. Add dimensions to segment data by product, customer type, or region
  6. Apply filters for date range, payment status, or transaction type
  7. Select a visualization that best communicates the insight
  8. Save the report with a clear, descriptive name
  9. Add the report to a relevant dashboard

This approach helps ensure reports remain focused, readable, and aligned with business goals.

 

Reviewing and Measuring Results Over Time

Once reports are live, they should be reviewed regularly. Dashboards should reflect metrics that support real decisions, not just surface-level activity.

Common metrics to track include:

  • Total processed payments
  • Average order value
  • Revenue by product or category
  • Customer retention rate
  • Failed or incomplete payments

Regular review cycles help teams spot trends early and adjust strategies before issues scale.

 

How INSIDEA Helps

Setting up commerce reporting in HubSpot often involves more than turning on payments. Data structure, product associations, and CRM alignment all play a role in whether reports can be trusted.

INSIDEA supports ecommerce and RevOps teams at every stage of this process.

  • HubSpot Onboarding: INSIDEA helps teams set up HubSpot correctly from the start, ensuring payments, products, deals, and contacts are aligned so commerce data flows into reports without gaps.
  • HubSpot Management: As transaction volume grows, ongoing management is critical. Our team helps maintain clean customer records, accurate product associations, and consistent payment tracking.
  • Hire HubSpot Experts: Teams often choose to hire HubSpot experts when reporting issues reveal deeper CRM or commerce setup challenges. Our team provides hands-on support to diagnose and resolve these issues.
  • HubSpot Consulting Services: For teams with complex ecommerce models or multiple payment tools, we offer HubSpot consulting services to align reporting with sales, marketing, and product data.

If you’re looking to improve ecommerce reporting or need help connecting your commerce data inside HubSpot, INSIDEA provides the structure and support needed to make your reports reliable.

Clear reporting starts with clean data. With the Commerce Analytics Suite properly set up, HubSpot becomes a reliable source of truth for ecommerce performance.

Jigar Thakker is a HubSpot Certified Expert and CBO at INSIDEA. With over 7 years of expertise in digital marketing and automation, Jigar specializes in optimizing RevOps strategies, helping businesses unlock their full potential. A HubSpot Community Champion, he is proficient in all HubSpot solutions, including Sales, Marketing, Service, CMS, and Operations Hubs. Jigar is dedicated to transforming your RevOps into a revenue-generating powerhouse, leveraging HubSpot’s unique capabilities to boost sales and marketing conversions.

The Award-Winning Team Is Ready.

Are You?

“At INSIDEA, it’s all about putting people first. Our top priority? You. Whether you’re part of our incredible team, a valued customer, or a trusted partner, your satisfaction always comes before anything else. We’re not just focused on meeting expectations; we’re here to exceed them and that’s what we take pride in!”

Pratik Thakker

Founder & CEO

Company-of-the-year

Featured In

Ready to take your marketing to the next level?

Book a demo and discovery call to get a look at:


By clicking next, you agree to receive communications from INSIDEA in accordance with our Privacy Policy.