Over the last few weeks I’ve been writing a series of blog post over at WordStream on how to re-create the Google AdWords Performance Dashboard. Part 1: Getting the right data Part 2: Transforming the data Part 3: Building the scorecard Part 4: Building the charts Part 5: Making the dashboard dynamic Here’s the companion [...]
After receiving some feedback from Craig Danuloff I made some changes and improvements to the Broad Match Modifier Tool. Now you can choose which words in the keyword phrase you want to always have a “+”, sometimes have a “+” sign, and never have a “+” sign. I also made some corrections to the number of [...]
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 [...]
In this video I explain how to use an excel spreadsheet for determining statistical significance for PPC ad testing. I have included a free download of the spreadsheet as well as links to the resources used to create the spreadsheet. I used the ClickEquations blog for some inspiration and the Marketing Experiments blog, a Data Mining book, and [...]
- Free Excel Spreadsheet for PPC Text Ad Testing for Statistical Significance August 9, 2010
- Google Analytics URL Tracking Parameters for MSN – Free Excel Download August 13, 2010
- FREE DOWNLOAD – Statistically Significant PPC Testing using Google Math August 26, 2010
- Testing AdWords Modified Broad Match Keywords – Initial Findings August 18, 2010
- I’m Speaking at SMX Advanced May 10, 2011
- I’m Speaking at HeroConf 2013 in Austin February 27, 2013
- Speaking at SMX West 2012 in San Jose January 18, 2012
- WordStream’s AdWords Perfromance Grader: A Potentially Valuable Tool for SMB’s August 14, 2011
- Cross Ad Group Testing Excel Template: SMX Advanced Presentation June 8, 2011
- Google AdWords Dashboard: FREE Excel Template May 19, 2011
- Xin Hong: Great great article! Very helpful. I am a beginner...
- PPC Variations Performance Analysis and Reporting | Point It: [...] with impact to share. That is a statistical ...
- Are You Making Any of These 5 Ad Testing Mistakes? | webnewsreview.com: [...] This is simply fixed by plugging your perfor...
- Are You Making Any of These 5 Ad Testing Mistakes? | EProducts WebStore: [...] This is simply fixed by plugging your perfor...
- Kevin James McAuley: Hey Chad, Thanks for this helpful tutorial. Eve...