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 Excel Template file containing all the formulas, etc:





This is an absolutely brilliant tutorial and download – really useful because I’ve got to set all this up for a client and having a template to work from is mega handy! Thanks