This post is just as much for me as it is for you. I can’t tell you how many times I’ve bugged my coworkers asking them how to calculate a weighted average position when analyzing PPC reports with Excel or Tableau. I guess that’s what happens when you let a former art major do math, [...]
How to Calculate a Weighted Average Position in Excel & Tableau
by Chad Summerhill on April 15, 2011 in PPC Data Analysis
WordStream Guest Post – Analyzing Your AdWords Geographic Report Using Tableau
by Chad Summerhill on February 2, 2011 in guest post, PPC Data Analysis, Visualization
In my latest guest post over at the WordStream blog I show you how to use Tableau to analyze your AdWords Geographic Report. If you’ve never used Tableau before, it a powerfull business intelligence tool vor visual analytics. This post is a good introduction to how to use the tool for PPC.
Response to Siddharth’s Chernoff Faces
by Chad Summerhill on September 10, 2010 in Images, Visualization
This post is in response to Siddharth Shah’s article today over at Search Engine Land. He used Chernoff faces to show us a multi-dimensional view of data. I thought the article was awesome, and it inspired me to copy down the data he used in this article and put in Tableau. In the screen-shot below you will [...]
-
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
- Search Query Mining for Campaign Negatives August 5, 2010
-
Testing AdWords Modified Broad Match Keywords – Initial Findings
August 18, 2010
- 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
-
I’m Speaking at SMX Advanced
May 10, 2011
- How to Use the Google AdWords Shared LibraryFuture Marketing – Internet Marketing | Future Marketing - Internet Marketing: [...] don’t want to drive traffic for people loo...
- PPC Task Optimization- Heroview | PPC Hero: [...] Let data help you make decisions. For ad rot...
-
Easy Webs: This is an absolutely brilliant tutorial and downl...
-
Felice Bode: Chad (Richard), thanks a lot for adding to Chad's...
- eMentorMarketing » Use PPC Negatives And Save Money: [...] A helpful resource to working with that data...




