February 06, 2007

Where's The Talent?

I participated in a vendor-sponsored survey today, answering questions about the relevance of a product the vendor wanted to sell to businesses.

Toward the end of the survey, the person asking questions queried me regarding what the first thing is that I would purchase if I had an additional $100,000.

I told her, "A Highly Talented Analyst". Her response to my proclamation was "That's what every respondent says."

Somewhere between the strategy our leaders ask us to implement, and all the tactics we employ to drive sales and profit, we have a gaping pothole on the multichannel marketing turnpike that needs to be filled with an immediate infusion of talent.

We give Google responsibility for driving fifteen percent of our online business. In the process, we give all the intelligence of knowing why our business works to Google. We hire internal staff and vendors to be subject matter experts at manipulating Google.

Half of UK businesses fail to adequately measure the performance of their e-mail campaigns.

Maybe it's ok that we don't measure the ROI of e-mail campaigns, given that the performance of e-mail continues to free fall. As mentioned yesterday, we celebrate a medium where we sell something to one customer in five hundred. My father sold vacuum cleaners door-to-door in the 1960s. Do you think he would have celebrated one sale in five hundred visits?

In the past ten years, I observed at least three trends that resulted in a dearth of talent.
  • Demographics: There are far fewer thirty to forty year old employees than there were ten years ago, as Gen-X moves into their prime earning years.
  • Algorithms: We learned how to manage computers, or we learned how to manage businesses that managed technology. We spent less time understanding why our businesses worked. We spent more time managing the technology that made our businesses work. Now, we're a slave to technology. We need to be slaves to understanding why customers purchase from our businesses.
  • Strategy vs. Tactics: The time we spend on tactics, especially those tactics that allow us to manage algorithms, takes away from the time we need to spend developing strategies. Take an honest look at the company you work for. Can you identify the three strategies your company is working on in 2007 --- and do you know which tactics you can use to make your strategy happen?

We need to spend time developing humans (not algorithms), teaching the skills humans need to be effective in a world dominated by real-time algorithms.

Where you can, spend more money developing your employees, and spend less money outsourcing your key functions to vendors. Obviously, there is a balance to be achieved in outsourcing key functions. Where possible, invest in your own people.

Use today to develop tomorrow's leaders.

February 05, 2007

E-Mail Marketing: Success Or Apathy?

Assume that your average e-mail marketing program has the following metrics:
  • An open rate of 26%.
  • Among those who open the e-mail, 30% clicked-through the e-mail to your website.
  • Among those who clicked-through to your website, 2.8% purchase something.
When we multiply the metrics together, we learn that 0.26 * 0.30 * 0.028 = 1 in 458 customers who received the e-mail decided to purchase something on your website.

Considering that the marketing cost of e-mail is virtually free, the ROI of your e-mail campaign is utterly spectacular. Woo-hoo!

Let's take a second look at the metrics of your campaign:
  • Nearly three out of four of the people who received your e-mail didn't even bother to open it.
  • Only 0.26 * 0.30 = 7.8% of your list cared enough to visit your website.
  • Just 1 in 458 customers purchased something, a 0.2% response rate.
Do you consider your campaigns a success, if it had a spectacular ROI, but was completely ignored by three out of four recipients, and only harvested one purchase among four hundred and fifty eight of your loyal customers?

What do you pay more attention to, the outstanding ROI, or the complete apathy of your customer base?

February 04, 2007

Virtual CEO: Coldwater Creek and Inventory Management

Through comments and e-mail, many loyal readers of The MineThatData Blog voiced their opinion on creating a good customer experience when items are sold-out on a website. This discussion started when Becky Carroll talked about items being pulled from her shopping cart during a recent online shopping experience at Coldwater Creek.

What has been discussed can be summarized around at least four key constituents.

First, you have the customer, who rewards outstanding shopping experiences with loyalty and word-of-mouth.

Second, you have the inventory executive, responsible for the unforgiving task of not buying too much merchandise (requiring markdowns, and less profit), while at the same time not buying too little merchandise (causing lost sales, less profit, and a reduction in customer loyalty).

