Warning: Creating default object from empty value in /home/chadsummerhill/chadsummerhill.com/wp-content/themes/canvas/functions/admin-hooks.php on line 160

Huge Gazel Discount for a Limited Time!

This is the best discount I’ve ever offered for Gazel: http://www.gazel.ws/gazel-new-years-discount/  You can get a 40% discount on any of the license types until the end of January 2014. Happy Holidays!

Read full story Comments { 2 }
I’m Speaking at HeroConf 2013 in Austin

I’m Speaking at HeroConf 2013 in Austin

 I’m happy to announce that I will be speaking at HeroConf this year!  I was fortunate to be able to attend last year and was very impressed with the quality of the content.  This year is shaping up to be even better. I’m scheduled to present on Device Segmentation in a Post-”Enhanced Campaigns” World with David Rodnitzky and [...]

Read full story Comments { 0 }

Speaking at SMX West 2012 in San Jose

I’m excited to announce that I’ve been invited to speak at SMX West on 2/28 in the Power Tools For The Paid Search Pro session.  See the description below: Power Tools For The Paid Search Pro Building great PPC campaigns takes a lot of time, creativity and tools. In this session, we’ll look at free, nearly free and [...]

Read full story Comments { 0 }

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 }

Cross Ad Group Testing Excel Template: SMX Advanced Presentation

SMX Advanced, Seattle 2011 Presentation: Cross Ad Group PPC Ad Testing on Prezi  

Read full story Comments { 1 }

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 }
I’m Speaking at SMX Advanced

I’m Speaking at SMX Advanced

Looks like I will be speaking at SMX Advanced in Seattle on 6/8 in the Advanced Testing & Reporting session.  What do you hope gets covered in this session?  Please leave some comments.  Thanks!  

Read full story Comments { 5 }

Using INDEX-MATCH Lookup for PPC: Search Marketing Insider Guest Post

My first guest post for Search Marketing Insider shows you how to use the INDEX-MATCH Excel formula for lookups.  We all know how to use the VLOOKUP, but there are more flexible and powerful alternatives.  I hope you find the post useful. **UPDATE** Per Aaron Luckie’s request here’s a free download with all of the formulas [...]

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

Boost CTR Ad Text Optimization Q & A

Last month I was fortunate enough to be interviewed by Boost CTR.  Oddly enough, all their questions were about ad text optimization.  The main takeaway is we all need to test our ads more often, and that I place more value on copywriting skills over hard-core math skills.  Not to say that the statistics aren’t [...]

Read full story Comments { 0 }