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

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 }

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 }