Magento Business Intelligence Help Center

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.

You will need to first upload a file containing specific daily/monthly/quarterly targets for your business.

You can leverage this help center article as well as 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.

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

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.

If you prefer not to build this dashboard yourself, you can open an engagement with our professional services team to create these metrics and reports for you and provide a summary of analysis. Simply open a support ticket here to start the conversation!

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk