Upnify CRM
← Back to product

CRM · Reports

How to compare sales by product, period, and repeat purchase

Combine product-level analysis with new and repeat sales to understand revenue mix and customer continuity.

Illustration of sales grouped by product and period, with new sales and repeat purchases.

Published on October 27, 2026

CRM provides two complementary views to help you understand what drives sales: By product shows which products or services contribute to sales, while New vs. repeat compares sales classified as new with repeat purchases. Together, they help you review your catalog, plan campaigns, and identify opportunities to retain customers.

A manager can use the first view to see which products contribute the most revenue or compare product lines and brands. Then the second view can show how new sales and repeat purchases change by period or executive. These are different reports with different questions and filters.

What you need for useful data
The product report depends on won sales having products or services in their line items. New vs. repeat uses the sale classification stored in CRM; it does not infer repeat purchases from the product sold.

Compare sales by product

  1. In CRM, open Reports, go to Sales, and select By product.
  2. Choose the period, currency, and grouping available in the report. Depending on the view, you can compare products, lines, brands, or other dimensions.
  3. If the report offers an option to include taxes, choose whether you want amounts before or after tax. Keep this setting consistent when comparing results.
  4. Select Apply. Review units, amount, and percentage of the displayed total in the chart and table.
By product report with two items sold: CRM implementation consulting for MXN 6,000 and monthly sales support for MXN 3,000; total MXN 9,000.
The table shows each item, units, and its share of the displayed total: 67% and 33%.

Compare new sales and repeat purchases by period

  1. Open New vs. repeat in the sales reports.
  2. Select the comparison type, currency, and year or period. If needed, group by executive, group, product line, or another available dimension.
  3. Select Apply to update the chart and table. Compare new sales and repeat purchase amounts for the same period.
New vs. repeat report filtered to Héctor Lagunes’s new sales in 2026. October shows MXN 2,000.
Keep the same period and filters when comparing this amount with the repeat purchase view.
The same report filtered to repeat purchases shows MXN 11,000 for Héctor Lagunes in October.
New or repeat classification comes from the type recorded for each sale in CRM.

Use both views in a sales review

QuestionHelpful reportExample
Which products contribute most?By productSee whether one service accounts for a large share, then discuss availability, margin, or cross-selling.
How does revenue change by period?By product, using period filtersCompare equivalent periods to identify seasonality or changes in product mix.
What share comes from new or returning customers?New vs. repeatIf repeat purchases are significant, plan post-sale follow-up; if new sales dominate, review acquisition and first conversion.
Which team or executive drives the result?Both views with consistent groupingCompare owners using the same periods and currency.
Example
In the first screenshot, CRM implementation consulting contributes MXN 6,000 (67%) and monthly sales support MXN 3,000 (33%). The period view shows MXN 2,000 in new sales and MXN 11,000 in repeat purchases for October. This suggests two follow-ups: understand demand for consulting and plan continuity for customers who have already purchased.

Compare results consistently

  • Percentages in By product show each item’s share of the total under the current filters.
  • New or repeat classification comes from the sale record in CRM. If a figure seems unexpected, review the source sale and its saved classification.
  • Keep currency, taxes, grouping, and other filters consistent when comparing periods.
  • Results depend on the sales included in the report and their line-item data; sales without associated products do not provide product-level detail.

These reports work well together: one explains sales by item, while the other shows how new sales and repeat purchases change over time.