Tag Archives: data analysis

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

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

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

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

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

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

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

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

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

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 }