Third, you have a management team that prioritizes the work of the information technology folks, ultimately determining what the online customer experience looks like to the consumer.

Fourth, you have the Chief Executive Officer, responsible for determining an incentive plan for her leaders, an incentive plan that rewards leaders for accomplishing company objectives.

In most direct-to-consumer businesses, one of the primary objectives is to maximize fulfillment while minimizing markdowns. There is a sweet spot where profit is maximized. When too much merchandise is purchased, markdowns occur.

Markdowns are horrible for a business, because the business freely gives up profit to pay for mistakes in execution and anticipation of fashion. A $100 item that has a $50 cost of goods yields $50 of profit. Marking the item down to $69 to clear it reduces profit on that item from $50 to $19. Worse, the customers who buy the item are often discount-oriented customers, meaning there are fewer loyal customers willing to pay for something at full price.

Lost sales are also horrible for a business, as evidenced by Becky's post. Lost sales can create a bad experience if not executed correctly, and can reduce customer loyalty.

CEOs like to provide incentives to Inventory Executives, incentives that protect the profit of the overall business. An Inventory Executive might receive a larger bonus payout if he hits the 'sweet spot' between lost sales and markdowns. An Inventory Executive quickly loses his job when he fails to hit the sweet spot.

As a result, the Inventory Executive has a significant incentive to endorse any strategy that protects the profitability of the business, and the long-term prospects of keeping a well-paying job. This person could encourage any activity that is, theoretically, not a great customer experience, if it means that more data is collected on items where the Inventory Executive makes a mistake.

I am not saying this is what happens at Coldwater Creek. I am saying that seventeen years in this industry help me understand what the business is up against.

So here is a challenge for all of my readers who responded via comments and e-mail on behalf of the customer (I have yet to receive one response supporting the leaders of a business).

Pretend you are the CEO of Coldwater Creek. Knowing what you now know about managing inventory, how would you set up a bonus plan for your leadership team that achieves the following:
  • Protects the 'sweet spot' where your inventory team doesn't purchase too little merchandise, or too much merchandise.
  • Provides incentives for your creative or online marketing team to write language that is customer friendly when merchandise is not available, or is about to run out.
  • Provides incentives for your IT staff to work outside of company-stated priorities to fix problems like the shopping cart issue that frustrated Becky, while still addressing company-stated priorities.
  • Provides incentives for your analytical folks to develop analytical tools to correctly forecast potential sales when items run out.
What would your bonus plan look like for your leadership team, to accomplish these objectives?

An even more intriguing question to consider --- what do you do when your CEO and Inventory VP don't have a passion for the customer experience, won't allocate resources to fix the problem, are not likely to be fired in the next few years, and are delivering outstanding sales and profits? Now what?

Is An Item Profitable?

So many of us in multichannel retailing are asked to quantify how individual marketing activities perform.

We measure the effectiveness of an e-mail campaign. We prove that catalogs and direct mail drive business to the online channel.

Congratulations, we demonstrated that advertising works! Maybe.

Now it is time for us to measure how advertising influences the sales of individual items. I don't sense that our industry is doing the best job of measuring the profitability of an individual item, after factoring in the effect of advertising.

At the end of this post, I include a template for measuring the overall profitability of a specific item. In this case, we advertise the item through catalogs, through e-mail campaigns, and through online advertising (search, portals). During the course of an eight week period of time, we total the sales of the item, both online and over the phone. We also sum all advertising of that item.

What follows is a multichannel profit and loss statement for an item. This exercise should be replicated for every item sold by your business. Yeah, that's a lot of work. But how else are you going to know what sells, what sells because it is advertised, and what doesn't drive profit?

Quite honestly, the advent of the online channel has reduced our industry's zeal to understand the profitability of items. In catalog, it is easy to measure profitability. We need to have a passion for understanding which items truly work, across all channels.

Here, then, is a mocked-up template for the multichannel profitability of a single item. If you work for a business that also has a retail channel, simply add an additional section to the template for the retail channel.

Multichannel Merchandise Profit And Loss






Catalog Metrics




