Posts

Example of a Category and Listener KPI Dashboard for Media Companies

What is a Category and Listener KPI Dashboard?

Category and Listener KPI Dashboards are considered statistical analysis tools and are used by media executives and content managers to analyze monthly trends in user and content metrics. Some of the main functionality in this type of dashboard is that it provides monthly trend analysis from six different perspectives: 1) Current year (CY) and prior year (PY) by number of countries reached, 2) Average daily listening (minutes) by desktop and mobile device, 3) Total users versus paid subscribers, 4) Monthly listeners by genre, and 5) Total songs and number of songs added per day. You find an example of this type of dashboard below.

Purpose of Category and Listener Dashboards

Media companies use Category and Listener Dashboards to give managers a clear picture of monthly trends and seasonality as it relates to streaming users and available content. When used as part of good business practices in Subscriber Sales and Content departments, a company can improve its marketing and category strategies. It can also reduce the chances that underperforming  subscriptions or categories go under the radar that otherwise would be evident looking at trend charts.

Example of a Category and Listener Dashboard

Here is an example of a Music Category and Listener Metrics Dashboard with six monthly trend charts and comparative data.

Example of a Category and Listener KPI Dashboard for Media Companies

Example of a Category and Listener KPI Dashboard for Media Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, Content Managers, Marketing Managers, Category Managers, Budget Managers.

Other Reports Often Used in Conjunction with Category and Listener Dashboards

Progressive Subscriber Sales and Content departments sometimes use several different Category and Listener Dashboards, along with recurring revenue forecasts, recurring revenue dashboards, churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, KPI dashboards, category dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Subscriber Dashboard for Media Companies

What is a Subscriber Dashboard?

Subscriber Dashboards are considered operational analysis tools and are used by executives, media and marketing managers to get important insights into subscriber KPIs, content preferences and trends. Some of the main functionality in this type of dashboard is that it provides analysis of user KPIs from four different perspectives, including: 1) Monthly trend in total number of users, 2) Number of added users and churn per day, 3) Subscriber reach by country (region/geography), and 4) Number of subscribers per genre. The filters on top of the dashboard enables slicing by year and station/business unit. You find an example of this type of dashboard below.

Purpose of Subscriber Analysis Dashboard

Media companies use Subscriber Analysis Dashboard to get a clear picture of the key user (subscriber) trends that drives the success of the company. When used as part of good business practices in Product and Marketing departments, a company can grow revenues by improving offerings and Go-To-Market tactics, and it can reduce the chances that managers are lacking visibility to subscriber churn and content preferences.

Example of a Subscriber Dashboard

Here is an example of a Subscriber Dashboard with trends in user KPIs as well as genre metrics.

Example of a Subscriber Dashboard for Media Companies

Example of a Subscriber Dashboard for Media Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, category managers, media managers, sales managers, marketing managers.

Other Reports Often Used in Conjunction with Subscriber Analysis Dashboard

Progressive Product and Marketing departments sometimes use several different Subscriber Analysis Dashboard, along with detailed subscriber reports, churn reports, financial statements, financial dashboards, sales forecasts, annual budgets and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from media traffic systems and enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples