One of our favorite PPC analysis tools is the pivot table. We use it 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
• Fix duplicate keyword and search term issues
• Assess many more types of data

Often, when we talk about pivot tables at conferences, in videos, or in blog posts, we just explain how to build one. We then show the pivot table layout so experts can follow along and do the analysis themselves.

However, not everyone knows the ins and outs of pivot tables. If you’re still learning how to create and use them, this video is for you. We cover how to:

• Create a pivot table
• Manipulate a pivot table
• Filter pivot tables
• Use calculated fields
• Create pivot charts
• Refresh pivot table data

After watching this video, you should be able to create and manipulate pivot tables with your Google Ads or Microsoft Ads data. We hope you enjoy the video.