Join us April 28-30 | Austin, TX

Learn More
Untitled 2

Wasting Money In Your PPC Accounts? Pivot Tables Are Here To Help!

Print This Post Print This Post

Dave Rosborough shows you how to use pivot tables in Microsoft Excel to make your PPC accounts more profitable!

About the Author

Amanda @Amanda_WestBook

Amanda is a Senior Account Manager at Hanapin Marketing, a search engine marketing firm focused on generating results through pay-per-click advertising. Google+.
  • Raju Paliwal

    That is what i always Use

  • Jack Hutchinson

    Got to love the pivot tables! Best thing to come out of Excel ever!

    • Dave Rosborough

      Couldn’t agree more, Jack. Thanks for watching!

  • Greg Carter

    Although I do love pivot tables, I felt that the theme creation process really needed more details. I just don’t see why themes would be different than Ad Groups.

    Other than that, thanks for the quick demonstration.

    • Karl Newlin

      the themes can help you go more granular at the adgroup level…

  • Dave Rosborough


    Appreciate the kind words. It’s truly amazing how powerful PivotTables can be.

    When coming up with “themes”, I like to try and identify a handful of recurring keyword qualifiers when reviewing my search query data. This can be particularly effective when dealing with broad match keywords and their matched queries that often lack relevance to your product or service.

    For example, let’s say you notice a lot of queries containing “buy” and you’re interested in finding out if any of them are leading to sales. This could then be used as a theme for the process demonstrated in the video. Other possible themes could include “blog”, “reviews”, “compare”, “order”, etc.

    Of course, this process takes a bit of manual work on our end, but can be helpful in analyzing performance of queries containing those qualifiers (“themes”). Hope that helps, thanks for watching!

  • Kimmie

    Nice video, thank you for sharing this. Do you have Video how to review ads in pivot table?


Sometimes we all need a little help from a hero, and that's exactly what we offer at PPC Hero. From a simple account audit to full time management, you can hire a hero to work on your accounts!