NEWS: Percocet Compare prices tramadol Effects of long term xanax use Motrin: Lomefloxacin Viagra xenical Klonopin versus xanax Cialis levitra viagra compare 10 min viagra Buying phentermine without prescription Flucytosine Spironolactone! Didrex vs phentermine Compare viagra cialis levitra Phentermine prescriptions online Ethinyl Naprosyn Vicodin online Decamethonium Cosopt Xanax online pharmacy Phentermine order Proguanil Cheap phentermine with online consultation Buy no online prescription xanax Prinivil, Plavix Viagra versus levivia Does xanax show up on drug tests How fast can you loss weight with phentermine Buy cialis viagra Buy xanax, Effects long side term xanax Hydrocodone Glipizide Non prescription phentermine Celebrex Cyclophosphamide: Phentermine cash on delivery Perindopril Methylergonovine Phentermine pills Reliable same or next day phentermine purchase online Phentermine 37 5mg How long does viagra last Viagra lawsuits Azatadine Mepenzolate Cheapest phentermine online no prescription Perphenazine Phentermine eprescriptions Viagra overnight shipping? Buy phentermine diet pill Free sample prescription for viagra Xanax abuse What does phentermine look like, Clomiphene Podophyllum. Compare viagra prices How does viagra work, Xanax libido Hydroxyurea Reserpine Phentermine drug! Phentermine fact Flavoxate Diflucan Phentermine 6 pm order Online pharmacy tramadol 1 loss phentermine pill weight: Phentermine from canada Information phentermine Oxycontin Hydrocodone dosage. Felodipine Buy viagra now: 2 mg xanax Propafenone Birth defects and phentermine use Levivia viagra online: Cialis discount online 50 mg tramadol Viagra testimonials Addicted to xanax. How long between phentermine and meridia Alesse Pioglitazone Generic viagra overnight delivery Hytrin Online pharmacy viagra Amaryl Urine drug testing of tramadol Where to buy phentermine Next day phentermine: Loracarbef Lawsuits involving blindness caused by viagra? Dicumarol Phentermine xenical Phentermine with no prior prescription Citalopram Phentermine prescription diet pill Piperacillin, Sinemet Arimidex Seroquel Phentermine from mexico Phenylbutazone Cheap phentermine online withour prescription Free ambien Cheap viagra order online Viagra and pulmonary hypertension Zuclopenthixol! How does viagra work Diatrizoate Free cialis Buy hydrocodone overnight Cod delivered phentermine Viagra cialis levivia comparison dosages Cinnarizine Plicamycin Online pharmacy xanax Sophia viagra. Phentermine message boards Viagra without a perscription Sell viagra online Urokinase Donepezil Phentermine forum. Vicodin addiction Phentermine hydrochloride ship to missouri Xanax effect Maker of viagra Isotretinoin Phentermine no perscription needed Cheapest generic viagra Viagra on line Glycopyrrolate Labetalol Anafranil Norvasc Phentermine buy online Rizatriptan Butorphanol Cialis compare levivia viagra 5 no prescription Phentermine 30 mg ordered with discover card! Phentermine prescription online Viagra female sexual inhancement Cheapest prescription viagra Herbal alternative to viagra Phentermine blue Phentermine Symptom tramadol withdrawal Adipex phentermine pill Viagra testimonial Fastin phentermine, Capoten Order xanax Echothiophate Fluvastatin Ranitidine Cialis eli lilly Zuclopenthixol Digitalis Discount fioricet Generic cialis india Apcalis cialis Discount phentermine Viagra cialis generic Prednisolone Phentermine drug Xanax 2mg Women viagra Phentermine pillstore? Prinivil Femara Imodium Norethindrone: Viagra cream for woman Tramadol without a prescription Phenytoin interaction with xanax Rimantadine Order phentermine phentermine online Dianabol Buy phentermine online with paypal Fluvoxamine, Cheap phentermine prescription Phentermine diet Cialis immunity Celecoxib: On line pharmacy phentermine Phentermine 37 5mg shipped to kentucky! Linkdomain buy online viagra info domain buy onlin Nafcillin Hydrocodone bitartrate acetaminophen Phentermine yellow. Pyrazinamide Compare phentermine price? Tramadol without perscription Buy meridia online! Picture of soma Viagra anxiety Xanax no prescription Viagra online order guide? Adipex loss phentermine weight Famvir Buy viagra canada Phentermine diet drug Filing income tax tramadol Cialis levivia sales viagra Free cialis samples Buy cheap cialis Natural supplement for viagra Phendimetrazine versus phentermine Femara Oxyphenbutazone Actos phentermine aciphex imitrex Effects of snorting xanax Anisindione Phentermine side effects dangers Phentermine low prices Buy cheapest online place viagra Cheapest viagra uk Cialis sales uk: Altace Digoxin Biaxin 30mg phentermine yellow Phentermine online without prescription Ceftizoxime Cheap quality viagra Moricizine! Lethal dosage of xanax Female viagra Glucophage Methscopolamine Discount vicodin No prescription needed phentermine Phentermine vs phentrazine Hydrocodone withdrawal symptom Viagra cialis levivia comparison Avapro 99 phentermine Lowest phentermine Cod xanax Phentermine free prescription, Flexeril Isometheptene! How to inject xanax pills Viagra faq: Cocaine Buy vicodin without prescription Mark martin viagra Lowest drug price for phentermine Vicodin overdose Phentermine perscription Cheap phentermine online no prescription Free overnight phentermine shipping Lisinopril drug interaction viagra Viagra samples Overnight viagra Is phentermine safe Acetophenazine Pink oval pill 17 xanax identification Cialis online Guanfacine Mometasone Pfizer viagra online Taking phentermine Permax: Viagra online consultation Purchase xanax Viagra anxiety Does viagra woman work! Soft cialis Black market costa rica pharmacy phentermine no imprint code Ceftazidime 0 buy by popl powered viagra wordpress Nystatin Viagra knock offs Fill online prescription viagra Differin Free try viagra Phentermine free online consultation Canadian cialis Tramadol addiction Buclizine Free sample herbal viagra Buspirone Detox hgh phentermine quit smoking xenical! Cheapest phentermine online free shipping Ash of soma Viagra from canada Catapres Buy viagra online get prescription Imitrex Thyroglobulin Free trial viagra Phentermine dosage Buy phentermine cheap, Valerian Iothalamate, Free sample prescription for viagra Doxylamine, Tramadol drug interactions Buy free phentermine shipping Mannitol Compare generic viagra prices No prior perscription tramadol Viagra suppliers in the uk Buy in online uk viagra Buy phentermine online Cholestyramine Phentermine diet plan Phentermine 30 mg ordered with discover card Naproxen What is xanax Levivia compared to viagra Order cheap phentermine Metoprolol Phentermine delivered overnight Phentermine no prescription needed Link myblogde online order viagra Vicodin picture Isoxsuprine Cheap viagra online prescription Phentermine adipex Cytotec Tetrabenazine Ritodrine? Cialis ineffective Atacand Add a link viagra 37 effects phentermine side Cialis experiences Probenecid Flunitrazepam Fluconazole Lansoprazole Ambien sleep aid Vicodin online Viagra conviaindications? Adipex phentermine Pay pal phentermine. Encare Asparaginase Generic cialis india Xanax online pharmacy no prescription Phentermine 90 Online viagra prescriptions Dienestrol Didrex vs phentermine Hydrocortisone Generic viagra cialis levivia buy cheap Genaric viagra Erection viagra Free viagra trial Cheapest cialis generic: Phentermine forums Cheep phentermine with cod payments Hydrocodone vicodin Cheep phentermine Phentermine priority mail Cheapest phentermine free shipping Nylidrin Phentermine without rx. Trimethoprim Fluorescein Xanax ambien Heparin Etoposide Zalcitabine Arimidex Micronase Xanax depression Orphenadrine: Saturday delivery cheapest phentermine Side effects from prozac and xanax? Viagra wholesale Uk viagra sales. Information viagra woman Phenylbutazone. Chep phentermine Ethambutol! Naloxone How to get a xanax prescription Luvox Phentermine pharmacy online consultation Order phentermine by for saturday delivery Elocon! Grapefruit viagra Phentermine ingredients Viagra for women Compare levivia and viagra Levivia compared to viagra Phentermine and ocular hypertension. Tomorrow Interstitial cystitis+xanax Is klonopin stronger than xanax Tramadol sales. Purchase tramadol Xanax prescriptions online Ionamin No prescription cialis: Multivitamins Buy cialis online? Aldactone Cheep tramadol paris france: Good morning viagra commercial Piperacetazine Xanax gg 258 Ethynodiol Caffeine Cheap prescription viagra Buy phentermine in canada Amide pharmaceutical phentermine Cheaper viagra levivia cyalis 5 cash on delivery Phentermine no perscription required Fosamax Acetylcholine Meridia Lypressin Buy online viagra viagra. Nisoldipine Doxycycline Xanax pictures Niaspan! Where to buy xanax Nexium Cialis experience Diet online phentermine pill. Xanax withdrawls Premarin: Approval cialis Phentermine without prescription and energy pill Xanax urine test Mazindol. Cordarone Pemoline Viagra compared to levivia Noroxin Drug screening phentermine Paroxetine Viagra pill splitter Viagra 100 mg Troleandomycin Fioricet info, Viagra online order guide Coumadin! Feldene Vicodin withdrawal symptom Cipro Soma pill Furosemide Buy ambien Prazosin Hexocyclium I need to find cheap phentermine delivered to fl Natural viagra alternatives? Amsterdam holland viagra Monopril! Tessalon Side effects phentermine gynecomastia, Propafenone Streptomycin: Fentanyl Phentermine free shipping 90 supply no delay Coumadin Buy online salescom viagra Phentermine side effects dangers Buy viagra in uk No prescription phentermine free shipping Colesevelam Cheap phentermine free consult Phentermine pill: Phentermine medical insert Uk online pharmacy phentermine Triamcinolone Adipex phentermine weight loss! Cialis Cosopt Alka seltzer Primidone Cialis vs viagra Pyridostigmine Sotalol Sotalol Discount cialis online Ambien and pregnancy Addiction recovery xanax Alesse Zocor Heroin Combivent Cialis comparison levitra viagra 3mg xanax Daunorubicin: Droperidol Phenyltoloxamine Flomax Phencyclidine Information on phentermine Women viagra Leflunomide Luvox and xanax Ambien addiction Phenytoin Interferon Meridia diet! Dextroamphetamine Generic cialis softtabs Alprazolam xanax Meridia weight loss Herbal online viagra Buy viagra pill online Pyrimethamine Prevacid Xanax online cheap Phentermine free delivery Buy meridia online Calcifediol Dovonex Information about viagra 5 mg Low cost phentermine health insurance lead Dovonex Mirena Zyrtec Indinavir Cefotetan Comparison viagra cialis levivia Methocarbamol Oxyphencyclimine Phentermine complications Lexapro Female viagra Non perscription generic cialis! Phentermine pill online discount Prescription soma Ingredient phentermine Maprotiline Alternative to viagra Overnight shipping viagra. Black market costa rica pharmacy phentermine no imprint code Thyroid Bentyl Detection drug in phentermine screen urine Hexoprenaline Chlorpromazine Viagra cialis Cephalothin, Generic viagra pill Between difference levivia viagra! Cialis compare levitra viagra Herbal alternative viagra Dopamine Effects of long term xanax use, Is viagra safe for women Long term side effects from xanax Buy phentermine online no prescription Amiodarone! Codeine Phentermine pictures: Soma carisoprodol Mixing viagra and cialis Cialis soft tabs Phentermine online prescriptions Fenoterol Xanax withdrawls Dilantin Viagra and ischemic optic neuropathy: Glucotrol Pheniramine: Generic viagra overnight delivery Pravastatin Ups cod phentermine Is tramadol a narcotic Dulcolax Liquid hydrocodone Atacand Lowest price for phentermine? How long does xanax stay in your body Ionamin phentermine yellow! Clozapine Buy generic xanax 90 cod count day phentermine Buy locally viagra Viagra paypal france Yohimbe and viagra Buy hydrocodone where Xanax info Cialis new viagra No perscription generic viagra, Xenical hgh phentermine quit smoking detox Cheap perscription phentermine Buy cialis soft tabs Actonel 50 mg viagra Tramadol use? Nifedipine Iodoxamate Side effects from prozac and xanax Ecotrin? Hydrocodone ap ap Natural alternative viagra Generic viagra no perscription needed Comparisons on online viagra suppliers About phentermine Non perscription viagra Norgestrel Cause rebound weight gain phentermine! Hyzaar Ethisterone Chlorpheniramine Acarbose Phentermine online cod Adalat. Buy cheap phentermine cod Best price viagra Free viagra order online Avandamet, Meridia better than phentermine Levivia viagra vs, Does phentermine speed up metabolism Phentermine chemical enhancement Ionamin phentermine Vicodin information Viagra tablets Discount priced viagra Order xanax online Fioricet line Epivir Cheapest tramadol: Free phentermine Phentermine in stock ready to ship saturday delivery: Buy vicodin online Phentermine result Tricor Buy cialis generic Fluorescein Trileptal Cefepime Buy viagra on line Phenergan Indocin Ecstasy How much xanax is a lethal dose Buying viagra in the uk Cheapest xanax: Berman sister female viagra study Diet pill phentermine Xanax withdrawel Vitamin b12 1000 mcg phentermine and panic attacks Generic viagra cialis Nelfinavir Filling online prescription viagra Low dose of viagra Buy cod online phentermine Cialis impotence drug eli lilly co Xanax uses Buy phentermine online cod Phentermine works Generic soma Pemoline Berman sister female viagra study Vicodin dosage Anafranil Argento soma Encainide Ansaid Cheapest place buy viagra online, Dog xanax Hydrocodone ap ap Avelox Best cialis price Crohns phentermine Phentermine and carbs Metoprolol Long term effects of xanax Woman use viagra Carvedilol Ceclor Viagra Omnicef Tramadol ingredients Cialis comparison levitra Buy online securely viagra Appetite suppressants equivelant to phentermine Hydrocodone withdrawal Chloroquine Pyridium Ambien prescription Viagra uk. Somatostatin Carbachol Soft tab viagra Keflex Tramadol hcl acetaminotran par Cheap diet phentermine pill Viagra useage Online phentermine order: Ibutilide Chep phentermine, Dextrothyroxine Buy vicodin. Viagra canada Generic xanax 2mg. Free sample viagra Phentermine free consultation Rabeprazole Phentermine: Simvastatin Loperamide: Vitamin b12 1000 mcg phentermine and panic attacks Methantheline Alprazolam Phentermine works Naltrexone Hydroxychloroquine Review of herbal phentermine Hytrin 25 mg viagra Mycostatin! Nialamide Methazolamide Phentermine sales online Venlafaxine Pulmonary hypertension and viagra Foradil Phentermine cheapest Ramipril How much xanax is a lethal dose Cialis drug, Tolazamide Viagra without a prescription Cialis comparison levivia viagra Herbal viagra alternative Cialis sales uk Free pack sample viagra? Heparin Phentermine incrediants Congress viagra Phentermine weight loss medication! Free sample herbal viagra Phentermine cheap no prescription Phentermine pharmacy online consultation Nystatin Nitroprusside Benadryl Cialis reviews Generic viagra in canada Butalbital fioricet Free shipping cheap phentermine Viagra vs levivia Filing income tax tramadol! Opipramol Alphaprodine Viagra pulmonary hypertension Ups cod phentermine Letrozole Viagra generic drug Cheapest diet phentermine pill Clemastine Phentermine dangers Felodipine? Guaifenesin Lowest price phentermine with free shipping Phenyltoloxamine Free generic viagra Indocin Phenazocine Meridia diet pill Micronase! First viagra commercial network tv Cheap phentermine cod Viagra prescription medication Ambien prescription? Overnight shipping viagra Soma san diego Ephedrine Herbal viagra uk Pfizer viagra Buy online phentermine shipping! Doctor phentermine raleigh Botox. Natural over counter just like viagra stores Viagra energy drink Lexapro Hydrocodone bitartrate! Trimeprazine Restless leg syndrome phentermine? Cheapest price viagra Oxycontin xanax bars perclesept and lortab, Discount phentermine prescription Viagra cialis comparison Generic lowest price viagra Geodon, Aciphex Order soma carisoprodol Compare levivia and viagra Delivery florida online pharmacy phentermine Propylthiouracil Cyclopenthiazide Ethchlorvynol How much weight will you lose on phentermine Losartan Tramadol dog, Cialis levitra sales viagra Insulin 100 mg viagra Levorphanol Phentermine pharmacy Lipids Liver problems from xanax Drug test tramadol. Ketorolac Bacampicillin, Colace Aricept? Atropine Womans viagra: Tyropanoate Method of payment accepted cod phentermine! Tramadol active ingredient Nortriptyline Amiloride Order generic viagra Viagra commercials Cheap tramadol no prescription Ansaid Lynestrenol Corticotropin Phentermine 30mg cap: Soma pill Phentermine sales Niacin Phentermine pill town, Cheap soma Lowest price viagra! Order viagra Medical information on tramadol hc: Buying viagra online Acetazolamide Akane soma Information viagra? Flavoxate Lozol Effects of phentermine On line prescription viagra Non perscription generic viagra Oxybutynin Soma financial Viagra results Meclizine Loratadine Free viagra without a perscription Discount drug phentermine? Generic viagra cialis levitra buy cheap Nalorphine? Tramadol and drug tests Phentermine success No online prescription xanax Cytomel. Viagra patent expiration Phentermine mastercard: Ambien 10mg Atenolol Natural alternatives to viagra Permethrin Molindone Tramadol apap Xanax bar Generic ambien. Tramadol abuse Online adipex phentermine prescriptions Phentermine prescribed online Advair Cimetidine Niacin. Aldara Apomorphine Physican's desk reference phentermine Ambien cr effects side Viagra online pharmacy Olanzapine Atropine Vicodin Buy viagra Cheap viagra canada

