Warning: Creating default object from empty value in /home/chadsummerhill/chadsummerhill.com/wp-content/themes/canvas/functions/admin-hooks.php on line 160
Archive | PPC Data Analysis RSS feed for this section

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 }

Certified Knowledge Guest Post – Visualizing your Ad Testing

This is my debut guest post on the Certified Knowledge blog.  I give detailed instructions for visualizing your PPC ad testing using cumulative metrics.  This is a great compliment to any ad testing analysis and I hope you find the time to check it out.  While you are there, have a look around the Certified […]

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 }

Advanced Search Query Mining Excel Template

Today my last guest post on Advanced Search Query Mining will go live over at the WordStream blog.  Below you will find the companion Excel spreadsheet that contains all of the formulas I used in the series. Part 1: The Power of Search Queries Part 2: Getting the Right Data Part 3: Preparing Your Data […]

Read full story Comments { 3 }
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 }