Tag Archives: tools

Google AdWords Dashboard: FREE Excel Template

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

Read full story Comments { 1 }
Broad Match Modifier Tool Updated

Broad Match Modifier Tool Updated

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

Read full story Comments { 2 }
FREE DOWNLOAD – Statistically Significant PPC Testing using Google Math

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

Read full story Comments { 7 }
Free Excel Spreadsheet for PPC Text Ad Testing for Statistical Significance

Free Excel Spreadsheet for PPC Text Ad Testing for Statistical Significance

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

Read full story Comments { 24 }