March 26, 2008

All Reviews Are Not Created Equal

A few weeks ago, Shantanu wrote on recommendation engines and how user feedback and ratings can be a part of recommendations you provide to your customers.  But if you have ever looked through user recommendations while shopping online for a product, stock, or movie, you know that they aren’t all helpful.  Ideally, user ratings would accurately represent the population, but not all feedback is created equal, and there are some inherent challenges in these systems:

  1. Not everyone will rate.  People may read the ratings when shopping for an item, but they won’t always come back to rate.  Unless a site offers an incentive for rating a product, a customer’s only real incentive for doing so is to talk about how much they love or hate it; moderates may be under-represented.
  2. Ratings will be biased.  People’s individual biases produce variances in ratings, even if strict guidelines (think about employee performance reviews) are presented.  In addition, new raters tend to rate high.  Their average ratings decrease over time as they rate more items, presumably because they are exposed to more items and have a better sense of an item’s value relative to alternatives.
  3. Ratings are averaged, masking the underlying data.  Because people often only rate items they feel strongly about (love it or hate it), and an average of those extreme ratings may not truly represent the actual sentiment surrounding a product.  For example, a review of rankings on Amazon.com revealed that “the reviews for the majority of the products have an asymmetric bimodal distribution. For these products, the mean of the online product reviews does not necessarily reveal the product’s true quality, resulting in misleading conclusions about the product’s future success.”  In addition, established products are at a disadvantage against new ones.  Consider a product that has received five rankings, four “5s” and one “4,” giving it an average rating of 4.8. If a new product enters the space and receives one “5” rating, it will be ranked higher than the other simply because it has fewer ratings. 
  4. Ratings may be false.  Take the case of the Whole Foods CEO who posted disparaging comments about a competitor on a message board while talking up his own company, later stating “Sometimes I simply played ‘devil’s advocate’ for the sheer fun of arguing.”  Other visitors may post false comments to artificially affect the rating, and these are not always removed from the calculation.

As more products are marketed and sold online, feedback-based ranking systems are increasingly common components.  Amazon and eBay were among the first to use visitor ratings to rank products and sellers, and in February, Yahoo launched its Buzz service, which asks readers to click on their favorite stories, then uses those ratings to determine the most popular articles on the web.

Why is this important?  Because accurate product ratings help predict that product’s success, and higher product ratings lead to more sales – or, as Allen & Appelcline state, “the value of individual items (most frequently goods) rise or fall based upon the largely subjective judgment of individual users.”  So what can you do to ensure the rating system on your own website accurately reflects your customers’ views and the value of your product?

We’ve seen some thought around using analytical techniques and Bayesian mathematics to create better product rankings.  Some of the solutions explored include:

  1. Adjusting ratings based on known biases.  Since some people rate higher or lower than others, one approach is to assign users a “User Optimism” value based on their rating history, and adjust the product’s overall rating based on the raters’ optimism value.  Another approach is to remove all ratings from people who have only rated 1 or 2 items, helping to eliminate new-rater optimism or “drive-by” fraud.
  2. Weighting a product’s ratings based on the number of ratings received.  When a product has a small number of ratings, these ratings should count less than those for a product rated many times.  To achieve this, you can add a “magic value” into the algorithm that calculates a product’s average ratings.  This “magic value” brings products with few ratings closer to the average ratings of all products, then reduces its effect as more ratings are received, allowing established products’ ratings to float freely and more closely reflect the average of its ratings.
  3. Adjusting the algorithm to account for bimodal distributions.  To account for products that only have ratings at the extremes, one approach is to use a dual-point estimation model to more accurately reflect customers’ views of the product and predict the product’s success.
  4. Analyzing a customer’s rating history for fraud.  Someone who rates several products on your site should have a predictable rating pattern.  You can analyze individual customers’ accounts to identify and remove anomalies that might skew product ratings.
  5. Encouraging customers to leave text-based feedback.  When a person takes the time to write out a product review, and knows that her name will be attached to it, she generally does a better job in her rating.  These reviews tend to be closer to the average than those without.

