Case Study: Michael Andrews Bespoke

In this case study we review the company, Michael Andrews Bespoke (MAB), sales strategy, and monetization opportunities using our Decision Architecture methodology to illustrate the application of these methods in an actual business context. MAB has a business objective to grow revenue by 10 percent and has hired you to create a monetization strategy that they can execute to achieve this goal.

We begin with the Discovery phase of our Decision Architecture methodology.

Discovery

Michael Andrews Bespoke (MAB) is a New York City–based custom couturier founded with the goal of crafting fine tailoring for discriminating clients. They accomplish this through designing, customizing, and producing quality men's professional clothing using the best fabrics with the height of style. MAB's clients value quality and service. MAB's stylists are experts at meeting the uniquely high standards of each client, one at time.

Growing Revenue

MAB's business is focused on a high-end niche segment with few of the price pressures typical of mass fashion markets. Delivering high-quality products with excellent service is table-stakes if the business is to survive. Clients of custom clothing place a high value on quality, design, and fashion and are willing to invest when they find a provider meeting their exacting needs. With a business model that is highly personal and differentiated, profitability is not the primary challenge as in most of fashion retail. Rather MAB's challenge is to attract prospects who value custom clothing, convert them into a full-package wardrobe experience, and retain them in a long-term client relationship.

Client Acquisition

MAB's acquisition strategy involves attracting the attention of discerning clients through various channels such as search optimization, website, email campaigns, and advertising in targeted magazines. The best channel for attracting new clients is referrals from satisfied clients.

Client Engagement

When a client new to custom clothing makes their first visit to MAB's well-appointed studio, a MAB stylist introduces the client to the custom clothing experience of hand-crafted and personally styled menswear. More than simply selling high-end men's clothing, MAB's stylists pride themselves on expert and honest style advice, offering opinions on everything from the best cut to the most flattering patterns and colors. Through this process, clients with means and appreciation for perfectly fitted clothing become committed to an investment in personal style and a quality wardrobe.

Client Retention

MAB retains valuable clients through quality production and timely delivery of their products. MAB offers free alterations on garments for six months after delivery to ensure their clients are satisfied. From this level of personal interaction, clients view MAB as their partner in their clothing experience. Clients satisfied with the quality of MAB's service and products engage in a long-term relationship with MAB over years, maintaining their wardrobe, adding new styles, and replacing worn clothing.

In sum, MAB's business is driven by acquiring discerning clients, committing these clients to an investment in a personally styled wardrobe, and retaining them in a long-term partnership.

Client Types

The heartbeat of MAB's business is its client base. MAB thrives on meeting the professional and personal needs of clients who value custom clothing and are seeking a partner to bring their style to life. Custom clothing clients are passionate about their wardrobe, viewing it as an essential tool of their livelihood and an expression of their personal self.

In thinking about the client base, MAB finds it helpful to evaluate the client types based on their wardrobe desires and needs. After discussion with Michael Andrews, the founder and namesake of MAB, we learn of two core needs leading a client to invest in a custom wardrobe. Based on these core needs, clients can be broken down into two primary persona types:

  1. The Wardrobe as a Professional Asset

    New York City is a rich market for clients who are expected to wear high-end suits every day to work, such as investment bankers and lawyers. While they appreciate quality and good service, these clients view their clothing as an extension of their work and consider the investment in a custom wardrobe as a cost of doing business. They trust MAB to deliver the right style that will set them apart within the norms of their industry.

  2. The Wardrobe as an Expression of Personal Style

    This client type loves clothes, can afford them, and wears suits to work even when not required because he wants to. He views his clothing as an extension of himself. This persona is seeking to build a complete custom wardrobe to speak to his personality. He buys slowly, concerned about fit and design. He likes being part of the design process and can be more discerning and value conscious. This type of client will budget specifically for his wardrobe investment.

Other, secondary client personas that MAB serves include:

  1. Purchasing for Special Events

    Another client type that MAB services are guys shopping for a special event, such as a wedding. They are willing to spend extra to ensure they look their best for the special day. Tuxedos are the primary clothing item these clients will purchase.

  2. Purchasing to Enhance Their Style

    MAB also attracts the guy who loves clothes and collects clothing experiences, following styles and fashions, changing with the times. This client seeks out MAB to purchase a custom suit to add to his ensemble, often with exacting requirements because he is seeking to fill a specific niche in his wardrobe.

  3. Hard to Fit

    The final client type that MAB services is the hard-to-fit guy. Falling outside the norm of physical dimensions, unable to find ready-to-wear options that fit, often his only option is custom tailoring for the times when he needs to look his best.

Client Life Cycle

The typical life cycle of a client's journey in the custom clothing experience follows three stages:

  1. Exploratory Stage

    At this stage, clients try out the custom clothing experience and/or the stylist they engage to service them. They may begin with a suit or jacket and pant order to see what works for them. If they have the financial means and are well-served, they engage in a longer-term relationship with MAB. Clients facing a special event or challenge or seeking to enhance their wardrobe may not move beyond the exploratory stage, but nonetheless are a valuable source of business for MAB.

  2. Commitment Stage

    If MAB is successful in providing a client the style, value, and service they require, they will engage in a relationship that can span years. Clients in the commitment stage investing in a custom wardrobe for the first time or overhauling an existing wardrobe will typically spend a considerable sum of money on a wardrobe comprising suits, sport coats, pants, and shirts.

  3. Maintenance Stage

    Having established their core wardrobe, a client will maintain it, replacing items over time as they wear out or styles change. The professional wardrobe client, viewing his wardrobe as an extension of himself, is more likely to maintain his wardrobe over an extended period of time due to the utility nature of his clothing needs. The personal wardrobe client's motivation for his wardrobe investment is personal and intrinsic; once satisfied, his volume of purchase activity may decrease.

Business Analysis

Michael Andrews began the business in 2006 based on his personal passion for custom clothing, growing it to be a successful operation by 2009. Reaching his personal capacity to market and service the business, Michael brought on two stylists who helped him quadruple the business in just four years. As the client base evolved from the exploratory stage to the commitment stage, MAB needed to make a greater investment in stylist time and teamwork in order to service the more demanding needs of the client. With expansion of the stylist force to service the growing business, the original stylists, strong individual contributors, struggled and eventually left the business in 2013. Even with the departure of his two most experienced, top-grossing stylists, Michael was able to face the challenge of building his stylist team while maintaining strong revenue growth.

Three years later, in 2016, with the stylist team on solid footing, MAB annual revenue growth has continued on a strong trajectory, between 7 and 8 percent for the past three years. Michael's business problem is one many managers would love to have. He wants to develop a strategy to take a healthy company with good growth and make it better.

To understand key drivers of the business, we perform initial discovery to identify metrics we can use to evaluate MAB's business growth opportunity. When engaging in discovery, it is helpful to work from the top down, first examining overall performance and then successively drilling into underlying components.

In many of the charts we present, absolute values with respect to revenue have been removed to preserve the confidentiality of the data; however, the patterns and trends are not obscured.

Business Performance

The first observation we can make is that while MAB has healthy revenue growth, total client orders have been declining since 2011.

Spend and Order Volume

