A Better Split Tester

Done in Excel Than

Google Website Optimizer

Google AdWords’ Website Optimizer is a great tool to run split-tests on landing pages in your AdWords account. You can, however, easily create a much more versatile split-tester with Excel that produces exactly the same result as the Website Optimizer but is much simpler to use.

This article and the video below will provide specific instructions on how to produce a split-tester in Excel that produces exactly the same result as the Website Optimizer because it runs the same statistical test (a one-tailed, two-sample, unpaired hypothesis test of proportion), but the Excel Split-Tester can be used in almost any marketing situation that would employ split-testing in any general way.

The Optimizer is a tool built into Google AdWords and can only be used in that medium.

Step-By-Step Video About How To Create an Excel Split-Tester That Is Much More Useful Than Google's Web Site Optimizer

(Is Your Sound Turned On?)

Google Web Site Optimizer in Action

Click On Image To See Enlarged View

Close-Up of the Above Screen

Click On Image To See Enlarged View

Excel Split-Tester Performing the Same Comparison

Click On Image To See Enlarged View

This is also the same Statistical test that the Excel Split-Tester performs

Example of Everyday Marketing Use of the Excel Split-Tester

The Excel split-tester that you’ll make can be applied to almost any marketing situation. For example, you could easily use your Excel split-tester to determine whether a change made to a direct mail campaign really made a difference.

The Google Website Optimizer runs the statistical hypothesis test on the number of clicks and number of conversion that each landing page elicits. The hypothesis test calculates the probability that the result obtained – one landing page having a higher conversion rate than the other – is true and not just the result of random luck.

How I Use the Excel Split-Tester

I use this Excel split-tester all the time in my job as an Internet marketing manager and I really enjoy its ease of use. All I have to do is plug a couple numbers right out of my AdWords account into the Excel split-tester and I have my answer in a second. The Excel split-tester has none of the set-up requirements that there are inherent with the Google AdWords Website Optimizer.

When I use the split-tester to test AdWords landing pages against each other, I will normally conclude that one landing page converts better when the split-tester states there is at least an 80% chance that the result obtained - one conversion rate is higher than the other – is a real and not just a chance occurrence.

The above video also provides a statistical derivation of the functionality of the split-tester.

Conclusion - It's the Greatest Thing Since Sliced Bread for the Marketer

If you are a marketer, you will get a lot of great use out of this extremely versatile and powerful tool.

Feel free to provide any comments to this article. Also, if you have any other ways of using Excel to optimize your AdWords account, let us know. Your input and opinions are highly valued!

If You Like This, Then Share It...

Click Here to Download the Excel spreadsheet with the fully functioning Split-Tester shown here for only $7.

Also get the FREE BONUS

100+ page Excel Statistical Distribution Graphing eManual. This eManual shows you step-by-step how to create user-interactive graphs in Excel of all major statistical distributions.

Excel Master Series Blog Directory

Statistical Topics and Articles In Each Topic

Become an Excel Statistical Master

Excel Master Series - MBA-level statistics - Over 1,100+ Pages of Easy-To-Follow Instructions in Excel

It's a Full
Easy-To-Follow
MBA Course in Business Statistics

ALL IN EXCEL

&

MUCH Clearer

Than Your Text

Book

Download the
1,100+ Page Excel Statistical Master now

More Easy-To-

Follow eManuals

That You Will

Master Quickly

Step-By-Step Optimization With Excel Solver

What's In It?

For anyone who wants to be operating at a high level with the Excel Solver quickly, this is the book for you. Step-By-Step Optimization With Excel Solver is a 200+ page .pdf e-manual of simple yet thorough explanations on how to use the Excel Solver to solve today’s most widely known optimization problems. Loaded with screen shots that are coupled with easy-to-follow instructions, this book will simplify many difficult optimization problems and make you a master of the Excel Solver almost immediately.

Here are just some of the Solver optimization problems that are solved completely with simple-to-understand instructions and screen shots in this e-manual:

• The famous “Traveling Salesman” problem using Solver’s Alldifferent constraint and the Solver’s Evolutionary method to find the shortest path to reach all customers. This also provides an advanced use of the Excel INDEX function.

• The well-known “Knapsack Problem” which shows how optimize the use of limited space while satisfying numerous other criteria.

• How to perform nonlinear regression and curve-fitting on the Solver using the Solver’s GRG Nonlinear solving method.

• How to solve the “Cutting Stock Problem” faced by many manufacturing companies who are trying to determine the optimal way to cut sheets of material to minimize waste while satisfying customer orders.

• Portfolio optimization to maximize return or minimize risk.

• Venture capital investment selection using the Solver’s Binary constraint to maximize Net Present Value of selected cash flows at year 0. Clever use of the If-Then-Else statements makes this a simple problem.

• How use Solver to minimize the total cost of purchasing and shipping goods from multiple suppliers to multiple locations.

• How to optimize the selection of different production machine to minimize cost while fulfilling an order.

• How to optimally allocate a marketing budget to generate the greatest reach and frequency or number of inbound leads at the lowest cost.

Step-By-Step Optimization With Excel Solver has complete instructions and numerous tips on every aspect of operating the Excel Solver. You’ll fully understand the reports and know exactly how to tweek all of the Solver’s settings for total custom use. This e-manual also provides lots of inside advice and guidance on setting up the model in Excel so that it will be as simple and intuitive as possible to work with.

All of the optimization problems in this book are solved step-by-step using a 6-step process that works every time. In addition to detailed screen shots and easy-to-follow explanations on how to solve every optimization problem in the book, a link is provided to download an Excel workbook that has all problems completed exactly as they are in this e-manual.

Step-By-Step Optimization With Excel Solver is exactly the e-manual you need if you want to be optimizing at an advanced level with the Excel Solver quickly.

*******************

Become an Excel Statistical Master

It's a Full
Easy-To-Follow
MBA Course in Business Statistics

ALL IN EXCEL

&

MUCH Clearer

Than Your Text

Book

Download the
1,100+ Page Excel Statistical Master now

More Easy-To-

Follow eManuals

That You Will

Master Quickly

*******************

Become an Excel Statistical Master

It's a Full
Easy-To-Follow
MBA Course in Business Statistics

ALL IN EXCEL

&

MUCH Clearer

Than Your Text

Book

Download the
1,100+ Page Excel Statistical Master now

More Easy-To-

Follow eManuals

That You Will

Master Quickly

*******************

Become an Excel Statistical Master

It's a Full
Easy-To-Follow
MBA Course in Business Statistics

ALL IN EXCEL

&

MUCH Clearer

Than Your Text

Book

Download the
1,100+ Page Excel Statistical Master now

Immediate, Absolute, No-Questions-Asked, Money-Back Guarantee If Not TOTALLY, 100% Satisfied. In Other Words, If Any Excel Master Series eManual That You've Purchased Here Does Not Provide Instructions That Are CRYSTAL CLEAR and EASY TO UNDERSTAND, You Get All Of Your Money Back Immediately and Keep the eManual. Guaranteed!

Meet The Author