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!

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

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 Matt Umbro, so I’ll try to keep up. My plan is to focus on how we are transitioning to Enhanced Campaigns here at upack.com–I think you will find it interesting and helpful as you also prepare for the transition. Hope to see you there!

]]>http://www.chadsummerhill.com/im-speaking-at-heroconf-2013-in-austin/feed/0Speaking at SMX West 2012 in San Josehttp://www.chadsummerhill.com/speaking-at-smx-west-2012-in-san-jose/?utm_source=rss&utm_medium=rss&utm_campaign=speaking-at-smx-west-2012-in-san-jose
http://www.chadsummerhill.com/speaking-at-smx-west-2012-in-san-jose/#commentsWed, 18 Jan 2012 03:36:51 +0000http://www.chadsummerhill.com/?p=180Speaking 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 [...]

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 homegrown tools used by expert PPC managers, and examine 15-20 simple tools that solve a particular task and can save hours/days. We’ll also review some fairly unknown tools which help you every step through creating/managing PPC campaigns – from discovering and selecting keywords, building word lists, analyzing competitors, creating and managing both text and display ads, charting, bidding, ad testing and reporting.

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

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

Impression Share

Click Through Rate (CTR)

Account Activity

Long-tail Keyword Optimization

Text Ad Optimization

Landing Page Optimization

The idea sounds great; auditing performance in an AdWords accounts is hard and complicated work. The tool uses the performance and activities of other accounts with similar spend levels to your own for context. For example: if they have observed that accounts similar to yours add 100 negative keywords per month, and you haven’t added any, then it might suggest that you are falling behind with your search query mining efforts. If this is true you might be wasting a large percentage of your budget on irrelevant search queries.

While I don’t completely agree with everything the tool does to grade performance, I do agree that the areas that this new tool focuses on can have a profound effect on your account’s overall performance.

I would recommend you give it a try to see how you compare. Make sure you let WordStream know what you think of the tool and the grade you receive. Hopefully, with enough feedback this new AdWords tool could become even more useful.

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

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

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 used in the posts.

]]>http://www.chadsummerhill.com/indexmatch-lookup-ppc-search-marketing-insider-guest-post/feed/0How to Calculate a Weighted Average Position in Excel & Tableauhttp://www.chadsummerhill.com/calculate-weighted-average-position-excel-tableau/?utm_source=rss&utm_medium=rss&utm_campaign=calculate-weighted-average-position-excel-tableau
http://www.chadsummerhill.com/calculate-weighted-average-position-excel-tableau/#commentsFri, 15 Apr 2011 05:07:58 +0000http://www.chadsummerhill.com/?p=138How 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, [...]

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, but weighted average position is just one of those must-have PPC tools.

You’ve probably ran into a post or two over the last couple of years about using pivot tables to analyze your PPC data. Some of those posts may have been kind enough to include instructions for how to calculate a weighted average position. This is important because once you start aggregating your data in a pivot table you can’t average your Average Position or you will get a skewed perspective.

How to Calculate a Weighted Average Position in Excel

Regardless of the report you need to analyze, you will add an “AvgPos X Impressions” column. This column will be used to create a ‘Calculated Formula’ in your pivot table.

Now name your new ‘Weighed Avg Pos” metric and use the following formula:

=’AvgPos*Impressions’ /Impressions

PPC Weighted Average Position Excel Calculated Field

Now you will have an accurate representation of average position regardless of the level of detail in your pivot table.

How to Calculate a Weighted Average Position in Tableau

For those of you fortunate enough to have Tableau for analyzing your PPC data, calculating a weighted average position is just as easy as in Excel. Navigate to the ‘Calculated Field’ tool by right-clicking in the ‘Measures’ area and clicking ‘Create Calculated Field…”

Again name your new metric ‘Weighted Avg Pos’ and use the following Tableau formula:

sum([Avg Position]*[Impressions])/sum([Impressions])

PPC Weighted Average Position Tableau Formula

There, I’ve written it down. Now I can quit bothering my co-workers and just reference this post in the future. Those of you with better memories may not need this reference, but for the rest of you feel free to bookmark this page.

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

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 important. I just feel that there are plenty of ad testing tools to help advertisers make a decision, but a piece of software won’t make you an awesome copywriter.

If you need help coming up with some new ad copy, Boost CTR can get talented copywriters started on your ad copy for less than $100/ ad group (that’s not bad). If they don’t beat your old ads in 30 days you can get your money back, so it’s not too risky to try them out.