In 2010 Michael expanded his stylist force to service his growing client base. In 2011 and 2012, MAB's business focused on higher volume, lower spend clients. However, whether a client buys one or several suits, time spent servicing the client is approximately the same. When they repeat purchase, less time may be needed, but many clients purchase only once or twice a year, so time efficiencies are not easily gained.

Figure CS.1 is a graph representing the growth in client spend versus the decline in client orders. The company is able to devote more of the stylist's time to servicing clients at a higher spend level, thereby resulting in larger purchase orders and growing revenue.

	Image described by caption and surrounding text.

Figure CS.1 Annual Client Spend and Orders

Business Capacity

We know from a capacity analysis that the order servicing capacity is approximately 190 orders per month, considering normal hours of operation and preserving ample studio space for each client to have a comfortable experience. During peak season, MAB may work extended hours to accommodate the bursts in business. However, we observe that from 2011 through 2013, MAB frequently encountered capacity constraints managed by a combination of stylist overtime, extended studio hours, and perhaps a more crowded studio and less time per order.

Following Michael's change in strategy to focus on clients seeking the full custom wardrobe experience, order volume has decreased to a manageable range and hovers right at order capacity for the current studio (Figure CS.2).

A plot with curves plotted for 2010 to 2015 for monthly orders relative to estimated capacity.

Figure CS.2 Monthly Orders Relative to Estimated Capacity

Client Performance

MAB has served over 5,000 clients since it began business. Clients returning after their initial purchase account for about 50 percent of its business and on average order about 2.5 times per year, spending approximately $5,000 per year. The remaining 50 percent of clients explore a relationship with MAB, spending about $2,500 in their initial order.

From 2012 to 2013, spend per client plateaued, threatening overall revenue growth as MAB was operating at full capacity with respect to studio space. Due to the high cost of studio space in New York City and minimum time to fit a client, Michael shifted his acquisition strategy to focus on clients purchasing wardrobe packages versus individual items. In this way, he could improve resource efficiency and continue to grow revenue without having to make expensive investments in additional studio space. Furthermore, MAB's target clients are discerning customers, placing a high value on service and product quality given the investment they are making. Continuing to pursue a high-transaction strategy versus an annuity business would likely impact repeat sales.

Acquisition

Following retooling of its marketing strategy and stylist force in 2013, MAB has been successful in attracting and retaining clients focused on investing in a quality wardrobe and seeking a trusted partner to service their needs. Average spend per existing client continues to increase (Figure CS.3).

A plot for average annual spend by client type with curves plotted for returning clients and new clients.

Figure CS.3 Average Annual Spend by Client Type

Retention

As MAB's client base ages in tenure with the company, it has been successful at engaging clients in a long-term relationship, with returning clients accounting for 50 percent of its client base by 2016. Figure CS.4 shows the retention rate, year-over-year, from returning clients. To elaborate, in 2012, 29 percent of the sales came from clients from prior years and 71 percent of orders came from new clients. In 2015, 50 percent of orders came from clients from prior years and 50 percent of orders came from new clients.

A comparative bar plot with bars split for multi-year client and first year client for client retention by order year.

Figure CS.4 Client Retention by Order Year

Figure CS.5 shows the client retention by year of first order, which tells us the percentage of clients by retention category: multiyear client, one-year client, or onetime client. Each year is a cohort, that is, 2015 represents clients who first ordered with MAB in that year.

A comparative bar plot with bars split for multi-year client, one-time client, and one-year client for client retention by year of first order.

Figure CS.5 Client Retention by Year of First Order

To explain further, from the 2010 class, 48 percent are still clients today, 15 percent were clients for just one year, and 37 percent were clients just once.

For the 2014 class, 21 percent of the clients are still customers today, 20 percent were customers for just one year, and 63 percent of them were customers just once. The ending report period for this dataset is July 2016, so the 2015 class of customers have not yet had a full additional year to reorder; hence, the low multiyear client percentage.

One insight we draw from this analysis is that in 2010, MAB had a great crop of clients that have remained loyal and are still clients. In addition, with each passing year the number of returning clients is increasing, building a solid base for MAB to expand upon.

Business Levers for Monetization

Next we identify the monetization business levers available to Michael to achieve his revenue growth objective. We have learned that Michael's business is a top-line business so we focus on the Revenue branch of our Business Lever framework. We have also learned that clients typically order about twice a year, much of which is driven by spring and fall seasons. Custom clothing ordering is an involved process requiring a significant commitment of time for fitting, refitting, and waiting for production and delivery, a process that is not easy to fit into clients' busy schedule on a more frequent basis.

While price is a potent lever in every business, the market for custom clothing is not as price sensitive as other retail clothing segments, and as we learned in discovery, Michael has capacity constraints that are expensive to expand. Driving more volume through lower price will likely have a negative impact on profitability. Channel expansion is an action to be considered as well, but we are drawn first to the opportunity to grow revenue organically. We have learned that approximately 50 percent of MAB's first-time clients only purchase one time and 15 to 20 percent of clients do not return after the first year of ordering. We believe there may be an opportunity to drive revenue growth organically through proactive targeted marketing focused on retaining and engaging more clients in a long-term relationship. Figure CS.6 calls out the Business Levers we believe Michael can consider in developing revenue-driving actions. Further analysis will determine which of these levers will deliver the most promising results.

A chart of monetization business lever candidates with text boxes connected by lines.

Figure CS.6 Monetization Business Lever Candidates

Hypothesis

With these insights, we are ready to articulate our hypothesis to guide development of our Decision Architecture.

Next Steps

Upon the completion of the Discovery phase we have achieved a good understanding of client types and life-cycle stages. Looking forward, we can apply data science to MAB's data to estimate purchase patterns to understand the degree to which MAB has been successful in acquiring, committing, and retaining clients.

We can use insights to seek out untapped opportunities for organic revenue growth through increased engagement and retention of its existing client base, the most cost-effective sales channel there is. This analysis can help MAB develop effective strategies to retain strong clients and grow high-potential clients.

Lastly, we can identify KPIs and success metrics that MAB can use to monitor the performance of its monetization strategies and act quickly on opportunities to improve through Guided Analytics. In sum, we can help MAB monetize its data.

Decision Analysis Phase

We begin the Decision Analysis phase by conducting several working sessions to create our Question Analysis, Category Tree, Key Decisions, Action Levers, and Success Metrics. Following is a review of each of the outputs of our work.

Question Analysis

Our Question Analysis helps us determine how Michael thinks of the business when solving a problem or trying to find an opportunity. Through our Question Analysis, we align to the base hypothesis that MAB's strongest growth engine is its client base, through which it can grow business organically through retention, engagement, and referrals. Figure CS.7 summarizes the key questions that arose from the working session.

  1. Q1 How are sales performing over last month and this time last year?
  2. Q2 Who are our high-value clients and are we getting the most from our current business?
  3. Q3 Which clients do we believe are undervalued?
  4. Q4 Which clients offer the best opportunity to improve?

Figure CS.7 Questions from Working Session

The first question Michael asks is, how are they performing? To gauge the health of the business Michael wants to know if business sales are up or down over this time last year and how sales are trending overall. This performance-based questioning is part of the Inform level of questions in our analytical cycle.

In continuation with this line of questioning, Michael wants to know the number of appointments, as this is a key indicator of the health of the organization. For example, if Michael were to only look at sales for a given weekend, a large order resulting in a big sale may mask the fact that not many clients made appointments, hinting at a bigger issue.

