September 16, 2013

Slooooooow Decay

Maybe this is happening in your business as well - you have items that generally sell well, and have been around forever.  Over time, these items experience a sloooooooow decay:
  • 2008 = $7.00 million.
  • 2009 = $5.60 million.
  • 2010 = $4.48 million.
  • 2011 = $3.58 million.
  • 2012 = $2.87 million.
  • 2013 = $2.29 million.
Think iPod, for instance.

My projects show a consistent trend. Best items, sometimes called "winners" or "heroes" or something equally compelling, erode at a slow rate. This is called the "decay rate". The average decay rate in my projects is between 10% and 30%. Those are big numbers! In the table above, the decay rate is just 20% - but over five years, 67% of the demand is gone.

Even worse, when a whopper of a winner decays, you'll frequently observe that best customers continue to buy the item - they're in the habit of buying it - and they tend to buy it in old-school channels (i.e. catalogs or email). This is destructive in two ways. First, the blend of customer and demand results in the item continually being featured, frequently with the best creative. This ages the catalog (or email marketing program) faster than normal. Second, it prevents newer items from getting the real estate necessary to become winners. I see this all the time. What would you do? Of course you're going to give the best real estate (catalogs, home pages, landing pages, email marketing) to the items that you know will work. In so many ways, we need to almost do the opposite - we need to give precious real estate to new items, so that new items can become winners.

Yup, happens all the time.

Here's another interesting problem. You can slow down the rate of decay by not introducing new products. If you don't give the customer new choices, the customer is forced to spend money on the old choices. Of course, this cannot work in the mid-term or the long-term, but I see it happening all the time.

If I asked 100 of you what your existing product decay rate is, how many of you would know the answer?

It's important to know the answer. Your marketing programs depend on you having product decay knowledge.

Hillstrom's Merchandise Forensics:

September 15, 2013

Dear Catalog CEOs: The 80/20 Rule

Dear Catalog CEOs:

Did you read this article (click here)?

A portion of this article made sense to me, and it directly relates to your catalog business.

Most of us are dealing with catalog marketing as if it was 1995. Deceived by the way matchbacks overstate results, we mail the same circulation depth we always have. If we used to mail 400,000 housefile names, then we still mail 400,000 housefile names.

Back in 1995, our profit and loss statement looked like this:
  • Demand = $3.00 per customer.
  • Profit Factor = 30% of demand.
  • Cost of the Catalog = $0.40.
  • Profit = $3.00 * 0.30 - $0.40 = $0.50 per customer.
Today, when we properly evaluate incremental demand via mail/holdout tests, our profit and loss statement looks like this:
  • Demand = $3.00 per customer.
  • Incremental Demand = $1.50 due to catalog, $1.50 happens anyway online.
  • Profit Factor = 40% of demand.
  • Cost of the Catalog = $0.60.
  • Profit = $1.50 * 0.40 - $0.60 = $0.00 per customer.
Now, 9 in 10 catalog CEOs would look at this situation, and say "fine, we'll keep mailing customers".

Of course, in five years, the relationship is going to look like this:
  • Demand = $3.00 per customer.
  • Incremental Demand = $1.00 due to catalog, $2.00 happens anyway online.
  • Profit Factor = 45% of demand.
  • Cost of the Catalog = $0.65.
  • Profit = $1.00 * 0.45 - $0.65 = ($0.20) per customer - a loss.
But there's no sense talking about what is coming ... you are busy projecting 2014 as we speak.

Back in 1995, the 80/20 rule was largely intact ... but it meant that you could mail very, very deep, and keep generating profit.

Today, with the internet (and, increasingly, mobile) generating sales that happen independent of a catalog, without any catalog mailings at all, the 80/20 concept allows you to greatly free up your advertising budget. 20% of the 12-month buyer file is responsible for 80% of the demand generated by a catalog - the world has changed.

In fact, in most of my Catalog PhD projects, I can cut 25% to 30% of the housefile circulation with only a 2% to 5% impact on demand, greatly increasing profit.

Go rank your housefile circulation, top to bottom - then sum cumulative profit. I'll bet you learn that almost all of your profit comes from the top of the housefile. 



Purchase on Amazon, click here.

Hire Kevin for your own Catalog PhD project - email me (kevinh@minethatdata.com).

September 14, 2013

Merchandise Forensics Being Discounted By Amazon - $8.63

If you like discounts and promotions, and I think you do, then you'll love the fact that Amazon is discounting the new Merchandise Forensics text ... for Amazon Prime members ... from $11.95 to $8.63 ... print version only.

Here's a link to the print version (click here).

And a link to the Kindle Version (click here), $7.95.

Click here for file layouts if you're thinking of hiring me for a project - Merchandise Forensics projects are about 60% of my work these days. This file has been downloaded 39 times in the past two days alone, so there's interest, folks!

If you work in a large office, don't you think every one of your employees deserves a copy? Don't you? Why not order a dozen or two dozen copies, one for everybody!


