Balanced Scorecard Report Creation

InetSoft's reporting software comes equipped with balanced scorecards for reports that can be set up to provide critical up to the minute updates as often as needed. View the information below to learn more about the Style Intelligence solution.

A scorecard is used to keep track of certain parameters (e.g., Sales Revenue). Multiple users can monitor these parameters from the Report Portal. These parameters (metrics) can also be measured at regular intervals (triggers). They can be checked against certain conditions (thresholds, time comparisons, custom business logic etc.) to which they must comply.

 If they don't, specified actions can be automatically taken (email notifications, etc.). The metric, trigger, conditions and other settings are collectively handled as a target. A scorecard is thus a collection of one or more targets. Consider the following use of a scorecard: A company aims for a 2% increase in sales revenue every month. A sales manager wishes to closely monitor this metric to ensure a sustained increase in the revenue.

We create a data asset (in the Asset Composer) which calculates the total sales revenue of the company for each month. We create a metric based on the 'Revenue' field of this asset. We optionally associate a detail report with this metric, based on the asset (e.g., a chart plotting the sales revenue on the Y-axis and month on the X-Axis).

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

We set up a target with a trigger to evaluate this metric on a monthly basis. We specify a condition which checks for a 2% increase in revenue in the previous month from the month before. If this condition is not met we can set up notifications to the sales manager, which can be accompanied by the detail report. The sales manager can subscribe to this target and can constantly monitor it from the InetSoft Report Portal. They can also drill down into the metric to view the detail report at any time.

What Does a CPQ Software Solution Track in a Balanced Scorecard?

CPQ (Configure, Price, Quote) software solutions can track a variety of metrics and performance indicators that can be used to create a balanced scorecard for sales and marketing teams. Here are some of the key areas that a CPQ software solution can track:

Customer Acquisition

  • New Sales Opportunities Created
  • Conversion Rate of Opportunities to Quotes
  • Average Lead Cycle Time
  • Cost of Customer Acquisition (CAC)

Customer Retention

  • Customer Lifetime Value (CLV)
  • Customer Satisfaction Scores
  • Renewal Rates
  • Upsell and Cross-Sell Rates

Product Performance

  • Product Revenue
  • Product Profitability
  • Product Margins
  • Average Deal Size

Sales Performance

  • Number of Quotes Generated
  • Number of Deals Closed
  • Win Rate
  • Average Deal Cycle Time
  • Sales Rep Productivity

Marketing Performance

  • Marketing Qualified Leads (MQLs)
  • Website Traffic
  • Social Media Engagement
  • Email Marketing Click-Through Rates
  • Return on Marketing Investment (ROMI)
Previous: Programmatic Report Scheduler Access