The next set of questions can be grouped into several categories: Orders, Client Segmentation, Client Engagement, and Client Retention. All four of these categories are at the Diagnose level in our analytical cycle as Michael is trying to problem-solve for issues or generate opportunities.

Category Tree

From our Question Analysis, we develop our Category Tree. Figure CS.8 shows the categories and hierarchy of the question groupings.

Image described by caption and surrounding text.

Figure CS.8 MAB Category Tree

We also capture the types of analysis Michael would like to perform in the Inform stage.

  1. Performance—The first analysis is centered on helping Michael answer the set of questions on how the store is performing today and over time. Is MAB improving performance over same time last year? Is customer spend per order healthy? Are we encountering capacity constraints, and if so, how often?
  2. Client Profile—This analysis is focused on client profiles to understand the mix of business and types of clients against several segment attributes.
  3. Client Segmentation—For the Client Segmentation analysis, we would like to know if MAB's client base can be segmented into groups of clients based on similar attributes and behavioral characteristics that can be used to identify opportunities for improvement. By comparing segment order history, we would like to know whether MAB's share of clothing spend can be improved through a greater scope of purchases, such as sport jackets and pants, in addition to suits and shirts. What indicators can MAB use to be more targeted in identifying prospects who have the potential to develop into a fuller partnership for their garment needs with respect to variety, value, and quantity of garment purchases?

In the Diagnostic stage of the analytical cycle, we would like to perform three diagnostics:

  1. Client Engagement—The first diagnostic is centered on opportunities for various marketing activities. As MAB expands its client base it will increasingly encounter constraints with showroom capacity and stylist availability. Located in the heart of New York City, expanding studio space and the stylist force represents a significant investment in space and overhead costs. Michael is anxious to invest in the growth of his business but at the same time he would like to optimize his existing investment and ensure the business grows profitably. With better targeting of client engagement through unique marketing activities, Michael would like expansion needs to be driven by clients who have a sustaining value for the MAB experience.
  2. Client Retention—About 50 percent of MAB's business in a year is new clients. Michael would like a diagnostic centered on the high-potential clients who are not likely to return the following year based on data science efforts of a threshold time period in order to target them for engagement marketing. In addition, he would like to know if signs of possible attrition of his best clients can be identified in order to implement preventative measures.
  3. Order Fulfillment—The final diagnostic is based on the process to fulfill orders. In this diagnostic, Michael would like to know the status of orders to better determine scheduling and optimization of the appointment calendar.

In working with Michael, we decide to focus on the following analytics: Performance, Client Segmentation, Client Engagement, and Client Retention.

Key Decisions

After framing Michael's questions and building our Category Tree, we develop key decisions that came from our working sessions. As we learned in our discussion on Decision Analysis, decisions are developed through diagnostic analysis and usually come at the end of the root-cause analysis set of questions. Following is a list of questions with the resolving decision. (Please note that decisions are denoted by D.)

  1. Q1 How are sales performing over last month and this time last year?
  2. Q2 Who are our high-value clients and are we getting the most from our current business?
  3. Q3 Which clients do we believe are undervalued?
  4. Q4 Which clients offer the best opportunity to improve retention and engagement?
    1. D1 Which clients among my high-value clients show a risk of leaving?
    2. D2 Which exploratory clients should I work to engage in a long-term relationship?

Let's see how the decisions we have identified map back to our Business Levers (Figure CS.9).

Image described by caption and surrounding text.

Figure CS.9 Decisions Mapped to Monetization Business Levers

Action Levers

Next we want to understand the possible actions we can take from our decisions. These should be actions that Michael can execute to drive a decision. From our two decisions, the team developed the following actions. (Please note that actions are denoted by A.)

  1. D1 Which clients among my high-value clients show a risk of leaving?

    1. A1 For multiyear clients who have not been to the studio in over 6 months, offer a free shirt to come back in as part of a “test a new style” campaign.

  2. D2 Which exploratory clients should I work to engage in a long-term relationship?

    1. A2 For multiyear clients not in the high-value spend tier, target a marketing event to drive to a more engaged relationship.

    2. A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship.

We return to our Business Lever framework once again and map the actions we will execute through our Monetization Strategy to the levers we selected (Figure CS.10).

Image described by caption and surrounding text.

Figure CS.10 Actions Mapped to Monetization Business Levers

Success Metrics

Now that we have our decisions and actions, we need to understand the major metrics that drive these decisions. Let's see what metrics we have for each of these decisions. (Please note that Success Metrics are denoted by SM.)

  1. D1 Which clients among my high-value clients show a risk of leaving?
    1. A1 For multiyear clients who have not been to the showroom in over 6 months, offer a free shirt to come back in as part of a “test a new feature” campaign.
      1. SM Clients not ordering in 6 months or greater as a percentage of total
  2. D2 Which exploratory or one-year clients should I work to engage in a long-term wardrobe relationship?
    1. A2 For high-value clients, target a marketing event to drive to a more committed relationship.
    2. A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship.
      1. SM Distribution of high-potential clients by Engagement Score

Decision Architecture

At this point, we have completed the Decision Analysis section of our Decision Architecture template. To recap:

Business Objective Grow revenue by 10 percent.
Hypothesis MAB has a strong asset in its client base that it can leverage to drive organic revenue growth through frequency of engagement and retention performance.
Decision Analysis
Questions Q1 How are sales performing over last month and this time last year?
Q2 Who are our high-value clients and are we getting the most from our current business?
Q3 Which clients do we believe are undervalued?
Q4 Which clients offer the best opportunity to improve retention and engagement?
Decisions D1 Which clients among my high-value clients show a risk of leaving?
D2 Which exploratory clients should I work to engage in a long-term relationship?
Metrics SM 1 Clients not ordering in 6 months or greater as a percentage of total
SM 2 Distribution of high-potential clients by Engagement Score
Actions A1 For multiyear clients who have not been to the studio in over 6 months, offer a free shirt to come back in as part of a “test a new style” campaign.
A2 For multiyear clients not in the high-value spend tier, target a marketing event to drive to a more engaged relationship.
A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship.

Monetization Strategy, Part I

We now have two components of the steps needed to develop our Monetization Strategy. We have decided to develop customer engagement and retention strategies and have selected the Business Levers of customer retention and order quantity as the target of our actions.

The next steps assess availability of competitive and marketing information and evaluate our strategy against our Guiding Principles. Following more discussion with Michael Andrews we capture the following requirements:

Competitive & Market Information
Industry Information None
Competitive Intelligence Through competitive websites we know our competitions' prices and that many of them are moving to annuity relationships with multiyear clients.
Market Information None
Monetization Framework Components
Quality Data The data is acceptable for initial analysis.
Be Specific We want to target our actions to specific clients to increase engagement and improve retention.
Be Holistic The types of marketing and promotional activities need to fit with the overall brand of MAB.
Actionable Specific actionable events and marketing activities need to be developed.
Grounded in Data Science Develop a segmentation technique to group like customers.
Perform analytics to create an Engagement Score and Potential Lift.
Monetary Value Generate expected revenue lift.
Confidence Factor or Probability We do not plan to provide a confidence factor.
Decision Matrix We plan to leverage a Decision Matrix.
Measurable We will be able to measure based on specific client sales.
Drives Innovation We are innovating our marketing activities based on a new client segmentation methodology and directly targeting specific clients.