Catalogs Mailed
1,000,000
Total Pages in Catalog
124
Total Book Cost $1.00 $1,000,000
Percent of Page Allocated
33.0%
Cost To Advertise This Item
$2,661
Total Responses
225
Response Rate
0.02%
Response per 000 Pages
0.07%
Units per Order
1.15
Total Units Sold
259
Price per Unit
$65.00
Total Demand
$16,819
Fulfillment Rate 88.0% $14,801
Return Rate 25.0% $3,700
Net Sales 66.0% $11,100






Online Metrics




Total Visits To The Website
1,483,005
Total Visits, This Item
4,593
Total Website Cost, Non Adv.
$800,000
Cost Allocated To This Item
$2,478
Placed In Shopping Cart 25.0% 1,148
Total Responses 55.0% 632
Units per Order
1.08
Total Units Sold
682
Price per Unit
$65.00
Total Demand
$44,334
Fulfillment Rate 94.0% $41,674
Return Rate 25.0% $10,418
Net Sales 70.5% $31,255






Multichannel Profit And Loss Statement



Multichannel Net Sales
$42,356
Gross Profit 48.0% $20,331
Less: Book Cost
$2,661
Less: Website Cost
$2,478
Less: E-Mail Cost
$1,500
Less: Online Marketing Cost
$3,550
Less: Pick, Pack, Ship 11.5% $4,871
Variable Operating Profit
$5,271
Profit as a % of Net Sales
12.4%

February 02, 2007

J.C. Penney CEO, Web 2.0, And Multichannel Forensics

DMNews reports that "multichannel" is the key theme at Shop.org's FirstLook show.

Of interest is the comment from J.C. Penney Chairman/CEO Mike Ullman, who says of direct marketing, "We see the three channels getting more and more blurred. The big book is becoming less important, because the big book is online."

Small businesses and growing businesses need catalogs, because the print version of advertising is still the most cost-effective way to grow a direct-to-consumer business.

However, large businesses like J.C. Penney are going through two dramatic transformations that we all need to keep an eye on.

The first transformation is the death of the telephone/paper relationship, being replaced by e-commerce. This has been happening in earnest since about 1999. J.C. Penney's direct business transitioned this year to more than fifty percent online. Once the online channel is more than fifty percent of the direct business, CFO's become very curious about all those dollars being spent on paper.

The first transformation (telephone/paper to e-commerce) impacted catalogers the most.

The second transformation is just beginning to happen, and may change our businesses far more than e-commerce. The second transformation is the shift in the online channel from e-commerce to experience.

The second transformation (e-commerce to experience) will impact retailers and online pureplays the most. Just because we can purchase merchandise online doesn't mean we want to purchase merchandise online. Retailers who can, in some way, re-create the in-store experience, or significantly complement the in-store experience in a virtual world, will have a huge advantage over online pureplays and online/catalog businesses, who do not have an experience-based channel to please customers with.

The recent bare-knuckled, bloody fist fight between Endless.com and Zappos.com illustrates the desperation online pureplays are feeling. As the second transformation (e-commerce to experience) integrates with the retail experience, businesses like Zappos compete the only logical way they can --- by offering free shipping. Endless trumps Zappos by offering free next-day shipping. Zappos matches Endless, then, Endless trumps Zappos by offering free next-day shipping along with a five dollar rebate.

Websites were constructed to be static, read-only experiences. We built a ton of infrastructure to make e-commerce possible. Over the next decade, this read-only experience will likely be replaced by an experience-based channel. Web 2.0, blogs, wikis, YouTube et.al are the embryonic representation of this transformation.

This is really going to be fun to watch!

This transformation really requires the implementation of multichannel forensics. All businesses with a website must have intimate knowledge of how their customers interact with products, brands and channels.

February 01, 2007

Customer Service: Do You Pull An Item Off The Website If It Is Sold Out?

The esteemed Becky Carroll at Customers Rock! describes an experience she had at Coldwater Creek.

An element of her discussion is interesting to me. What you do with online items that are sold out? In Becky's case, she clicked on sale items, only to be told that the item was not available. Other items were placed in her shopping cart, only to later disappear, because they were also sold out.