Although your customers’ product ratings may be imperfect, they can still yield insights and value with the application of a good set of analytical techniques.

March 24, 2008

The Real Customer Life Time Value

Some recent academic literature has shown that companies using the standard Net Present Value (NPV) approach to calculate Customer Lifetime Value (CLV) and allocating their marketing spending might be losing substantial profits.

The standard CLV approach calculates the net present value (NPV) of all the anticipated cash flows coming in (revenues) and going out (expenses) over the projected life time for a given customer. Customers with a positive NPV are aggressively marketed and the ones which do not have a positive NPV are dropped. This is a pretty logical choice at the point of calculation- but only then. The existing conventional structure of calculating CLV is static and has the potential to leave money on the table for the company; because it does not account for the fact the company has the flexibility of abandoning a customer at any future point in time. Flexibility means options and options have a value.  The paper lays down a methodology (based on dynamic programming) to explicitly estimate the value of such options in the CLV calculation.

The authors of the paper cite the example of a specialty catalog company. They took data of 12 years and around 100,000 customers, and the difference in CLV using the traditional versus real options was as much as 20% in some cases. In fact, certain customers who had negative CLV’s turned positive when the value of real options was considered.

Retailers, communication companies and consumer finance companies who frequently use CLV as a decision making metric, are strongly recommended to read this paper.

