One of our favorite PPC analysis tools is the Pivot table. We use them for many different types of analysis, such as:

• Find where to improve Quality Scores
• Find match type and query issues
• Examine Quality Score by landing page
• Audit ad extensions
• Fixing duplicate keyword and search term issues
• Many, many more data types

Often when we’re talking about pivot tables at conferences, videos, blog posts, etc we just say to make a pivot table this way and then will show the pivot table layout so the experts can follow along and easily do this analysis for themselves.

However, not everyone knows the ins and outs of pivot tables. If you are still working on how to create and use pivot tables, this video is for you. In it we cover how to:

• Create a pivot table
• Manipulate a pivot table
• Pivot table filtering
• Calculated fields
• Pivot table charts
• Refreshing pivot table data

After watching this video, anyone should be able to create and manipulate a pivot table full of their Google Ads or Microsoft Ads data. We hope you enjoy the video.