Skip to content

Upsell metrics in R7K12 reports

R7K12 reports now include new metrics that show upsell information.

Metric Description
Upsells Number of upsells in deals with statuses from the "Completed" group
Upsell amount Revenue from upsells with statuses from the "Completed" group
Number of upsold products Number of upsold products in deals (pcs) with statuses from the "Completed" group
Deals with upsells Number of deals that contain upsells, with statuses from the "Completed" group
Upsells (potential) Number of upsells in deals with statuses from the "In progress" group
Upsell amount (potential) Revenue from upsells with statuses from the "In progress" group
Number of upsold products (potential) Number of upsold products in deals (pcs) with statuses from the "In progress" group
Deals with upsells (potential) Number of deals that contain upsells, with statuses from the "In progress" group
Upsells (canceled) Number of upsells in deals with statuses from the "Canceled" group
Upsell amount (canceled) Revenue from upsells with statuses from the "Canceled" group
Number of upsold products (canceled) Number of upsold products in deals (pcs) with statuses from the "Canceled" group
Deals with upsells (canceled) Number of deals that contain upsells, with statuses from the "Canceled" group
Upsells (all) Number of upsells in deals with all statuses
Upsell amount (all) Revenue from upsells with all statuses
Number of upsold products (all) Number of upsold products in deals (pcs) with all statuses
Deals with upsells (all) Number of deals that contain upsells, with all statuses
Upsell profit Upsell revenue minus the cost of goods, with statuses from the "Completed" group
Upsell profit (potential) Upsell revenue minus the cost of goods, with statuses from the "In progress" group
Upsell profit (canceled) Upsell revenue minus the cost of goods, with statuses from the "Canceled" group
Upsell profit (all) Upsell revenue minus the cost of goods, with all statuses
Upsell cost of goods (potential) Cost of goods for upsells with statuses from the "In progress" group
Upsell cost of goods (canceled) Cost of goods for upsells with statuses from the "Canceled" group
Upsell cost of goods (completed) Cost of goods for upsells with statuses from the "Completed" group

To show these metrics in a report, follow these steps:

  1. Sign in to your project on the R7K12 website and open the “Analytics” menu.

  1. Click the “Edit” button next to the name of the selected report.

  1. In the “Report dimensions” block, select the “Add report dimension” action.

  1. In the list of dimensions that appears, use the search bar to select “Manager name” or “Manager ID”.

  1. Drag the selected dimension to the top of the list with the mouse.

  1. In the “Report metrics” block, add the new metrics using the “Add report metric” action.

  1. Use the search bar to add the new metrics from the suggested list.

(Please note that the “Upsells” metric is assigned only to deals in the “Completed” status group, i.e. when the order has been paid. Potential upsell metrics represent orders that are currently unpaid, and canceled upsells are fully closed deals without payment).

  1. After that, the metrics should appear in the overall list of report metrics.

  1. Click the “Save” button to confirm your changes.

  1. On the report tab, select the added metrics so that the upsell information is shown on the chart.

  1. Click the “Refresh” button to rebuild the report.

  1. Now all data will be shown on the chart according to the time interval. And in the table you can check the number and amount of upsells made by each manager.