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

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 }

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 }

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 – Adwords Automated Rules for Bidding?

In my latest guest post over at WordStream I discuss my concerns about using Automated Rules for bidding.  Looks like Google doesn’t want you to use it for bidding and I agree.

Read full story Comments { 0 }

WordStream Guest Post – Using Symbols in PPC Ad Testing

My latest guest post over at the WordStream blog.  I explain the benefits of acting on good PPC advice from the community.  I go into detail about taking Tom Demer’s advice on using symbols in ad testing.  Hope you find it useful.

Read full story Comments { 1 }

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 }

WordStream Guest Post – 10 PPC New Year’s Resolutions for 2011

In my latest guest post over at the WordStream blog I outline 10 PPC New Year’s Resolutions.  Hoefully I will stick with them.  Here’s an 11th bonus resolutions: 11.  I will re-read all of the posts from The RKG Blog & the ClickEquations Blog There are several PPC blogs that I follow closely, but there is something special about […]

Read full story Comments { 2 }

WordStream Guest Post – AdWords Campaign Experiments Adds Ads: Why I’m Disappointed

Have a look at my latest guest post over at the WordStream Blog.  I explain why I’m disappointed with the new AdWords Campaign Experiments ad testing feature.  I feel strongly that AdWords could have done a little better with the execution of this much needed feature.

Read full story Comments { 0 }