We will continue to develop our Monetization Strategy as we progress through the project.

Agile Analytics

To develop the analytics to answer the questions in our Decision Architecture methodology, we gather the relevant data and develop the analytic structure necessary to expose the trends and patterns that will guide our analysis.

Using an extract from MAB's CRM system containing all orders since 2010, we have data that provides information with respect to date, type, quantity, and value of items purchased per order. Even with the relatively small number of order attributes we are able to develop an analytic structure that will provide a rich analytic dataset to data-mine.

In this next section we walk through the development of the various metrics, discuss Data Development, and review the analytic structure we put in place to facilitate analysis of MAB's client opportunities.

Data Analysis

Having identified the success metrics that measure our strategy, we turn our attention to the following metrics to enable diagnostic analysis and performance monitoring.

  • Operating metrics
  • Diagnostic metrics
  • Performance metrics

Operating Metrics

Operating metrics, the most basic of business metrics, measure the ebb and flow of core business processes and resources, capturing the interactions between the key assets of the business. In the case of MAB, key assets include its client base, stylist base, New York showroom, product offering, and production processes. In order to measure the capacity of the stylist network and the showroom to support increased business volume, we need to understand metrics that relate client purchases to stylist servicing time as well as available servicing capacity in the showroom.

We use operational benchmarks based on Michael's expert knowledge of the business to analyze relationships between clients, orders, and stylist. If further refinement is needed, Michael could choose to employ operational research methods to gain a deeper understanding of MAB operations.

Product Operating Metrics

Typical wardrobe order package 6 suits, 3 jackets, 5 pants, 20 shirts
Typical wardrobe order value $20,000 to $40,000

Stylist Operating Metrics

Stylist client hours per order 3 hours
Stylist time on admin 15% per month
Available stylist hours per month (including vacation, holiday, and personal time off) 147 hours
Stylist client-servicing capacity (no overtime) 42 orders per month
Stylist base (4 full-time stylists, 1 stylist 50% management) 4.5
Stylist base capacity benchmark 189 orders per month 2,268 per year

Studio Capacity Metrics

Client available appointment hours per month 142 hours
Simultaneous client-servicing capacity 4 clients
Studio hours per client 3 hours
Studio servicing capacity benchmark 190 orders per month 2,280 per year

Based on our current analysis, MAB may encounter capacity constraints with respect to studio space and current stylist load when client orders exceed 190 per month. With MAB's location in New York City, increasing studio space is not a trivial decision. We can use Appointment Analytics to help evaluate options to increase studio capacity incrementally and cost effectively. In addition, we can use it to monitor capacity utilization and anticipate when to implement options like overtime during particular seasons.

Diagnostic Metrics

We utilize diagnostic metrics when we employ data science to analyze the current client base. Our diagnostic analysis can deliver valuable insights into the behavioral aspects of the client types by life-cycle stage.

It is helpful to segment clients by descriptive and behavioral attributes, allowing us to examine similarities and differences in performance trends and patterns among segments of the client base. With meaningful and behavioral-based segments, examination of the internal structure of the performance metrics can guide us to actions that can be taken to improve overall results.

MAB Performance Diagnostic Metrics

Year of first purchase (cohort year) Calendar year of first purchase with MAB
Client tenure at order On the date of the order, years or months since month of first purchase
Attrition rate Percent of clients active in the prior year but not active in the current year
Retention rate Percent of clients active in the current year who ordered in prior years
Client monthly spend Total monthly spend per client
Spend on core garment types: suits, shirts, jackets, pants, tuxedos,
including accessories, net of discount, not including gift cards purchased
Client lifetime spend Cumulative amount of spend per client from first purchase through reporting period
Client order tenure Number of years the client has ordered core garment types
Client order scope Cumulative number of core garment types ordered per client
Acquisition channel Marketing channel through which the client contacted MAB, customer referral, paid media, Internet search, other

MAB Performance Metrics

Clients and orders are the heartbeat of MAB's business, so the performance metrics will focus on client orders and spend on a monthly basis.

Revenue Metrics

Average spend per client per month Average value of all orders in a month net of discounts
Average spend per client per order Average value of all orders per client net of discounts

Client Metrics

With the focus of our Monetization Strategy on organic revenue growth, our client performance metrics measure how good MAB is at retaining existing clients and acquiring new ones.

Client retention rate (annual) Percent of clients in the current year with purchase activity in the prior year
Client acquisition rate Percent of clients in a month or year who are first-time clients, total and by channel

MAB KPIs

KPIs measure progress on goals and are the top-line metrics that monitor overall performance of the business.

Total Client Spend Total spend by clients on core garment items (suit, shirts, jacket, pants, tuxedo)
Annual, monthly; year-over-year variance
Total Client Orders Total count of orders by clients, which include core garment items (suit, shirts, jacket, pants, tuxedo)
Annual, monthly; year-over-year variance

Data Development

Data produced by operational systems is rarely found in the form and quality needed for analytics. The MAB data is not a complex dataset and comes from a well-organized CRM system, but it still requires some cleansing and transformations in order to prepare it for our analytic purposes. The following are some issues typical of many analytic projects.

Field Names

The field names in the dataset are not user friendly or intuitive so we apply transformations to field names to make them more useful.

Original Field Name Transformed Field Name
Invoice__r.Client__r.Occupation__c Client Occupation
Invoice__r.Date__c Order Date
Invoice__r.Invoice_Number__c Order Number
Invoice__r.QB_Stylist_Initials__c Stylist
InvoiceName__c Invoice Name
Item_Name__c Item Type
Order_Item__r.Price__c Price
Order_Item__r.RecordType.Name Item Category

Hierarchies

Product or service hierarchies are among the most difficult elements to manage in reporting systems. For example, core items in a wardrobe are suits, shirts, jackets, pants, and tuxedos. The CRM system has a field to categorize item types, but the Shirt category has two groupings and the Tuxedo category has four, introducing a lower level of granularity than the other items in the same list. In order to ensure a complete analysis of shirts, we add an additional field—item category—to group shirt and tuxedo types to a similar level as the other item types.

Item Category Order Item Type
Suit Suit
Shirt Shirt
Casual Shirt
Jacket Jacket
Pants Pants
Tuxedo Tuxedo
Tuxedo Jacket
Tuxedo Pants
Tuxedo Vest

Inconsistent Values

Occupation is the field where we encounter the greatest incidence of inconsistent field values. However, Occupation is a field that is important to our segmentation analysis, so we group and standardize the values into a meaningful set. The original dataset has 889 unique values for occupation. In our final set, we reduce the list to three categories and 16 types.

Sample of Original Values

  1. Occupation
  2. Web design
  3. Web designer
  4. Web developer
  5. Web development
  6. Website analyst
  7. Trial attorney
  8. Trial lawyer
  9. Trucking/Art
  10. TV—reporter
  11. TV executive
  12. TV reporter

Cleansed Values

Occupation Category Occupation Type
Finance Finance
Legal Legal
Personal Advertising and Media
Arts and Design
Business
Education
Hospitality
Lifestyle
Medical
Military
Politics
Real Estate
Retail
Sports
Technology
CEO
Other Not Listed

Analytic Structure

