Tracking Goals Against Actual Metrics

A large majority of our clients often would like to track their business goals, but don't realize this is possible in Magento BI. In this article, we demonstrate 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. We'll also show you how to compare year over year performance, all in a dashboard like this:

Before getting started, you'll want to familiarize yourself with our file uploader and make sure you've defined your business goals for a given period of time.

Getting Started

You will 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 our clients track in Magento BI include Orders, Revenue, and New registered accounts.

Metrics

You will need to create one new metric for each target. For example, if you upload monthly revenue and orders targets, you will 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

As always, 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 “Multiple Y-Axes” off
  • Time period: (Whatever relevant time period you want)
  • Interval: Month
  • Chart Type: Line Chart

Once you’ve completed the above reports for revenue targets, you can create identical reports for goals around orders, registered accounts, or any other values you’ve included in your goals file upload.

After compiling all the reports, you can organize them on the dashboard as you desire. The end result may look like the image at the top of this page.