How to Audit Amazon PPC Campaigns Using Bulk Files and Pivot Tables

Hey, if you’re managing Amazon PPC, you need to check out the latest PPC Den Podcast episode. Mike walks you through how to audit your campaigns using bulk files and pivot tables — step by step. What’s really valuable is how he highlights where ad spend might be wasted, which campaigns or products are performing best, and how to optimize match types like broad, phrase, and exact. He also points out the usual frustrations with Amazon Ads — signing in, switching between Seller Central and Advertising — and shows a cleaner, faster way to get insights using spreadsheets.Mike even covers pivot table examples, double pivots, and placement analysis, giving you a practical workflow you can start using right away.🦡 Highlights ​​0:00 – Introduction0:58 – The goal of an audit2:27 – What an Amazon PPC audit actually is3:01 – Observing, recommending, and taking action after audits4:04 – How to download a bulk file from Amazon Advertising6:01 – Why regular bulk file downloads are useful6:33 – Analyzing at a high level: “lay of the land”6:55 – Campaign structure analysis: auto vs manual targeting, match types, placements8:07 – Using pivot tables for Amazon PPC analysis14:22 – Common pivot table audits: match type summary19:44 – Double pivot tables: skew + campaign name for detailed insights24:42 – Pivot analysis for multi-ASIN creatives and video ads25:00 – Outro🦡 Resources & Links🦡 GET AD BADGER ➡️ Find Michael Erickson Facchin — Ad Badger’s CEO and soul, PPC whisperer, and your go-to guide through the wild world of Amazon advertisingAudit Your Amazon PPC Account: The 5 Step GuideHow Can An Amazon Campaign Audit Help My Business?Live Amazon PPC Campaign AuditReconstructing Campaign Architecture for Multi-ASIN Portfolios6 Principles to Follow For Amazon PPC Campaign Structure📚 Unlock our FREE comprehensive Amazon Marketing PlaybookSubscribe to our newsletterTransform your workflow with our comprehensive Amazon Advertising checklistReview all our show notes-Host and Executive Producer: Michael Erickson FacchinSenior Producer: Nancy Lili GonzalezPodcast Coordinator & Graphic Designer: Sofiia PodashVideo and Audio Editor: Pedro Moreno