Becky describes a common problem in multichannel retailing. What she experienced, as a customer, is not optimal.

Now let's put yourself in the place of an employee at Coldwater Creek. You purchase 10,000 units of this dress. You publish the item in a catalog, you pay Google additional money for the keyword "Dresses", and oh oh, sales go crazy. Within a week, you sell out of most of the skus.

If you pull the item down from the website, you won't know how many units you 'could' have sold. Keeping the item online allows you to count the fact that you might have sold 19,000 units. Next year, you have a much better idea about how many items you need to purchase. For this reason, many employees at multichannel retailers want to keep recording the 'demand' for these items.

So --- my question for you, the loyal reader, is this: Do you disappoint 9,000 customers like Becky by leaving items online when they are sold out, or do you give Becky a better shopping experience today, but fail to purchase enough items for next year (or purchase too many), disappointing next year's customers and hurting next year's profit and loss statement? If your job security is based on correctly forecasting the right number of units, you'll want to keep those items online, so you can correct your error from this year.

I don't think there is a right or wrong answer. I do want to hear your thoughts, because it is a dilly of a pickle.

By the way, if you want a thankless job, go work for a multichannel retailer as an inventory manager. It's not a lot of fun to be wrong every single time you forecast sales.

An Answer: Measuring Advertising Effectiveness

Back in November, I issued a challenge to the analytical multichannel community. Given a dataset with four independent marketing activities, mostly targeted to the same set of customers, measure the incremental sales that each marketing activity drove to the catalog and online channels.

This challenge is important, because executives at many companies have asked me if I have a solution to this problem. Many vendors provide solutions to these problems. However, the problem should be able to be solved without somebody having to spend $75,000 for a solution. The good folks at KDNuggets posted the challenge, which I am appreciative of.

I did forward the challenge to all of the major vendors in the multichannel analytics industry. The folks at Abacus were kind enough to have a brief dialogue, and promised to attempt to solve the problem if there were enough internal resources available.

Free advertising and thought leadership was at stake for these businesses. Sadly, I did not receive one response from folks at SAS, SPSS, Abacus, Experian, Acxiom, Merkle, KnowledgeBase, Unica, or others.

More than five hundred individuals downloaded the dataset. I received several solutions. One solution passed the test.

The solution was provided by an individual named Grigorios Tsoumakas. His solution is elegant, simple, and directionally correct. His solution is outlined below. Kudos to Grigorios for finding an exceptionally simple solution!!


Solution:

For the organic sales we consider the sum of sales for which no advertising tactic was used. Then for each advertising tactic we calculate the sum of sales when no other advertising tactic is used. The exception to this rule is the email2 tactic, which has a temporal relation with the email1 tactic, i.e. it follows email1. For the email2 tactic we calculate the sum of sales when both email1 and email2 tactics are used. This will give us an initial estimate of the sales related to a single tactic.

Then we consider pairs of tactics (apart from the email1, email2 pair). We divide the sum of sales for every pair of tactics to the two tactics that comprise this pair, based on the initial estimates of sales. For example if a tactic A had initial estimate sumA1 and tactic B had initial estimate sumB1, then we divide the sum of sales for the pair of tactics A,B sumAB as follows:

sumA2 = (sumA1/(sumA1 + sumB1)) *sumAB and


sumB2 = (sumB1/(sumA1 + sumB1))*sumAB.

We continue by considering triplets of tactics and again we divide the sum for a triple according to the initial estimates as before.

Finally we distributed the sales for all tactics again according to the initial estimates.

The resulting table is as follows:


Final Results Of The Advertising Challenge






Telephone Online Total

Sales Sales Sales
Driven By The Catalog $57,843 $44,524 $102,366
Driven By The Postcard $1,221 $18,229 $19,451
Driven By The 1st E-Mail $0 $5,350 $5,350
Driven By The 2nd E-Mail $0 $2,400 $2,400
Sales That Happened Organically $244 $1,778 $2,023
Grand Totals $59,308 $72,282 $131,590

An Ecommerce Brand Is Constantly Reinventing Itself

A year or two ago I received an email ... the Leader asked "what happened to all of those COVID customers, it's like they just disa...