February 21, 2008

Marketing Whitepaper Packet

A set of whitepapers for the executive who wants to leverage the data to make smart marketing investments:

  1. Identifying attractive markets and understanding your customers
  2. Increasing online sales
  3. Focusing on profitable distribution partners
  4. Improve customer experience through call center data
  5. Retaining your customers

November 6, 2007

Perception and Reality of Wait Times

Filed under: Customer Service, Process Analytics — Shantanu @ 11:55 am

Customers calling call centers don’t want long waits and often perceive them as longer than actual.

At the Intelligent Transportation Systems Lab of the University of Minnesota, an experiment was designed where highway driving conditions were simulated in a lab (a Saturn was peeled off and a 270 degree screen in front provided the video). It showed how people value time under different situations. While almost all the respondents remarked that they had actually ‘driven’ for a shorter time than the actual simulation, they also noted that they had waited on the ramp before entering the freeway for 30 seconds or more when the actual controlled waits ranged between 5 and 12 seconds.

A vital component of interaction between customers and service professionals is the time it takes to respond to the customer’s needs and requests or more importantly, the perception of such service times. Adaptive queuing theories can play an important role in improving perceptions of customer service. It is non-ideal to keep a customer waiting for a long time when their needs are fairly straightforward. And in such cases they value their waiting time even more than they actually waited for, in some cases, many times more. While such experiences may be fairly commonplace and their pain all too well-known, businesses, save for exceptions, rarely apply adaptive queuing theories to correctly predict and plan for servicing an individual. Disney engages customers in distractions while they wait for 45 minutes in a queue for a 3 minute ride. Situational elements like music, lighting, color, employee visibility, social interactions, visible queue movement, number of counters serving vs. idle, a visible clock nearby all influence perceived time. Companies can benefit by putting more thought into the psychological aspects of waiting times and queuing while trying to increase service levels and influence customer satisfaction.

