Business Intelligence Blog from arcplan

Customer Analytics: See the Truth with Data Visualization – Part III


I’m wrapping up my series on customer analytics and their associated visualizations with a discussion of 3 more metrics you should track on your customer dashboards – customer lifetime value, accounts receivable, and bookings & backlog – and why these simple visualizations are effective because they extend the reach of data to more people in the organization.

Track Customer Lifetime Value with a Stacked Bar Chart

One of the most underutilized metrics is customer lifetime value (CLTV), which sits at the intersection of sales, marketing and finance. CLTV calculates the historic value of a customer over time and helps establish how much customer relationships are worth – and therefore how much money can be spent to acquire them.

It’s conventional wisdom that it costs more to acquire new customers than it does to maintain existing business. For many companies, customers become more profitable over time. It costs less to pick up the phone and sell additional licenses to an existing software customer than it does to fly a sales person to meet with a prospect for the first time. It costs less to run loyalty programs to keep customers happy than it does to sponsor a trade show to meet new prospects. But the costs of these programs, all of which are necessary for running a business, have to be taken into account when using the CLTV metric. Customer lifetime value shouldn’t be something that only finance teams look at. Sales and marketing professionals must use it to ensure that their acquisition program costs are in line with CLTV.

There are many ways to calculate customer lifetime value, but the simplest is…

Continue reading this post >>


Customer Analytics: See the Truth with Data Visualization – Part II


In Part I of this series, I covered some of the key metrics and visualizations that contribute to a 360 degree view of your customers. Today let’s explore two more metrics that reveal insights about your customers’ relationship with your company, and the graphs that best explain the data.

Track Net Promoter Score with a Gauge or Bar Chart

At B2B companies especially, you’ll often need to call upon your customers to serve as references in order to close new business. Some CRM systems like enable you to add checkboxes to indicate whether a particular customer will serve as a reference or not. It’s simple to run a report on that information, summarizing the number of checkboxes over the total number of customers, but visualizing a more robust metric on a dashboard keeps customer relationships top-of-mind with your marketing, sales, and customer support teams.

Many arcplan customers are going back to an old standby metric, the Net Promoter Score (NPS), which segments the percentage of customers who would recommend your products and services (“Promoters”), versus those who are satisfied but unenthusiastic (“Passives”) and those who aren’t happy and might go out of their way to voice negative opinions (“Detractors”). On a scale of 1-10 for the question “How likely would you be to recommend <<company>> to a colleague?”, Detractors are the people who choose 1-6, Passives choose 7-8, and Promoters choose 9 or 10:


Continue reading this post >>


Customer Analytics: See the Truth with Data Visualization – Part I


The idea of having a 360 degree view of your customers is not a new one, but actually getting it is a real challenge in our world of silo’d data. Customer analytics give you a better understanding of your customers, and the ability to spot trends, identify opportunities to cross-sell, up-sell or simply target them more effectively, ultimately optimizing your customer relationships. But to get these insights in one place, like a dashboard, you need to integrate separate data from CRM, accounting, and customer support systems. Without a BI platform in place – one that integrates data from many sources like arcplan – it falls on you, the decision maker, to waste time assembling the pieces necessary to come up with a view of your customers from these different systems.

But if you are looking to utilize your business intelligence software for customer analytics, this series of articles will help you define the metrics you should be tracking as well as the visualizations that most effectively portray the data.

Graph Customer Growth with Bridge Charts

The most common way to track customer growth over time is by using a bar graph to show year over year comparison. A simple bar graph might show you that 2 years ago, you had 100 customers, last year you had 107 customers and this year you have 120 customers. Using arcplan’s linear regression formula, you expect to have 125 customers next year.

The numbers and the forecast look great, but the real story may be a little more shocking once you properly visualize it.

Continue reading this post >>


On-Demand Webinar: A Visual Guide to Customer Analytics


View-WebinarCheck out arcplan’s latest on-demand webinar: 30 minutes on the metrics that will give you a 360 degree view of your customers and what chart types best tell that story.

A Visual Guide to Customer Analytics
Recorded Date: Wednesday, July 17, 2013
Speaker: Dwight deVera, SVP of Professional Services at arcplan

About this webinar:

It’s been popular for a number of years to talk about having a “360 degree view” of your customers, but achieving it in our world of silo’d data has been another matter. You know how difficult it can be to connect individual silos of information into one integrated view. You likely have many systems and technologies in place at your organization, and it falls on you, the decision maker, to waste time assembling the pieces necessary to come up with a view of your customers from these different systems.

This webinar is a back-to-the-basics, practical guide to getting a 360 degree view of your customers. We cover how to combine metrics in self-service dashboards that give everyone in your company a better understanding of your customers, and the ability to spot trends, identify opportunities to cross-sell, up-sell or simply target them more effectively, and ultimately optimize your customer relationships.

In this webinar, we present:

  • The sales, operations, financial, and customer support metrics you should be looking at
  • A way to leverage available systems and technology to remain nimble with your metrics (prioritizing and subscribing to them)
  • A solution for pulling together silo’d data into one integrated view

View the webinar >>


Analytics As A Catalyst For Positive Inflection


Year after year the hype surrounding data analytics becomes louder. Thought leaders and research organizations have sung the praises of analytics as a means for generating much-needed insight into business operations, and companies that have embraced analytics have been able to translate insight to better operational productivity and faster, more accurate decision-making. In a competitive business environment where your competition is just as hungry as you are to reach and secure new customers and where business leaders need to make accurate, fact-based decisions about the company’s future, analytics can be the game-changer that makes the difference between success and failure. Here’s how:

The beauty of analytics is that it can serve as a guideline for transforming sub-par business performance to one that is efficient and profitable. Whereas reports provide a historical view of what transpired, analytic output is forward-looking, and plays an integral role in helping executives plan for the future.
Continue reading this post>>