Is your data telling the whole story? Rank Your Click Data and Your “Lift” From Word-of-Mouth

If marketing metrics sounds complicated to you perhaps you’re guilty of not measuring your activities as often as might be helpful.   Grapics of a man in a suit jumping for joy because he sees successful improvementsBusinesses that measure their activities perform higher than those who do not (said every business professor and adviser we can think of).

Do you want to know how to figure out which recommendations and affiliates provide the highest return?

If you want a quick way to RANK your CLICK DATA in order to uncover the most powerful recommendations your business receives, author Mark Jeffrey has provided that methodology.  See these easy steps, below:

  1. On a spreadsheet or piece of paper, make 6 columns.
  2. Column 1 is titled ranking by direct traffic.
  3. Column 2 is the “source name” or link, for example, or http://www.youtubecom.
  4. Column 3 is “Direct Clicks”.
  5. Column 4 is “Recommendation Clicks”.
  6. Column 5 is labelled as “Lift from Recommendations”.
  7. Column 6 is labelled “Word of Mouth”.

Columns 3 and 4 are numbers that you enter based on your traffic. You should be able to access direct clicks and recommendations clicks from your website analytics.  For example, Google Analytics and Facebook Analytics will give you these numbers.

To determine the percentage of lift (column 5) just divide recommendation clicks by direct clicks. Format this number as a percentage if you are using a spreadsheet.

Column 6 is calculated by adding direct clicks and recommendations clicks together.  That sum is then divided by direct clicks.  This gives you a value to use as alternative ranking to direct traffic.  It is called word-of-mouth (WOM) and is formatted as a decimal figure.

Now you may easily re-order your rankings in a simple way that is not based on direct clicks alone.  In Mark Jeffrey’s version described here, you re-order your traffic based on word-of-mouth (WOM).  This allows managers and owners to view the power of recommendations from affiliates, sponsors, and others in an informative way.

Once you have completed these steps for your campaign, you’ve uncovered which sources are providing the greatest lift and which sources are giving you the greatest return, based on their word of mouth.

Sometimes rankings provided by direct traffic alone do not tell the whole story!

Source: You can download Mark Jeffrey’s formulas and other tools.

To apply for consulting with WFCSBE at CSUN fill out the online application.

Follow our blog: WFCSBE Blog
Google+:             Google+ link
Twitter:                Twitter link
Facebook:           Facebook page link
Author:Robin Yerian.  Robin studies Marketing and Business Administration at California State University, Northridge.  She has received an honorable mention for her secondary research regarding the millennial generation in association with the national American Marketing Association case competition for eBay in which she provided consumer insights.  Robin is the student assistant responsible for managing client relationships, communications, and social media for the Wells Fargo Center for Small Business & Entrepreneurship at CSUN.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s