July 9, 2007

Firing Customers

Filed under: Customer Service, Analytics, Churn — Amaresh @ 1:44 pm

Firing customers is not something companies prefer to do for profitability. Fierce wireless reports that Sprint recently fired some customers because of their frequent calls to customer care.

Ever wonder how many calls to care can actually get one fired from the wireless company, now that the precedent has been set? We did some back of the envelope analysis to understand it better.

Assuming that the fired customer paid an average bill of $60 per month and that Sprint has 30% margin and average cost per call of $4, it will take 5 calls in a month to make one a negative value customer. However the trick of all lifetime value calculations is to estimate future value of customers because you can be unprofitable in one month but go on to upgrade to a highest plan down the road. Since there is no reliable way to predict it, we will be conservative giving the benefit of the doubt to the customer. So to get fired, the customers must be making way more than 5 calls a month (probably more than 10-15) and that too for a few consecutive months; so that Sprint had no hope of making a profit in future from these customers.

While it is certainly a sound financial decision, it will be useful to determine whether these customers had anything in common (type of problem they were calling for, expectation setting at sales channel etc.) which led them to call more often.

146869171_b4e4b9a014.jpg

Photo Credit: Pappalicious

April 12, 2007

Targeting (Right-, -Right, and Re-)

In any customer facing business, the channels used to reach out to your customer as well as the channels your customer use to consume your products and services have a strong correlation with overall profitability. 

From the B2C perspective, advertisements, stores, online, mailers, charity, etc. are different ways of reminding customers about your offerings. From a C2B perspective, again, stores, online, home delivery orders, etc. are ways in which consumers consume your products. 

However, the key here is to understand which customer prefers which B2C and which C2B channel. Right-Targeting Customers is as important as Targeting Right Customers! Someone who spends 14 hours a day in front of his computer and has no time to go to a store 5 days a week may prefer a home delivery channel. On the other hand, a student in a college is only interested in the bargain channel, irrespective of the inconveniences, maybe. This report also mentions how retailers need to manage their investments across channel against the scale and timing of their expected return. I would go beyond Ron’s Right Channeling [read post] to include all aspects of targeting under the concept of Right-Targeting. Having said that, I agree that today’s world is about multi-channel customers, and the need of the hour is to optimize channel returns, rather than just channel re-alignment/phase-out. 

Targeting Right Customers-
Its equally important is to understand how channel profitability gets affected if you are not targeting the right customer. For instance, Wal-Mart, even with its Everyday Low Prices (EDLP), must be making money on some products/ some SKUs and these would drive the overall positive profitability. However, what if your customers are not buying your profitable SKUs? What if the draw that brings them there is not luring them to buy more? What if there is no up sell/cross-sell/bundling that happens there? And suddenly the business realizes that channel profitability is coming under immense pressure! (One of our earlier posts tries to answer the question of market basket analysis and product bundling). 

Re-Targeting - And last but not the least– taking the difficult decision of phasing a channel out. If it’s not generating any returns (directly or indirectly), the business needs to reconsider the cost of the channel. But what about retaining those customers who are loyal to the channel and have helped you get some mileage out of it? They need to be Re-targeted with a new offering/communication. Traditional retargeting refers to targeting customers who did not convert the last time, though!

This report (PDF) here talks about issues to be kept in mind when moving customers from one channel to another. I am sure Kevin would want to talk about Multi-channel customers being better than single channel customers, and without refuting his argument I would classify my argument as being restricted to customers that are being phased out of a channel. This example demonstrates one case where the retailer has effectively leveraged multiple channels over a period of time by effective use of catalogs and internet channel. 

In Summary

  • Right Targeting – Know your customer. Cater to their needs through their preferred channel. It increases the share of wallet, as well as longevity of the customer
  • Targeting Right – Pick your customers for each channel-product combination well. Know what and how you are selling and who will buy it.
  • Re-Targeting – If it’s imperative that you move away from a particular channel, think about retaining your loyal channel customers. A little caring goes a long way in creating customer loyalty.

The qualifying argument behind all this is that if you are thinking about channel optimization, it needs to be a more concerted discussion based on your strategy/business objective, your data, your needs and your concerns. What we know for sure is that strong data analytics is known to help not only Targeting Right (which is the most common application), but Right Targeting, as well as Re-Targeting.

