Tag Archives: data analysis

WordStream’s AdWords Perfromance Grader: A Potentially Valuable Tool for SMB’s

by on August 14, 2011 in PPC Data Analysis, Search Query Mining

WordStream has just released a compelling free tool targeted at SMB’s: the AdWords Performance Grader.  This new tool promises a free, instant audit of your AdWords account performance in eight key areas of PPC.  They’ve also included a best-practices checklist.  Here’s a list of the areas their tool covers: Wasted Spend (Negative Keywords) Quality Score [...]

Read full story • Comments { 0 }

Google AdWords Dashboard: FREE Excel Template

by on May 19, 2011 in guest post, PPC Data Analysis

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 }
How to Calculate a Weighted Average Position in Excel & Tableau

How to Calculate a Weighted Average Position in Excel & Tableau

by on April 15, 2011 in PPC Data Analysis

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

Read full story • Comments { 4 }

Certified Knowledge Guest Post – Evaluating AdWords Sitelinks

by on March 30, 2011 in guest post, PPC Data Analysis, text ads

In my latest post over at Certified Knowledge I explain how adding sitelinks impacted my overall search marketing mix (PPC & SEO).  There are also some great comments you will want to checkout.

Read full story • Comments { 0 }

WordStream Guest Post – Analyzing Your AdWords Geographic Report Using Tableau

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

Read full story • Comments { 1 }

WordStream Guest Post – Leveraging PPC Search Query Performance for Targeted SEO

by on January 12, 2011 in guest post, PPC Data Analysis, SEO

In my latest guest post over at the WordStream blog, I explain how to use your PPC search query performance data for targeted SEO.  I even included an Excel download with all of the formulas I used in the analysis.  I hope you find it useful.

Read full story • Comments { 0 }
WordStream Guest Post – Advanced Search Query Mining: Part 1

WordStream Guest Post – Advanced Search Query Mining: Part 1

by on November 10, 2010 in guest post, PPC Data Analysis, Search Query Mining

The first guest-post of a five part series I’m doing on Advanced Search Query Mining just went live today on the WordStream blog.  Here’s what I will be covering over the next few weeks: Part 1: The Power of Search Queries Part 2: Getting the Right Data Part 3: Preparing Your Data for Analysis Part 4: [...]

Read full story • Comments { 0 }
Peer Comparison Spreadsheet Updated with Significance Check

Peer Comparison Spreadsheet Updated with Significance Check

by on November 8, 2010 in PPC Data Analysis, Statistical Significance

This is just a quick post to let you know that the Peer Comparison Spreadsheet has been updated and now includes a statistical significance check—courtesy of Richard Fergie. Richard was kind enough to add both an Agresti-Coull and Wilson significance check to the spreadsheet making it a much more useful tool.  Now, not only can [...]

Read full story • Comments { 2 }
How to Calculate Peer Comparisons for PPC Data Analysis

How to Calculate Peer Comparisons for PPC Data Analysis

by on November 1, 2010 in PPC Data Analysis

My new favorite saying for PPC is, “Context is king!”  How do you know if a keyword’s CTR is good or bad?  How about your keywords CVR (conversion rate)?  We determine this by comparing our keyword’s performance to the average performance of the other similar keyword/ad combinations. PPC analysts make these types of comparisons all [...]

Read full story • Comments { 3 }