While sorting out data issues, we also study the inherent structure of the data and the transformations we need to uncover insightful patterns.

The MAB dataset is extracted from a CRM system that we import into our analytic database to produce the data layer. We apply transformations to create a set of views in the analytic layer to develop the metrics we need for analysis. We then bring the views together in the reporting layer to create the analytic dataset we need for analysis, diagnostics, and reporting. The completed analytic data mart structure is shown in Figure CS.11.

Image described by caption and surrounding text.

Figure CS.11 MAB Analytic Data Mart

We next connect our visual analytic tool to the Client Order analytic dataset and develop the metadata to organize the data as shown in Figure CS.12.

Image described by caption and surrounding text.

Figure CS.12 MAB Metadata

Transformations

As we explore the data for structure, we also develop the transformations needed to develop the diagnostic and Success Metrics for analysis and reporting.

Creating fields to measure client tenure is a good example of typical transformations needed to support analytics. From the dataset we have a field that captures the date of the order. Many clients order two or three times a year but in different calendar months on different days. As custom clothing is not an everyday purchase and requires six to eight weeks to complete the process, tracking order by month will be sufficient for our purposes. Client tenure is a measure of the number of months from the initial order for subsequent orders. For example, the year and month of a first order date in January 2016 is tenure month 0. A subsequent order by the same client in June 2016 is tenure month 5.

This is important as we want to look for patterns when we contrast clients in comparable periods in their order experience, for example, comparing a client's order metrics, such as quantity of items, number of item types, and value of order, for clients in their initial tenure month and their second tenure month.

First we create a metric to calculate client tenure month:

equation

Next we transform the metric to tenure years:

equation

As time progresses, we keep track of the maximum value of the client tenure as of the latest date of reporting:

equation

Finally, we identify tenure segment to use for analysis:

equation
If Maximum Client tenure years at time of order = 0 then Onetime Client
Else Maximum Client tenure years at time of order = 1 then One-year Client
Else Multiyear Client

We perform a similar transformation for the diagnostic and Success Metrics we identified earlier.

Data Science

To help provide more insights into the data, we employ several data science techniques. These include building attribute-level segmentations that provide flexibility to group like customers based on various client descriptive and behavioral characteristics. In addition, we perform a statistical box-plot analysis to gain insights into natural cohorts to help create the segmentation groupings.

Attribute Segmentation

In our Decision Analysis and Monetization Strategy phases, we developed monetization strategies and actions to drive organic growth through improved client engagement and increased retention. Applying engagement and retention strategies to each and every client could be overwhelming for MAB financially. MAB needs to be smart about which clients to target in order to create a profitable growth engine.

Using tools of Data Science, we develop a segmentation model for MAB to help Michael develop strategies and focus resources on client engagement and retention monetization strategies most likely to deliver a financial return.

A valuable client will purchase a variety of garment types (suits, shirts, jackets, pants, and tuxedo) yearly. Such clients are investing in a custom wardrobe because they view it as an extension of their occupation and/or their personal expression. With these characteristics in mind, we identify three attributes—occupation, purchase scope, and tenure—to build our segmentation model.

Client Descriptive Attributes
Occupation Industry/position with custom of wearing suits
Industry/position without custom of wearing suits
Client Tenure Years since the date of first order
Client Behavioral Attributes
Purchase Scope Number of different garment types purchased (suit, jacket, pants, shirt, tuxedo)

Behavioral Segmentation

We choose a standard tool of statistical analysis, the box-plot, a technique that visualizes descriptive statistics of mean, spread, and outliers, as the method to determine the segmentation level for the behavioral attributes. Given the relatively small number of data points and high degree of variation in the dataset, we prefer to measure client behavior using the median, a measure of central tendency, instead of the average in order to reduce sensitivity to outliers. Using box-plot charts, we look for natural breaks between values of our segmentation attributes to inform our grouping of clients by similar behavioral characteristics.

Purchase Scope

The first attribute we examine is purchase scope, a measure of the variety of garment types the client purchases. Suits, shirts, jackets, and pants are foundational garment types for a complete wardrobe, with tuxedos a frequent add-on for more formal occasions.

Using a box-plot analysis, we determine there is a meaningful difference in lifetime value of client spend between two and three garment types purchased. While clients purchasing two garment types have a wider range of lifetime spend, the median spend is half that of clients purchasing three garment types. This translates to clients spending, on average, 50 percent more than those who only purchase two garment types. These individuals have selected MAB as their partner to create a fuller wardrobe than just suits and shirts. This is a big epiphany for us and can drive many of our actions.

While clients purchasing four garment types spend more than those purchasing three, the difference in median spend is only 30 percent. We decide to group clients with purchases of three or more garment types into a scope segment labeled Wardrobe and group those with two or less as Ad Hoc.

We also identify a segment labeled Wedding to track clients who purchase for special events and are less likely to return for other items. These are clients with a onetime order that includes a tuxedo, although there may be other garment types on the order.

The box-plot diagram in Figure CS.13 is segmented based on how many garment types clients ordered. When reading the box-plot, the darker-shaded dots represent individual customers and the line between the light and dark-gray boxes is the median lifetime spend for that group.

Image described by caption and surrounding text.

Figure CS.13 Client Order Variety of Products Ordered Statistical Analysis

Descriptive Attribution Segmentation

Descriptive attributes are easier to segment than behavioral attributes because the segments are defined by intrinsic characteristics of the analysis target. We identify two descriptive characteristics that we believe are meaningful to our analysis: occupation and tenure.

Occupation

When a client opens an account, MAB attempts to collect information with respect to their occupation in order to better tailor their design selection. As demonstrated earlier in the Data Development section, this information is not standardized or complete, but we can work with what we have.

Clothing standards in the business world have relaxed greatly over the past several decades, particularly with the growth in technology and startup firms. However, two occupations, Finance and Legal, especially in New York City, have sustained the custom of wearing suits every day in their work. Comprising 44 percent of MAB's client base and accounting for 53 percent of spend, we take these two occupations as individual segments.

Examining the client base, we find a wide range of client occupations not in Finance and Legal, but in areas that we take as an indicator of a client's interest in custom clothing as a personal expression. We group these clients into a category labeled Personal. Finally, we note a large number of clients with no occupation indicated and group these clients into a category labeled Other. We assign clients to one of these occupation types based on their designated Occupation/Position.

Occupation Segment
Occupation Type Occupation/Position
Finance Finance
Legal Legal
Personal Advertising and Media
Arts and Design
Business
CEO
Education
Hospitality
Lifestyle
Medical
Military
Politics
Real Estate
Retail
Sports
Technology
Other Not Listed
Tenure

We already touched on client tenure when we discussed attrition and retention. We know that segmenting the base by client tenure helps to identify targets for engagement and retention strategies. As mentioned earlier, because clients do not typically order on a monthly basis, we define tenure segments based on years of relationship with MAB since the initial order.

Tenure Segment
Onetime client Ordered only during the first month of the date of the initial order
One-year client Ordered only during the first year of the date of the initial order
Multiyear client Ordered more than one year from the date of the initial order

MAB Client Segmentation

Having completed our segment analysis, we summarize our segmentation model in Figure CS.14.

