Share
Alessandro Bogliari, CEO and Co-Founder of The Influencer Marketing Factory, a global influencer marketing agency, talks with great guests about influencer marketing, social media, the creator economy, social commerce and much more.
…
continue reading
Manage episode 514199096 series 2625056
Content provided by The PPC Den. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by The PPC Den or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://staging.podcastplayer.com/legal.
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 – Introduction
0:58 – The goal of an audit
2:27 – What an Amazon PPC audit actually is
3:01 – Observing, recommending, and taking action after audits
4:04 – How to download a bulk file from Amazon Advertising
6:01 – Why regular bulk file downloads are useful
6:33 – Analyzing at a high level: “lay of the land”
6:55 – Campaign structure analysis: auto vs manual targeting, match types, placements
8:07 – Using pivot tables for Amazon PPC analysis
14:22 – Common pivot table audits: match type summary
19:44 – Double pivot tables: skew + campaign name for detailed insights
24:42 – Pivot analysis for multi-ASIN creatives and video ads
25: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 advertising
-
Host and Executive Producer: Michael Erickson Facchin
Senior Producer: Nancy Lili Gonzalez
Podcast Coordinator & Graphic Designer: Sofiia Podash
Video and Audio Editor: Pedro Moreno
379 episodes
))
