Tracking Goals Against Performance Metrics
Most clients would like to track their business goals, but do not realize this is possible in Adobe Commerce Intelligence. This topic demonstrates how to set up a dashboard that will help you track your business goals against your actual data - including revenue, new registered users, and orders over time. You also learn how to compare year over year performance, all in a dashboard like this:
Before getting started, you should review the file uploader and make sure you have defined your business goals for a given period.
Getting Started
You need to first upload a file containing specific daily/monthly/quarterly targets for your business.
You can use the file uploader and the image below to format your file. The most common targets that clients track in Commerce Intelligence include Orders, Revenue, and New registered accounts.
Metrics
Create one new metric for each target. For example, if you upload monthly revenue and orders targets, you need to create two new metrics:
-
Monthly revenue target
-
In the
Monthly goals
table -
This metric performs a Sum
-
On the
Revenue target
column -
Ordered by the
Month
timestamp -
Monthly orders target
-
In the
Monthly goals
table -
This metric performs a Sum
-
On the
Orders target
column -
Ordered by the
Month
timestamp -
Monthly new registered accounts target
-
In the
Monthly goals
table -
This metric performs a Sum
-
On the
New registered accounts target
column -
Ordered by the
Month
timestamp
Reports
It is helpful to have a mix of static values and visual charts when analyzing your targets. Below are three example reports to get you started tracking your revenue performance.
-
Revenue left to achieve target
-
Metric
A
:Revenue
-
Metric:
Revenue
-
Metric
B
:Target Revenue
-
Metric:
Monthly Revenue Target
-
Formula:
Revenue left to achieve target
-
Formula:
(B-A)
-
Format:
Number
-
Time period: (Whatever relevant time period you want)
-
Interval:
Month
-
Chart Type:
Scalar
-
Revenue targets
-
Metric
A
:Revenue
-
Metric:
Revenue
-
Metric
B
:Target Revenue
-
Metric:
Monthly Revenue Target
-
Metric
C
:Revenue (amount change since previous year)
(hide) -
Metric:
Revenue
-
Perspective:
Amount change vs. Previous year
-
Formula: (This month last year)
-
Formula:
(A-C)
-
Format:
Currency
-
Turn off
Multiple Y-Axes
-
Time period: (Whatever relevant time period you want)*
-
Interval:
Month
-
Chart Type:
Line Chart
Once you have completed the above reports for revenue targets, you can create identical reports for goals around orders, registered accounts, or any other values you have included in your goals file upload.
After compiling all the reports, you can organize them on the dashboard as you desire. The result may look like the image at the top of this page.