Segment Type Segment Description Segment Elements
Client Attribute Segments
Occupation Industry/position with custom of wearing suits Finance
Legal
Personal preference to wear suits Personal
Occupation not known Unknown
Tenure Years of order activity Onetime client
One-year client
Multiyear client
Client Behavior Segments
Order scope Types of clothing articles purchased (suit, jacket, pants, shirt, tuxedo) Wardrobe > 2 garment types
Ad Hoc 1 to 2 garment types
Wedding, onetime order with a tuxedo

Figure CS.14 Client Segmentation Model

We validate our segmentation model by evaluating the distribution of clients in the various segments, seen in the next three figures. In these charts, the bars represent the number of clients and the circles represent the median lifetime spend.

In Figure CS.15, segmenting by order scope, we see that our Wardrobe clients, those who purchase more than three different types of garments, have a lifetime spend on average more than 50 percent larger than clients who only order two garment types. This tells us that when clients purchase three or more types of garments from MAB, they begin to see MAB as a solution for their wardrobe, not just for individual articles of clothing. An opportunity presents itself to target clients in the Ad Hoc segment, encouraging them to expand the scope of their garment purchases with MAB.

A bar diagram for segment by order scope.

Figure CS.15 Segment by Order Scope

Figure CS.16 shows clients segmented by tenure. In the first cohort, the clients only ordered once and their median lifetime spend was $3,000. In the second cohort, the client ordered only during their first year with MAB with a median lifetime spend of $7,000. In the last grouping, those clients who have been with MAB for multiple years have a median lifetime spend of $12,000.

A bar diagram for segment by tenure.

Figure CS.16 Segment by Tenure

The last of our charts to validate our segmentation is Figure CS.17. In this analysis we group clients into occupations segmented as Personal, Finance, and Legal. The three categories have distinctive attributes for targeting marketing and sales initiatives. The Finance segment has the highest lifetime spend of the three segments (considering the overall average for the Personal segment), which validates our initial assumption.

Image described by caption and surrounding text.

Figure CS.17 Segment by Occupation

Monetization Strategy, Part II

At this point we are ready to bring our analysis together to support our monetization strategy of organic growth through engagement and retention. First, let's look at our Client and Spend Distribution based on our segmentations (Figure CS.18). In order to keep the analysis relevant, we limit our charts to clients who have purchased within the last 24 months.

A bar diagram for segment by occupation.

Figure CS.18 Client and Spend Distribution

Next we create a consolidated segmentation matrix to understand the distribution of the client base and their key metrics, as shown in Figure CS.19. However, this table may not be the best visual representation of this information.

Image described by caption and surrounding text.

Figure CS.19 Client Segmentation Table

To help Michael spot the opportunities quickly, we leverage the principles of UI discussed in earlier chapters to create a more impactful visualization, as shown in Figure CS.20. (Note that the width of the bars is relative to number of clients.)

Image described by caption and surrounding text.

Figure CS.20 Client Segmentation Chart

Let's deconstruct the chart.

One-time Clients

Examining our Client Segmentation Matrix (Figure CS.18) for clients active with MAB during the past two years, we observe that clients ordering from MAB only one time, not surprisingly, tend to fall in the lower third of lifetime spend. One-time–Wardrobe clients have a higher spend but there are not many of them. Clients in the one-time order segment represent 36 percent of clients but only 12 percent of spend. There are a number of reasons that clients order only one time. Some clients value the quality and fit of custom clothing but have limited budgets. Some clients give MAB a try but opt for another preferred partner, or other reasons. While MAB welcomes all clients passionate about custom clothing, the probable return on investment for clients in this segment does not justify the expense of a proactive marketing strategy.

One-Year Clients

The one-year cohort provides some interesting opportunities. Clients in this group, representing 17 percent of the total clients and 15 percent of spend, present a value opportunity. One-year clients in the wardrobe segment are in the top two-thirds lifetime spend tiers and are good candidates for a retention strategy. Selective marketing actions targeted at this segment are likely to produce increases in client value and conversion to multiyear clients. One-year clients in the Ad Hoc segment fall in the lower third of lifetime spend and may present some selective opportunities.

Multiyear Clients

Multiyear clients are MAB's best clients, representing 47 percent of clients but 73 percent of spend. Multiyear–Wardrobe clients represent 33 percent of clients and 63 percent of revenue. MAB offers discounts for high-spend orders and various marketing activities targeted at this high-value segment. However, it would be helpful to MAB if clients showing early signs of possible attrition could be proactively addressed to prevent attrition.

Clients in the Multiyear–Ad Hoc segment fall into the top two-thirds of client spend and represent a rich opportunity for marketing programs to encourage increased engagement and expanded scope.

Figure CS.21 summarizes our recommended marketing strategies based on the opportunities by segmentation attributes that we have uncovered. The areas highlighted represent segments where MAB should target monetization strategies for retention and engagement to drive revenue.

nfgz021

Figure CS.21 Recommended Marketing Strategies

Monetization Strategy Requirements

With our segments for targeted marketing strategies identified, we are ready to complete our Monetization Strategy requirements.

Business Objective Grow revenue by 10 percent.
Hypothesis MAB has a strong asset in its client base that it can leverage to drive organic revenue growth through frequency of engagement and retention performance.
Decision Architecture
Questions Q1 How are sales performing over last month and this time last year?
Q2 Who are our high-value clients and are we getting the most from our current business?
Q3 Which clients do we believe are undervalued?
Q4 Which clients offer the best opportunity to improve retention and engagement?
Decisions D1 Which clients among my high-value clients show a risk of leaving?
D2 Which exploratory clients should I work to engage in a long-term relationship?
Metrics Clients not ordering in six months or greater as a percentage of total distribution of high-potential clients by Engagement Score
Actions A1 For multiyear clients who have not been to the studio in over six months, offer a free shirt to come back in as part of a “test a new style” campaign.
A2 For multiyear clients not in the high-value spend tier target, conduct a marketing event to drive to a more engaged relationship.
A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship.
Competitive & Market Information
Industry Information None
Competitive Intelligence Through competitive websites we know our competition's prices and that many of them are moving to annuity relationships with their multiyear clients segment.
Market Information None
Monetization Framework Components
Quality Data The data is acceptable for initial analysis.
Be Specific We want to target our actions to specific clients to increase engagement and improve retention.
Be Holistic The type of marketing and promotional activities need to fit with the overall brand of MAB.
Actionable Specific actionable events and marketing activities need to be developed.
Grounded in Data Science Develop a segmentation technique to group like customers.
Perform analytics to create an Engagement Score and Potential Lift.
Monetary Value Generate expected revenue lift.
Confidence Factor or Probability We do not plan to provide a confidence factor.
Decision Matrix We plan to leverage a Decision Matrix.
Measurable We will be able to measure based on specific client sales.
Drives Innovation We are innovating our marketing activities based on a new client segmentation methodology and directly targeting specific clients.

Decision Matrix

We move on to develop two decision matrixes to help us implement the actions identified in our Decision Analysis and Agile Analytics phases.

Engagement Monetization Decision Strategy Matrix

To enable Michael to make decisions on the first set of actions around Engagement, we develop a Decision Matrix to support an Engagement Monetization Strategy (Figure CS.22). This strategy will focus on moving clients from two segments, Multiyear–Ad Hoc and One-year–Wardrobe, to the Multiyear–Wardrobe segment.

Image described by caption and surrounding text.

