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:
- Sign in to your project on the R7K12 website and open the “Analytics” menu.

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

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

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

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

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

- 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).
- After that, the metrics should appear in the overall list of report metrics.

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

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

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

- 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.
