Chad Summerhill
PPC Storytelling: How to Make an Excel Bubble Chart for PPC
As PPC managers, we understand our campaigns, but it can be difficult to quickly and effectively describe our campaigns to our clients or supervisors in order to set the proper context for further exploration.
Re-Creating AdWords Campaign Performance Charts in Excel, Part 5: Dynamic Controls
This is the final post in Chad Summerhill's series on re-creating the AdWords dashboard in Excel. Includes a free PPC dashboard download!
Re-Creating AdWords Campaign Performance Charts in Excel, Part 4: Making the Charts
In the fourth part of this five-part series, learn how to create the charts for your AdWords campaign performance charts.
Re-Creating AdWords Campaign Performance Charts in Excel, Part 3: Making the Scorecard
Building dynamic dashboards in Excel can be a challenge, but if you’ve already completed the steps from the first two posts in this series you’ve done the hard part. Now we are ready for the fun stuff.
Re-Creating AdWords Campaign Performance Charts in Excel, Part 2: The Transformation
In Part 2 of this series, you'll learn how to set up an Excel pivot table, how to use calculated metrics, how to use the OFFSET formula in Excel...
Re-Creating AdWords Campaign Performance Charts in Excel, Part 1: The Data
Learn how to re-create an AdWords dashboard that is no longer available, using Excel, in this tutorial.
Analyzing Your AdWords Geographic Report Using Tableau
Learn how to use Tableau business intelligence and data visualization software to analyze your Geographic Report in Google AdWords.
Advanced Search Query Mining Part 5: Acting on Your Insights
In the final post of our Advanced Search Query Mining series, learn how to act on the insights you've gathered. Bonus: Free Excel download.
Advanced Search Query Mining Part 4: Mining Your Data for Insights
Learn how to analyze your data to find negative keyword candidates in the next installment of our series on advanced search query mining.