Warning: Creating default object from empty value in /home/chadsummerhill/chadsummerhill.com/wp-content/themes/canvas/functions/admin-hooks.php on line 160

FREE DOWNLOAD – Statistically Significant PPC Testing using Google Math

I recently posted an article about statistically significant ad testing which has been, by far, my most popular post since starting the blog.  In a quest to understand the math behind statistical significance I came across some great information provided by Google.

So, I took their math and created an Excel spreadsheet for a free download.  According to Google this approach is appropriate for percentage metrics like: CTR, CVR, etc.  I hope you find a good use for it.

[socialshare-download href=”http://www.chadsummerhill.com/wp-content/uploads/downloads/2010/08/GOOGLE_STATS.xlsx”]EXCEL TEMPLATE[/socialshare-download]

Tags: ,

7 Responses to “FREE DOWNLOAD – Statistically Significant PPC Testing using Google Math”

  1. Shawn Livengood August 30, 2010 at 11:04 am #

    Great spreadsheet, Chad. Every PPC manager needs to pay attention to statistical significance in testing, and this worksheet really takes the hassle out of doing the math.

  2. Chad Summerhill August 30, 2010 at 1:09 pm #

    Thanks for stopping by Shawn! Glad you’ve found it useful. Love your blog by the way.

  3. David Jaeger August 31, 2010 at 7:36 pm #


    Thanks for the spreadsheet! We do PPC ad competitions here in the office, and this will be a good way to make sure our data is accurate!

    • Chad Summerhill August 31, 2010 at 7:52 pm #

      Hi David,

      I’m glad you find it useful. And thanks for the tweet about my YouTube channel!

  4. Katie Saxon July 12, 2011 at 10:30 am #

    Chad, you are a PPC god! This is exactly what I’ve been looking for to help my testing, thanks so much!


  1. Pay Per Click: How do you decide when a result is statistically significant when testing out new ad copy, bid types etc for pay per click accounts? - Quora - July 13, 2011

    […] Andy. Funnily enough, I also managed to stumble on this yesterday, but I also found this one http://www.chadsummerhill.com/st… that I found more helpful.Katie Saxon • 1:08amView 1 Comment Edit Link Text Show answer […]

  2. Fast Track To Finding Statistical Significance | PPC Hero® - March 12, 2014

    […] This comes from my PPC celebrity crush of the moment Chad Underhill. He wrote a fantastic blog post about statistical significance and even concocted a spreadsheet for you to use in your day-to-day […]

Leave a Reply