Customer Data: Collecting and Utilizing

Big data and data mining are buzzwords that have echoed frequently in the business press during the past three or four  years.   The noise level has caused business leaders to feel obligated to collect data from as many customer interactions as possible.   OK,  that’s very ambitious of them,  but now what? There is a lot of talk about big data and data mining and increasingly there is some action,  but the dust has not yet settled.  Many organizations are struggling with how to interpret,  utilize and store the copious amounts of customer data now in their possession.

Customer information is always useful,  but does data collection have meaning for small businesses and Freelance solopreneurs?  What information should a Freelancer collect and what do we do with it once we have it?  Do big data and data mining have any use for the little people?  The answer is yes,  but no.  Big data and data mining are of most use to the bigger players,  who use the costly to acquire information to fine-tune product offers to millions of current and potential customers.

Freelancers and small business owners can start with their client list.  Who has done business with you over the past five years? Who are your repeat customers?  What do they buy from you and when do they buy it?  If you have not done business with a B2B or B2G client in the past two years,  is your contact still at the organization and is s/he still in the same position? Are B2C physical and email addresses current?  Visit company websites and view the staff lists to confirm email addresses,  telephone numbers and job titles.

Customer data might give you ideas on how to improve customer service,  cause you to re-think your pricing strategy,  or help you to discover unexpected talking points for your next email marketing campaign or monthly newsletter.  Your customer data might prompt you to reconsider good customers of years past and get you thinking about how to win them back.  Updated customer information will make it easy for you to send out holiday cards in December to your B2B and B2G clients and do some relationship-building,  an important element of customer retention.

Online customer surveys that are accessible on your website and also emailed to your customer list have the potential to bring in still more useful customer data.  Learn how to devise a survey that makes it easy for customers to share the information that you want.  Keep the questions simple and don’t ask more than 10 to achieve the highest rate of participation.  Freelancers may also want to send out post-project surveys with the final invoice.

Social media outlets are another excellent source of customer data.  Social media have a way of bringing out uncensored thoughts and you might be surprised by what you learn.  Are your customers willing to engage with you on Facebook,  Instagram,  LinkedIn or Twitter?  Will any join in a Google + Hangout and join in a voice and video live chat?

Collecting data from many touch points is potentially very useful for every business entity,  but what you make of it and do with it are what matters.  Freelancers and small business owners can use customer info to improve revenue by way of expanding billable hours or sales of current customers;  re-establishing business with lapsed customers;  new customer acquisition and relationship-building.  Small data can yield big results when properly interpreted and utilized.

Thanks for reading,

Kim

 

 

The Break-Even Analysis: Find the Pricing Sweet Spot

To continue the topic of pricing,  in this case pricing a new product or service,  it is a must to know when fixed costs will be covered by unit sales at a given price and determine when in time the item or service breaks into profitability.  Performing a break-even analysis will reveal how many units must be sold,  or how many times the workshop must be delivered,  at a given price,  before production costs are behind you.  Integral to that question is unit selling price.  Costs are recouped faster when selling at $100.00 rather than $50.00.  Also related to pricing is what customers expect and agree to pay.  Appropriate pricing can increase profits faster than increasing sales volume.  One can sell fewer items and make more money per item.  Conducting a break-even analysis is Step 1 in locating your ideal price range.  Here’s the Break Even Volume (BEV) formula:

Fixed costs                                                      Fixed costs

BEV     = ______________________________        =         __________

Revenue per unit – Variable cost per unit                         Unit margin

Let’s add some numbers to the formula and assume that the fixed costs associated with delivery of your service is $5, 500.00: $1,700.00 went to the graphic artist for Power Point slides; $1,300.00 paid to the wordsmithing wizard for marketing collaterals used for promoting the service; and $2,500.00 for the wholesale value of your labor,  the time you spent crafting the intangible service.  These costs are fixed because they will not change,  no matter how many times the service will be delivered.  Variable costs associated with service delivery would be printing hand-outs for participants ($50.00) and the advertisement placed in an industry newsletter read by the target audience ($400.00),  meaning that the unit variable cost =$450.00.  If the service is priced at $750.00,  the profit,  or unit margin,  is $300.00 each time the service is delivered at that price.

$5,500.00

BEV     =        _________     =   18.33

$300.00/unit

At a per unit price of $750.00,  the service must be delivered 18+ times before a profit will be made.  From there,  a series of  “what if”  scenarios can be floated.  Chiefly,  what are competitors charging or is there a spike in demand that makes the product more valuable and can you increase the price?  Also,  can you lower fixed costs and obtain graphics services for a couple of hundred dollars less?  What if the marketing collaterals text was produced in-house by you and not outsourced?  How much will that increase the price of the time you spent developing the service,  another fixed cost?

