Tag Archives: excel

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 }

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 }

WordStream Guest Post – Leveraging PPC Search Query Performance for Targeted SEO

by on January 12, 2011 in guest post, PPC Data Analysis, 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 }