FREE DOWNLOAD – Statistically Significant PPC Testing using Google Math

by on August 26, 2010 in Images, testing

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.

Download statistically significant ad testing spreadsheet

Tags: ,

About Chad Summerhill

View all posts by Chad Summerhill →

6 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.

    Reply
  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.

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

    Chad,

    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!

    Reply
    • 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!

      Reply
  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!

    Reply

Trackbacks/Pingbacks

  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 [...]

Leave a Reply