Let’s say that you find graphics services for $1,500.00 and ask a marketing communications wizard to edit text that you write yourself for $800.00 (your personal labor increases: 6 hours writing at $50.00/hour = $300.00 + $2,500.00 = $2, 800.00).  Now,  the fixed cost is $5,100.00 and you think that $950.00 is a price that clients just might accept.  The variable costs will remain unchanged at $450.00,  because your printer is good,  his price is right and you’ll definitely need to advertise since you may want to charge more for the service.  At a unit price of $950.00,  the unit margin would be $500.00.   As shown,  by raising the price of the service by $200.00,  fixed costs are covered by delivering the goods 10+ times,  rather than 18+ times.

$5,100.00

BEV=             ________      =   10.2

$500.00/unit

As you can see,  the impact of other values such as increased advertising or higher quality materials or labor,  can also be assessed for impact on the pricing sweet spot and timeline for reaching BEV.  When bringing a new product or service to market,  take steps to identify the ideal pricing structure.

It is also useful to calculate the profit margin,  that is the percentage of sales revenues retained after all expenses are paid,  for each product and for the total line.  From the P & L Statement,  divide net profits by total sales revenues  (bottom line divided by top line).

 

Thanks for reading,

Kim

expert_author_1

 

 

The Data Driven Payoff

Because the February-March session sold out,  I have been invited to reprise my three-part workshop  “Become Your Own Boss: Effective Business Plan Writing”  at Boston Center for Adult Education 122 Arlington Street Boston MA on three Mondays,  May 9, 16 & 23 from 5:30 PM – 7:30 PM.  For more information or to register please visit http://bit.ly/becomeyourown59  or call 617.267.4430.

As Freelance consultants,  we know that information is nearly as valuable to us as our skill set.  Information leads us to make smart decisions about all aspects of business: what services to offer,  identifying target client groups,  determining a profitable business model,  understanding how to market our services,  gaining a competitive edge.  That good information is integral to all that we do comes as no surprise,  but until now there was no scientific evidence to support that belief.

New research done by Erik Brynjolfsson,  economist at the Massachusetts Institute of Technology Sloan School of Business,  Heekyung Kim,  graduate student in economics at MIT Sloan School and Lorin Hitt,  economist at the University of Pennsylvania Wharton School of Business proves that good information really does put money in your pocket.

The three studied 179 large businesses and found that when decisions enacted were based on reliable data,  companies achieved a 5+ % higher productivity level than businesses that relied more on “experience and intuition” for decision making.  The higher productivity could not be attributed to other factors,  such as the use of more sophisticated technology.

In the study,  data driven decision making was not primarily based on merely collecting data,  but was closely linked to how the data was utilized.  In the April 24, 2011 New York Times,  Mr. Brynolfsson stated that business decisions based on data and analysis “have huge implications for competitiveness and growth”.

Thomas Davenport,  professor of information technology and management at Babson College in Massachusetts supported the conclusions reached regarding data driven business decisions in a book written with Jeanne Harris and Robert Morison, “Analytics at Work: Smarter Results” (2010),  concluding that companies that rely heavily on data analysis are likely to outperform those that do not.

The big question is,  which data do we choose to collect and analyze and how do we best apply it?  Curating data is big business.  “The biggest change facing corporations is the explosion of data”,  said David Grossman,  technology analyst at Stifel Nicolaus in the April 24 NY Times.  “The best business is in helping customers analyze and manage all that data”.

How does a Freelancer decide what to do with data available to us?  I propose that data presented here would guide readers with excellent proficiency in mathematics and possessed of an advanced degree in the subject to become data analysts!  All others might take a look at our P & L statements and examine gross revenue and fixed and variable expenses and analyze how much it costs to generate income and what can be trimmed to make the bottom line better.

Speaking of revenue,  do some research on the services that your target clients are contracting for these days.  Are you retaining clients and signing new ones, too?  How does your 2Q 2011 active client roster compare to 2Q 2010?  Do you need to tweak your business model to maintain your competitive edge,  or might it be wiser to seek a strategic partnership?

To help figure things out,  do a free online search of Google’s Key Word Tool or Wonder Wheel and type in a descriptive phrase of your core service.  How many prospects in your locale are searching for what you sell?  Next,  type in a phrase that describes the service you think might interest clients and see how many local searches it gets.  There you have it,  data driven analysis to guide your business decisions.

Use Google Analytics to track hits to your website and report which pages receive the most attention.  You can correlate that data to the number of follow-up requests you receive and  the conversion of that follow-up to new business.  Make further use of that data to evaluate the efficacy of your website and learn how you can enhance this important marketing tool.  Will adding multimedia to your website be useful?  Or will adding pages to give more information do the trick?  Or maybe you should just simplify the text and clarify and strengthen your message?  Listen to the data and find your answers.

Thanks for reading,

Kim