March 9, 2007

Power of Agent Level Reporting

Filed under: Customer Service, Analytics, Reporting — Alex @ 10:51 am

Our client was losing revenue from 68% of potential customers who were sold the service by the call center channel but did not complete registration process, which meant that they could not be billed.

One of the initial analysis we did was plotted the percentage of ‘sold but not active’ customers against the number service agents and found that a small number of the agents were disproportionately responsible for making the sales.

agent level 0.bmp

This led us to investigate the efficacy of the sales process itself and whether some agents were abusing the system for commissions. To answer the former, we did a customer survey while for the latter we started generating an agent-level report on a weekly basis. The report was able to identify the precise subset of agents who were trying to game the system and our client was able to take corrective action.

agent level 1.bmp

As the example illustrates, agent-level reporting is a very actionable tool and can be used for:

Metric Tracking:
Strategic metrics like efficacy of saves, sales quality etc. should be tracked at an agent level

Auditing:
For companies outsourcing a large portion of their call center operations, such a report can serve as an auditing tool

Compensation design and reporting:
It also can help to design and report a performance based incentive structure for agents

February 5, 2007

One Size Does Not Fit All

After porting my wireless number to one of the GSM cell-phone carriers, I called the customer care to activate my international roaming for my trip to India. It was a 40 minute long call, and the customer care agent explained that since I had been a customer for less than 90 days, he would need his manager’s approval to activate the service which would take up to 5 business days. When I landed at the Mumbai airport, the service had not been activated and 10 days later it is still the case.

The carrier not only lost potential revenue, incurred cost of a long care call but also caused customer dissatisfaction.

Is there any way for companies to avoid such one size fits all rules trap?

One potential way is to use predictive analytics to design the operational rules and automate front line decisions, to increase both revenue and satisfaction.

December 14, 2006

Linking Process Inefficiencies to Call Volumes

Expensive calls to customer care can be avoided by better managing core business processes. Most service providers are concerned with non-value added call volumes because they represent a significant cost to the business and offer little true opportunity for incremental sales. Often non-value added calls are triggered by problems or inefficiencies throughout complex operating environments, for example in claims processing. In our work we have found a stunning relationship between the “days to pay” intervals at several different types of insurance companies. As the chart below demonstrates, the probability of a claim generating a call to customer service increases dramatically as the claim ages. In this case claims that age beyond 40 days are basically guaranteed to generate at least one call, thus driving up costs needlessly.

claims.PNG

So what? In this case, the company was tracking average claims “days of mail on hand” and believed that there were roughly four or five days of claims inventory to be processed. This faulty and misleading metric was well within the early part of the curve, where a call to care is highly unlikely. An accurate aging of the claims inventory revealed that the average payment interval was almost 17 days! This was well beyond historical norms and the operating assumptions that were used to forecast call volumes. By pinpointing the processing areas that had excessive aged inventories (using further detailed analysis of electronic data) we were able to devise a simple plan to reduce pockets of aged claims, put more accurate measures in place, and stanch call volumes.

December 13, 2006

Customer Service 2.0

Filed under: Customer Service, Customer Loyalty, Analytics, Perspective — diamondanalytics @ 9:44 am

Will ‘support tagging’ reverse the customer support model as we know it? As customers start going online to share their views about products and services and research their next purchase, companies have little to identify and understand such large amount of unstructured information online which relates to their products and services, much less to do anything about it.

And that is where the concept of  ‘support tagging’ or ‘beacon’ comes in. There have been recent discussions (1, 2 and 3) on the concept with some suggestions on how the model will work. The basic idea is that organizations will publish and publicize their high level reason code trackers or ‘tags’, they use classify their customer interactions – to be used by customers when writing any blog comment about the company’s products.

  • for example, “office2007question” would have been a good tag the MS could promote with its Office 2007 product
  • support tags, like “support:typepad” or “feature-request:iCal”, case experience tags, like “user-testimonial:nokia+n90″

These tags will make it easier for the company to search for customer feedback/support issues and potentially even address customer issues, right where the problem has been stated. In some ways, it reverses the customer support model, with companies seeking out customer issues and solving them rather than customers following company’s procedures to state their complaints.

A very vital secondary benefit will be getting customer feedback from a market research perspective. ‘Beacons’ will be a good addition to call monitoring and targeted surveys as effective mechanisms to capture customer feedback and link them to company’s rich interaction and transaction databases  (through data analytics) to identify and prioritize opportunities.

Next Page »

Copyright by Diamond