Figure CS.22 Engagement Monetization Decision Strategy Matrix

Next, we focus on clients who have ordered within the past 24 months. As shown in Figure CS.23, MAB has 421 clients in these two segments with median lifetime spend ranging from $6,000 to $9,000. The median lifetime spend for Multiyear–Wardrobe segment clients is about $17,000, which we use for our target goal.

A diagram for decision matrix of engagement management strategy.

Figure CS.23 Engagement Monetization Strategy

We would like to develop engagement actions to migrate “likely to move” clients from these two segments and capture a part of the $8,000 to $11,000 lift per client in lifetime spend from the segment shift.

However, not all clients are likely to move segments for a variety of reasons. In order to implement a more effective strategy, we develop an Engagement Score based on recency of the client's last order and difference in lifetime spend from the $17,000 target. We reason that clients with more recent order activity and already close in lifetime spend to the $17,000 target are more likely to respond to marketing incentives. Our scoring rubric is shown in Table CS.1.

Table CS.1 Scoring Rubric for the Engagement Score

Percent Spend Diff Time Since Last Order Score Assigned Likely to Migrate Probability
> 0 and < 30% 0 to 6 months High 80%
> = 30% and < 60% 0 to 6 months High 80%
> = 60% 0 to 6 months Low 20%
> 0 and < 30% 7 to 12 months High 80%
> = 30% and < 60% 7 to 12 months Med 50%
> = 60% 7 to 12 months Low 20%
> 0 and < 30% 13 to 18 months Med 50%
> = 30% and < 60% 13 to 18 months Low 20%
> = 60% 13 to 18 months Low 20%

Our goal is to develop two strategies for moving clients to the Multiyear–Wardrobe segment. In order to develop our strategy, we will develop a Decision Matrix as shown in Table CS.2. As a reminder, acts, events, outcomes, and payoffs are the four building blocks of decision theory. Acts are the actions or decisions that a person may take. Events are the occurrences taking place, usually with a level of uncertainty. Outcomes are the results of the occurrences, and payoffs are the values the decision maker is placing on the occurrences.

Table CS.2 Engagement Monetization Strategy Decision Matrix

Client Tenure Client Order Scope Engagement Score Clients Lifetime Spend Target Lifetime Spend Potential Lift Opportunity—Migrate to Champaign Client Events—Full Engagement Outcomes—Clients Outcome Opportunity
Scotch Event—Invite Only
Multiyear Client Wardrobe High 97 16,463 20,000 3,370 326,850 50% 49 163,425
Multiyear Client Wardrobe Med 21 16,346 20,000 3,717 78,055 50% 11 39,028
Multiyear Client Wardrobe Low 182 8,933 20,000 11,210 2,040,183 20% 36 408,037
Multiyear Client Ad hoc High 14 16,125 20,000 3,398 47,569 80% 11 38,055
Multiyear Client Ad hoc Med 5 13,926 20,000 5,131 25,656 50% 3 12,828
Multiyear Client Ad hoc Low 189 5,835 20,000 13,647 2,579,333 20% 38 515,867
TOTAL 508 9,248 20,000 10,035 5,097,646 29% 147 1,177,239
Exclusive Group Dinner with Michael
One-Year Client Wardrobe High 10 15,761 20,000 4,580 45,798 80% 8 36,638
One-Year Client Wardrobe Med 4 15,069 20,000 4,121 16,484 50% 2 8,242
One-Year Client Wardrobe Low 104 7,365 20,000 12,085 1,256,840 20% 21 251,368
TOTAL 118 8,386 20,000 11,179 1,319,122 26% 31 296,248
TOTAL 626 9,094 20,000 10,250 6,416,768 28% 178 1,473,487

We outlined two actions in our requirements:

  • A2 For multiyear clients not achieving the spend target, conduct a marketing event to drive to a more engaged relationship.
  • A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship.

Let's build a potential monetization strategy targeting the entire segment. When we get to the final solution, we will decide on whom we target and the actual spend. For our strategy, the Act is two events, a Scotch Event for invited guests only, and an Exclusive Dinner with Michael Andrews. Both events are geared to promote continued engagement with MAB. The Events are the percentage of clients that convert to full engagement. The Outcome is the number of clients who migrate to the full engagement level. The Payoff is the opportunity value from the actions.

From our payoff matrix we see that we can generate $1.5 million in additional revenue, assuming full participation. We do not expect to be able to generate the full amount but believe we can execute strategies to capture some of this opportunity.

Retention Monetization Decision Strategy Matrix

The next monetization strategy is focused on client retention. MAB has a loyal base of Wardrobe clients who have ordered regularly over the years. These clients have a median lifetime spend of $17,000 and spend on average $5,000 per year. By monitoring the time since last order, MAB can proactively engage with these clients to ensure they continue to select MAB as their clothing partner.

As seen in Table CS.3, 283 of MAB's Multiyear–Wardrobe clients have not ordered in the last 7 to 24 months.

Table CS.3 Multiyear–Wardrobe Clients

Client Tenure Client Scope Time Since Last Order Clients Lifetime Spend Spend per Client per Year
Multiyear Client Wardrobe 0 to 6 months 294 $19,583 5,277
Multiyear Client Wardrobe 7 to 12 months 116 $16,218 5,333
Multiyear Client Wardrobe 13 to18 months 111 $13,662 4,259
Multiyear Client Wardrobe 19 to 24 months 56 $10,274 3,759
Total 577 $16,697 4,949

The Time Since Last Order metric can serve as a valuable alert drawing attention to clients who might be at risk of leaving. We develop a strategy to target a 50 percent-off shirt campaign to continue the relationship with these valuable clients.

Let's review our Decision Matrix for this Monetization Strategy (Table CS.4). Our Act is the Free Shirt Campaign. The Event is the “percent” of people who participate in additional orders. The Outcome is the actual number of clients that order. The Payoff is the revenue the action will generate, which in this case is $654,000 of potential revenue.

Table CS.4 Retention Monetization Strategy Decision Matrix

Client Tenure Client Scope Time Since Last Order Range Number of Clients in Segment Cost of Campaign Events—Additional Purchase Outcomes—Number of Clients Payoff—Amount of Potential Revenue Opportunity—Additional Year of Orders
Multiyear Client Wardrobe 7 to 12 months 116 $2,650 60% 70 $348,000 $5,000
Multiyear Client Wardrobe 13 to 18 months 111 2,650 40% 44 222,000 5,000
Multiyear Client Wardrobe 19 to 24 months 56 2,650 30% 17 84,000 5,000
TOTAL 283 46% 131 $654,000

Guided Analytics

Having identified how to tap into organic growth opportunities, Michael can execute and monitor his strategy using Guided Analytics. This is when the magic of a well-developed analytic data model comes into play, allowing MAB not only to monitor performance of the business at the highest level but also to identify specific clients to target for marketing actions within one seamless tool.

We map dashboards to corresponding nodes on our Category Tree (Figure CS.24) to guide the user through the analytic process. The tree structure depicts the analytic flow Michael navigates when considering the various questions, decisions, and actions.

Image described by caption and surrounding text.

Figure CS.24 MAB Category Tree with Dashboards