September 12, 2013

Dell and Merchandise Forensics

By now, you've read that Dell is going private. Click here for some of the details.

This post is not meant to pick on Dell. It's meant to get us to think.

Why do I want you to study Dell? Well, they did an awful lot of the things that the experts tell us to do - good decisions.

  1. They are social media leaders, heck, they're monitoring every word of text I'm writing as we speak - it's almost like the NSA! If you're best at social media, it should cause breakthrough sales gains, according to the experts.
  2. They are omnichannel leaders. They moved into retail, not their own branded stores, but you can go to Wal-Mart and get the goods. That's called "bricks 'n clicks" by the experts. We're told that retail plus e-commerce is unbeatable.
  3. They are promotional gurus - the carousel on the mobile site (remember, mobile or die) as of this writing (9/12) shows summer clearance, a $200 promo eGift card, and a coupon for smart shopping. Of course, that ignores merchandise, and what Dell sells is merchandise, but what the heck, it's the tickling of the buying bone that marketers love. We're told we have to do this, all day, every day, to "remain competitive".
Ok, how did omnichannel + social pay off?
Maybe sales went bonkers, given the bricks 'n clicks approach and the omnichannel tactics and promotional strategy and social media wizardry?
  • Net Sales, February 1, 2008 = $61.1 billion.
  • Net Sales, February 1, 2013 = $62.1 billion.
So, what happened? How could a combination of omnichannel excellence, social media power, and promotional tactics yield ... well ... this?

Merchandise?

Dell has tons of smart people, more than most companies. If they performed a Merchandise Forensics analysis, they'd quickly observe that existing products were tiring, while recent new products failed to generate the volume prior new products generated, leaving Dell with no choice but to try to maximize omnichannel + social + promoitons to compensate for merchandise challenges. 

This is a big theme, folks, one I see repeated everywhere - merchants struggle, marketers get yelled at, so marketers go bonkers on channels and ad dollars and promotional strategies. It's a time honored tradition. It's a sign of a ailing business model.

On February 1, 2008, the iPhone was reasonably new, the Android operating system was in a stage of relative infancy compared to today, and the iPad was thirty months away from introduction.

In other words, the merchandise world that Dell participated in changed.

You, too, can see these things happening in your business. They begin to happen subtly, the metrics appear but net sales largely hold their own. It's pretty darn important to run a Merchandise Forensics analysis, to stay on top of key issues.

Hillstrom's Merchandise Forensics:

September 11, 2013

It's Here! Hillstrom's Merchandise Forensics

We spent much of the summer talking about Merchandise Forensics, and for good reason. Twenty recent projects strongly suggest that merchandising issues, not marketing challenges, are the primary reason why a business struggles to grow.

In "Hillstrom's Merchandise Forensics", I explore analytical techniques that clearly illustrate how merchandising challenges result in reduced customer productivity, and decreased marketing productivity.

Here's the thing, dear readers. I'm tired of watching the marketing department get pummeled every time the business does not grow. I mean, it's late 2013. Think about how many times a twelve-month buyer learns about your brand:
  • Six to forty catalogs from catalog brands.
  • +/- 100 email marketing messages.
  • A mobile experience.
  • A website that can be visited 24/7/365.
  • Search, paid and organic.
  • Social media.
In other words, a customer is going to hear about your business multiple times a week. Multiple times each week!! What more do you want the marketing department to do? Should they sit in the living room of every customer and demand that the customer purchase merchandise immediately?

Of course, the marketing department can do a better job. But so can the merchandising department.

This booklet helps the marketing team figure out why a business is struggling to grow, via merchandise productivity. I use actual data to explain how new items, existing items, price points, discounts/promotions, seasonal issues, Cyber Monday (yes, it causes problems), merchandising categories, new customers, and existing customers all interact to limit overall business productivity. The reports are reasonably simple and straightforward to create. There's no reason somebody in your analytics/marketing department cannot produce these reports for you, on a monthly basis. And if they won't, then you contact me (kevinh@minethatdata.com) and I'll do it - now!!

As mentioned earlier, Merchandising Forensics projects now make up the majority of the work I do. I worked on at least twenty projects of this nature since 2012, in sixteen of the projects, I was able to easily identify a merchandising issue that held the business back.

If we've learned anything, it's that having an infinite number of marketing channels and a half-dozen customer contacts a week does not cause sales to increase. What causes sales increases are customer love for merchandise. And increasingly, my projects illustrate that we are doing a very, very bad job of developing new merchandise.

You can buy this booklet in one of two ways.
And you can contact me right now (kevinh@minethatdata.com) to have your own, customized Merchandise Forensics project prepared ... contact me now, because projects are going to line up really fast (click here for file layouts).