ephedrine trazodone nexium esomeprazole naproxen overdose marijuana buds kenalog spray desloratadine buy augmentin online pharmacy nortriptyline pregnancynorvasc generic benicar buy vardenafil tazorac potency what is adderall klonopin withdrawal symptoms ultracet vs percocetultram combivent inhaler diclofenac potassium what is pravachol buy ultracet effexor withdrawl renova without a perscription buy liquid pepcid nortriptyline side effects valtrex alcohol price of pravachol risedronate sodium tablets flomax side effects metrogel vaginal tramadol medication ortho cyclen naproxen more drug uses tamoxifen side effects butalbital buy phentermine plendil buypravachol generic lotrel naproxen side effects buy biaxin anal abcess and proctocort ghb recipe fluconazole no prescriptionflumadine fioricet effects ultram pharmacy effects of ketamine ultravate substitute without prescriptionvalacyclovir buy imitrex online xanax order diprolene buy buy cheap propecia adderall effects orlistat no prescription fluconazole cheapest price pure mdma xanax on line propecia side effects keflex oral soma for sale india keppra ingredients buy tadalafil where cheap tadalafil tramadol hcl acetaminophen tazorac works miacalcin discussion group selsun shampoo buy hyzaar without prescriptionibuprofen metoprolol side effects terbinafine hcl phendimetrazine diet pills compare cialis levitra viagra buy ultram online actos medication generic pravastatin buspirone altace buy oxycontin withdrawal cheapest tenuateterazosin buy cheap soma order roxicet famvir medication pictures mescaline statistics tadalis tadalafil butorphanol side effects medicine fluconazole proscar 5mg prinivil hair loss tazorac more drug uses augmentin xr protopic treatment fosamax law suits imitrex buy onlineionamin tetracycline without prescription cheap tamiflu social anxiety nardil steroids for sale trazodone hydrochloride cheap medroxyprogesterone online no prescription needed ortho molecular products alesse side effects arava side effects online recepten oxazepam myth of soma purchase propoxyphene how to preven globel warming order rohypnolrosiglitazone zoloft online macrobid more drug side effects online soma meclizine 25mg acyclovir drop buy bactroban provigil discount cards what is prilosec hydrocodone and pregnancyhyzaar purchase phentermine aciphex rabeprazole sodium keppra side effects lasix drug pravachol more drug side effects propecia buy terbinafine no prescription serzone lawsuits biaxin high blood pressure pcp buy buy generic ritalinrohypnol reasons to not use miacalcin viagra online buy methylphenidate imitrex overnight nifedipine oral wellbutrin no prescription thyroid levothroid detrol and relief buy penicillin condylox no prescription buy viagra discount xenical proscar generic atarax 30mg child carisoprodol without a prescription triphasil cost buy risperdal from online pharmacy butalbital discount neurontin alcohol meridia 10mg what is toprol lexapro weight gain ativan overdose tetracycline antibiotic aciphex rebate side effects of ibuprofen generic fioricet elocon serevent lawsuit generic vasotec effects of bontril vicodin withdrawal plendil side effects nexium prescription cheap adipex without a prescription remeron provigil fluconazole overnight delivery on line phentermine diovan paxil stopping cheap hydrocodone nexium generic buy adipex without prescription fluoxetine more drug interactions buy zithromax generic for ultravate discount nexium sertraline drug ativan lorazepam flexeril dosage what is lipitor temovate buy buy tamsulosin trimox presciptionstriphasil no prescription carisoprodol nizoral shampoo tamoxifen citrate soma drug flexeril abuse pravachol generic robaxim and relafen flovent more drug side effects clonidine medication child over dose lisinopril purchase soma online information on steroids skelaxin side effects viagra prescription heroin addict tamsulosin classification starting klonopin suprax antibiotic oxycodone apap buspar dosage propecia finasteride famvir tablet purchase ultram generic lipitor viagra generic order viagra ultravate drug diazepam without a prescription tadalafil coupon alprazolam online fedex order bontril overnight ecstasy mdma cephalexin fluoxetine hydrochloride medical sleep aids temazepam buy generic esgic amaryl purchase buy metrogel onlinemiacalcin lotensin without a prescription buy nexium celexa side effects online pharmacy ambien discount soma mescaline facts protopic side effects roxicet oral solution diethylpropion keppra in pregnancyketamine nexium pills cyclobenzaprine 10mg sarafem side effects buy carisoprodol what is nortriptyline guys on steroids aciphex medication side effects lortab prescription onlinelosartan vasotec oral selsun salon athletes and steroids roxicet side effects urine testing for ghb paroxetine hydrochloride naprosyn alcohol carisoprodol no prescription furosemide side affects seroquel news marijuana pictures metformin and pregnancy what is furosemide definition of steroids lsd doors what is pravastatin flexeril pill alendronate tabs what is ic butalbital cialis without prescription cialis lawyer columbus temovate on penis nifedipine cream cheap propecia cheap klonopin online prescription tramadol cialis generic softtabs folic acid deficiency tadalafil cialis buy zoloft online lamisil tablet buy adipex online without a prescription propecia discount cheap prozac fluoxetine without a prescription hydrocodone prescription adipex weight loss pills prempro trial altace lowest price purchase hydrocodone mexican ambien mescaline drug what is a fioricet long term effects of adderall vicodin abuse pepcid ac oral order propecia online side effects for flomax