I’m Speaking at HeroConf 2013 in Austin

I’m Speaking at HeroConf 2013 in Austin

by on February 27, 2013 in Speaking Event

 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

by on January 18, 2012 in Speaking Event

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

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 }

Cross Ad Group Testing Excel Template: SMX Advanced Presentation

by on June 8, 2011 in Uncategorized

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

Read full story • Comments { 1 }

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

I’m Speaking at SMX Advanced

by on May 10, 2011 in Speaking Event

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

by on May 1, 2011 in 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

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 }

Boost CTR Ad Text Optimization Q & A

by on April 7, 2011 in Statistical Significance, testing, text ads

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 }

Championship Game – Search Marketing Madness

by on April 4, 2011 in Uncategorized

Please vote for PPC Prospector in the championship game of PPC Hero’s Search Marketing Madness. I’m going up against Copy Blogger, so I will need all the support I can get.  Thanks!

Read full story • Comments { 0 }