Again - I'm tired of watching the merchandising team point fingers at the CEO, CFO, CMO, and marketing team, as if the merchandise they sell was perfect and they were not accountable for challenges. Granted, merchants suffer a disproportionate amount of scrutiny - but it isn't the fault of the CFO, CMO, or marketing team that nobody wants to buy odd merchandise. So buy this booklet, then hire me, then have data at your disposal to help everybody understand why 3,439 channels haven't resulted in a sales increase.

Sales are not increasing because customers don't want to buy the merchandise. Measure it! Buy the book right now!

Cyber Monday Tip #3

Cyber Monday does not happen uniformly, across channels. Not at all. Cyber Monday aligns with a specific customer who has specific interests.

This outcome is pretty common:
  • % Nov-Dec Phone Demand On Cyber Monday = 2.5%.
  • % Nov-Dec Online Demand On Cyber Monday = 7.4%.
  • % Nov-Dec Email Demand On Cyber Monday = 8.1%.
  • % Nov-Dec Search Demand On Cyber Monday = 8.8%.
  • % Nov-Dec Affiliate Demand On Cyber Monday = 9.2%.
What does this tell us about Cyber Monday demand?

Phone demand is usually catalog-driven, and therefore, was generated weeks prior. Catalogs mailed in early-mid November are largely responsible for phone demand on Cyber Monday. Or it tells us that old-school, 55+ rural customers don't care about Cyber Monday. Either way, they're not participating.

Online demand is driven from a mix of many activities. Overall Cyber Monday awareness yields a higher percentage here. Also - keep in mind, there are 61 days in Nov/Dec ... when you generate 7.4% of demand on just 1.6% of the timeframe, well, that's staggering. If profitable, this is good. If the sales are all discount-centric, well, this is potentially very harmful.

Email demand is at an even higher rate. I see this happen when the business promotes Cyber Monday via email. Too often, email buyers are already discount buyers, and are exactly the ones who are compelled to buy on Cyber Monday. We flush gross margin dollars out the door, not helping anybody but the journalists who crow about Cyber Monday.

Search demand is at an even higher rate still. Attribution lovers know that email campaigns drive customers online to search for the lowest prices and best promotions. Cyber Monday is a timeframe where email + search = big discounts.

And finally, Affiliate demand possesses the highest Cyber Monday demand rates. The customer hunts relentlessly for the best deal - I mean, who wants to pay 40% off plus free shipping on Cyber Monday, right? That's too much when you can find 50% off plus free shipping somewhere else!

So, tip #3 is to measure the share of demand in Nov/Dec that happens in each channel on Cyber Monday. If you see rates comparable to what we observe above, you'll want to flag Cyber Monday buyers in your database by channel, so that you treat them differently during the rest of the year.

Or, you can contact me (kevinh@minethatdata.com), and I'll do the work for you!

September 10, 2013

Cyber Monday Tip #2

Continuing our series on Cyber Monday, the giddy online holiday designed to give away gross margin so that the media have something to talk about ... let's move on to Tip #2.

Tip #2 involves existing customers and new customers. In most of my projects, Cyber Monday does not yield a significant increase in new customers, compared to the rest of November/December.
  • % January - October Buyers New = 45%.
  • % November Buyers New = 57%.
  • % Cyber Monday Buyers New = 55%.
  • % December Buyers New = 53%.
The scenario painted above is typical. We see that customer rates are similar through November/December.

Let's assume that you promote more heavily on Cyber Monday than the rest of November/December.
  • November Buyers = 38% Use A Promotion.
  • Cyber Monday Buyers = 90% Use A Promotion.
  • December Buyers = 42% Use A Promotion.
In this situation, you begin to expose yourself to a challenge. You essentially acquired customers via promotions instead of a more reasonable mix of full-price purchases and promotions.

I like to run 12 month repurchase models - measuring how much customers spend on full-price and discounted products. Here's a typical outcome for full-price demand.
  • November Newbies - Future Full Price Demand = $40.00.
  • Cyber Monday Newbies - Future Full Price Demand = $27.00.
  • December Newbies - Future Full Price Demand = $38.00.
And here's a typical outcome for future demand tied to a discount/promo code.
  • November Newbies - Future Demand Tied To A Discount Code = $25.00.
  • Cyber Monday Newbies - Future Demand Tied To A Discount Code = $36.00.
  • December Newbies - Future Demand Tied To A Discount Code = $25.00.
Remember, in our example, we brought on newbies via a promotion during Cyber Monday. And while future demand is largely similar (counting demand at full price, and demand tied to a discount/promo code), demand shifts to discount/promo codes. This causes the demand to be less profitable, causing us to conclude that shifting demand into Cyber Monday is not optimal for this hypothetical business.

Of course, your mileage will vary.

But how do you know unless you run the analysis yourself?

Contact me (kevinh@minethatdata.com) for your own Cyber Monday analysis.

Curiosity and Contempt

Early in my tenure at Lands' End, I worked for a department head that had a level of business curiosity that was nearly unmatched over t...