Let's walk through the guided experience to uncover the opportunities available to Michael to monetize his data. There are three dashboards in the Inform section that help Michael understand the health of the business and his clients. Based on issues or opportunities spotted, he navigates to one of two diagnostics: Client Engagement or Client Retention. Once in a diagnostic, he reviews the analysis in order to make a decision. From here, he moves to an Action dashboard that will help him find the right clients to target.

Making use of what we learned in the chapters on UI and UX, we design dashboards that are pleasant to view, quick to read, and easy to navigate.

Performance Dashboard

The Performance dashboard helps Michael monitor progress of the company, providing a snapshot of the current sales and orders as well as monthly and annual comparisons.

On the Performance dashboard there are also Success Metrics providing a window into opportunities and issues. Success Metrics connecting performance to diagnosis are displayed on Inform dashboards as well as Diagnostic dashboards. These metrics alert a user that an opportunity or issue exists and they need to do further investigation in a Diagnostic dashboard to make a decision.

Success Metrics we implement include:

  • Clients not ordering in 6 to 24 months as a percentage of total—This metric measures the number of clients who have not ordered within the past 6 to 24 months and therefore serves as an indicator of attrition. We apply this metric to high-value clients in the Multiyear–Wardrobe segment.

    An alert is signaled when the percentage of clients in an attrition risk exceeds 10 percent of total clients. The alert signals Michael that attrition risk is building and countermeasures should be considered. In our example dashboard in Figure CS.25, we see the metrics have turned a darker shade, alerting Michael to take further action.

  • Distribution of high-potential clients by Engagement Score—This metric assesses the ability to increase a client's degree of engagement with MAB. This metric scores individual clients on a scale of High, Medium, or Low. Clients scored high are expected to be more likely to respond to targeted marketing activities.

    Clients in the Multiyear–Ad Hoc segment with a better than low potential and One-Year–Wardrobe clients with high potential are highlighted in Figure CS.25. This tells Michael that these clients are good candidates for increased engagement.

Image described by caption and surrounding text.

Figure CS.25 MAB Performance Dashboard

Client Profile Dashboard

Once Michael has viewed the Performance dashboard, he may go directly to a particular diagnostic or navigate to the Client Profile dashboard (Figure CS.26). This dashboard is informational and provides a view in the various profile mixes of client base.

Image described by caption and surrounding text.

Figure CS.26 Client Profile Dashboard

The profiles include clients by Occupation, Tenure, and Product Scope, allowing Michael to understand the composition of the client base.

From here, Michael will go to the Client Segmentation dashboard to see if there are groupings of like customers where he might have an engagement or retention opportunity.

Client Segmentation Dashboard

The Client Segmentation dashboard (Figure CS.27) provides a quick view of the value of each of the client segments. On this dashboard, Michael can visually see if there are any opportunities of underserved segments that need additional engagement.

Image described by caption and surrounding text.

Figure CS.27 Client Segmentation Dashboard

We know that we have a Monetarization Strategy that buckets various segments into Engage and Retain. The dashboard provides a quick visual into the health of this overall strategy as well.

At this point, Michael wants to build an engagement strategy and will navigate to the Client Engagement dashboard to determine which of the clients in the Engage segments would fit a particular strategy.

Client Engagement Dashboard

There are two Client Engagement dashboards: Diagnose and Action. From our monetization strategy and our client segmentation, we are going to focus on moving clients to the Multiyear–Wardrobe segment, our highest-value segment.

We developed two actions that we would like to execute on:

  1. A2 For high-value clients, target a marketing event to drive to a more committed relationship. MAB has determined a Scotch tasting, invite-only event at a cost of $100 per attendee.
  2. A3 For newer clients who have placed large orders, conduct a group dinner to incent a multiyear relationship. MAB has determined a host group dinner with Michael Andrews at a cost of $200 per attendee.

From here, we need to determine who and how many clients we want to target for both events. We start with our Diagnose dashboard (Figure CS.28), which points us to the two segments. Michael decides that he will only take one action, the Scotch tasting event. He navigates to the Action dashboard to decide on the individual clients to invite.

Image described by caption and surrounding text.

Figure CS.28 Client Engagement Diagnostic

The Action dashboard (Figure CS.29) provides specific information to help Michael take action. On the dashboard we see Client Number, Average Lifetime Spend, Potential Lift, and Potential Lift Percentage. This information provides Michael with the most attractive clients to pursue based on the likelihood of the client generating revenue for MAB.

A digital capture of a table for client engagement action.

Figure CS.29 Client Engagement Action

The highest-potential clients identified on the Performance dashboard are sorted to the top and highlighted.

Michael decides to invite everyone in the Multiyear–Wardrobe segment and Ad Hoc segments with high engagement scores. This is a total list of 111 clients. If everyone attends, the cost of the event will be $11,100. From the event, Michael expects that 49 of the clients will increase their engagement with MAB, delivering an estimated revenue lift of $201,480.

Client Retention Dashboard

The next set of diagnostics Michael wants to see is focused on helping him execute a retention campaign of the clients that are at risk of leaving. Michael goes to the Client Retention diagnostic (Figure CS.30).

Image described by caption and surrounding text.

Figure CS.30 Client Retention Dashboard

On this dashboard, Michael is able to view the clients by segment to determine groups at risk by the number of clients in the segment who have not purchased within a particular period of time. Michael decides to focus on the clients in the 7 to 12 months since last order window to attract them back into the store and refresh the relationship (Figure CS.31).

Image described by caption and surrounding text.

Figure CS.31 Client Retention Dashboard by Client

The MAB staff develops a Try a New Style Shirt campaign to entice these high-value clients to come back into the studio. The campaign will cost $100 per client, for a total of $11,600 in costs if all 116 clients take them up on their offer. The team expects to generate $6,000 in orders from 20 percent of the clients, yielding $63,600 in additional revenue.

Closing

We have gone through the entire Decision Architecture methodology to create an analytical solution for MAB. The process started with Discovery and understanding the business of Michael Andrews Bespoke and fine custom tailoring. We also reviewed the business objective and developed a hypothesis to take advantage of the business opportunity. We selected business levers to act as the common thread through our project, tying the business problem to the hypothesis to the actions.

In the Decision Analysis phase, we developed our Decision Architecture requirements comprising our Category Tree, Question Analysis, Key Decisions, Action Levers, and Success Metrics. The requirements help us figure out how to solve the hypothesis and what data we will want to use for our analytical solution.

The Monetization Strategy was developed concurrently with the Decision Analysis and Agile Analytics phases. In the Decision Analysis phase, we developed the requirements that came from the Decision Analysis. In the Agile Analytics phase we developed our specific Monetization Strategies.

In the Agile Analytics phase, we completed our solution through the development of the Data Development and Analytical Structure. We used Decision Theory and Data Science to create Success Metrics to drive the decisions and action execution. In addition, we built our Decision Matrix to guide Michael to the various decisions. Finally, we utilize the principles of Guided Analytics to build our final solution.

The analytical solution we developed enables Michael to monitor the health of his business through the Inform dashboards (Performance, Client Profile, Client Segmentation). Once an issue or opportunity is spotted, Michael is able to diagnose the situation and map a plan of action down to the client level for retention or engagement actions.

It is these types of solutions that help companies take advantage of the troves of information they are flooded with and enable decisions that drive revenue through monetization strategies. We hope you have already begun your journey to build these solutions for your company. Let's continue the dialog at monetizingyourdata.com.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset