Posts

Example of a Streaming TV Subscriber Dashboard for Media Companies

What is a Streaming TV Subscriber Dashboard?

Subscriber Dashboards are considered user analysis tools and are used by media executives and subscription managers to analyze monthly trends in user metrics. Some of the main functionality in this type of dashboard is that it provides monthly trend analysis from four different perspectives: 1) Current year (CY) and prior year (PY) subscribers by number of countries reached, 2) Paid subscribers added versus churned, 3) Total subscribers CY versus LY, and 4) US versus international subscribers. You find an example of this type of dashboard below.

Purpose of Subscriber Analysis Dashboards for Streaming TV

Media companies use Subscriber Analysis Dashboards for Streaming TV to enable self-service trend analysis for key subscription statistics. When used as part of good business practices in Subscription Sales and Content departments, a company can improve its revenue growth strategies, and it can reduce the chances that managers miss or react slow to important customer trends.

Example of a Subscriber Analysis Dashboards for Streaming TV

Here is an example of a Streaming TV Subscriber Analysis Dashboards with monthly trend charts.

Example of a Streaming TV Subscriber Dashboard for Media Companies

Example of a Streaming TV 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, Subscription Managers, Marketing Managers, Category Managers, Budget Managers.

Other Reports Often Used in Conjunction with Subscriber Analysis Dashboards for Streaming TV

Progressive Subscription Sales and Content departments sometimes use several different Subscriber Analysis 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 streaming radio media companies

What is a Subscriber Dashboard?

Subscriber Dashboards are considered statistical analysis tools and are used by streaming radio media executives to analyze monthly trends in subscriber metrics. Some of the main functionality in this type of dashboard is that it shows monthly trends for six different KPIs, including: 1) Current year (CY) and prior year (PY) subscriber reach by number of countries, 2) Comparison of number of added and churned subscribers per day, 3) Total users versus paid subscribers, and 4) Paid subscribers versus free subscribers. You find an example of this type of dashboard below.

Purpose of Subscriber Analysis Dashboards for Streaming Radio

Media companies use Subscriber Analysis Dashboards for Streaming Radio to provide a self-service tool to closely monitor monthly trends in the most essential subscriber metrics. When used as part of good business practices in Subscriber Sales and Media departments, a company can improve its marketing and product strategies, and it can reduce the chances that subscriptions underperform due to lack of timely and informed management decisions.

Example of a Subscriber Dashboard for Streaming Radio

Here is an example of a Subscriber Analysis Dashboard with streaming radio metrics and monthly trends.

Example of a Subscriber Dashboard for streaming radio media companies

Example of a Subscriber Dashboard for streaming radio 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 Subscriber Dashboards for Streaming Radio

Progressive Subscriber Sales and Media departments sometimes use several different Subscriber Dashboards, along with recurring revenue forecasts, recurring revenue dashboards, churn reports, subscription reports, sales forecasts, profit & loss reports, annual budgets, financial dashboards, KPI 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

pic 1

An increasing number of companies are adding subscriptions as one of the revenue models to their business. Two different examples of this service include:

  • Netflix, which is a 100% subscription-based company focused on B-to-C, or business to consumers.
  • Microsoft, which originated in an era where software sold as one-time licenses, has today become an increasingly subscription-based software provider, with most of their software delivered in a software-as-a-service (SaaS) model using their Azure cloud.

As companies begin to adopt subscription-based revenue models for their customers, accounting departments and finance teams find themselves in a new struggle. Tasks that once were relatively easy in a world of “one and done” sales deals, like invoicing, reporting and analysis, and budgeting for various types of subscription contracts can now be quite complex and time consuming. On top of that, companies now have to deal with monthly, annual and multi-year subscriptions. Other challenges center around existing customers and adding to or removing from their contracts, as well as, customer churn (cancelled subscriptions), and other complexities.

However, today’s customers using Microsoft’s two cloud accounting systems, Dynamics 365 Finance and Dynamics 365 Business Central are in luck. A Canadian software vendor by the name of Binary Stream has developed an add-in module called “Subscription Billing Management” (SBM), which in short allows accountants to elegantly manage their subscription contracts right within their Dynamics ERP system.

So, What About the Reporting, Budgeting and Forecasting for Subscription Data?

In collaboration with Binary Stream, the U.S.-based company, Solver, has expanded its Microsoft Dynamics 365 Finance and Dynamics 365 Business Central integrations to include key information from Binary Stream’s Subscription Billing Management app.

Solver is a modern Microsoft Azure-based, multi-tenant cloud solution that automates and streamlines reporting and planning processes. It is often referred to as a Corporate Performance Management (CPM) solution.

With Solver integrated to the Dynamics ERPs, as well as the Binary Stream app, customers benefit from financial and operational reporting that includes their subscription data, all in one single cloud portal. Furthermore, they can use Binary Stream SBM’s subscription data as a basis for single and multi-year revenue forecasts.

What are Examples of Subscription Reports and Budgets?  

The following are examples of specific reports and budget input forms created in Solver and based on actual subscription data flowing in from the integration available through Binary Stream’s SMB for Microsoft Dynamics app.

This first example shows a multi-year forecast going up to 10 years into the future. Based on the drivers seen in the yellow cells in the top left corner, the user can quickly generate monthly and annual subscription revenue forecasts.

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

Multi-year subscription revenue and churn budgeting and forecasting with monthly detail

When it comes to reporting, a flexible report writer like the one in Solver, can provide a multitude of report types to slice and dice subscription related data by metric, customer, and product.

The report below shows monthly recurring revenue (MRR) with metrics for new sales, upgrades/downgrades and churn. It also shows the monthly trend for the ending MRR.

Dashboard analysis of subscription metrics like MRR and Churn

Dashboard analysis of subscription metrics like MRR and Churn

The report below shows a chart and data on an eight-quarter rolling basis. This makes it easy for users to analyze subscription revenue over multiple years. Any individual quarterly column can be expanded to display detail for the three underlying months.

Eight quarter rolling subscription revenue report with monthly detail

Eight quarter rolling subscription revenue report with monthly detail

The Scheduled Billing report example seen below can be run for any given period. It helps accountants see the specific payment status per invoice per customer, including total, balance, deferred and recognized amounts.

Scheduled billing report showing recognized and deferred revenue per customer

Scheduled billing report showing recognized and deferred revenue per customer

Sometimes the finance team needs to analyze deferred revenue by customer. The example below shows deferrals by month for the remainder of the current year and then displays the summary for the next three years into the future.

Multi-year deferred revenue by customer report for the next three years

Multi-year deferred revenue by customer report for the next three years

In conclusion, as a company with a subscription-driven business model, you have a solid cloud-based accounting system with Microsoft Dynamics Finance or Dynamics Business Central. When adding Binary Stream’s app for Subscription Billing Management, you get a specialty add-in that is completely focused on helping you manage your subscriptions. By connecting Solver’s cloud-based reporting and planning solution, you now have a best-in-class suite to not only help with day-to-day accounting and analysis, but can also keep a keen eye on the future with world-class budgeting and forecasting functionality.