How to Use AI & Spreadsheets to Prevent Amazon Stock-Outs

<p>Today, we are joined by the amazing Maryna from the Ad Badger team. If you have ever wondered why your Amazon PPC performance suddenly dropped, even when your bids, keywords, and competitor pricing look perfect this episode is for you.</p><p>Maryna shares her brilliant workflow for managing massive Amazon accounts that juggle thousands of SKUs. We discuss how to combine three essential Amazon reports into one master spreadsheet to accurately track your inventory levels. But the real magic happens next: we explore how to feed that data into AI chatbots, like Claude or Gemini, to instantly generate beautiful, actionable dashboards.</p><p>We’ll see you in The PPC Den!</p><p><br></p><p><strong>🦡 Highlights ​​ </strong></p><p><br></p><p>00:00 – Intro</p><p>01:28 - The challenge of tracking inventory for large accounts</p><p>02:25 - How hidden low stock secretly ruins PPC performance</p><p>05:35 - The 3 essential Amazon reports you need to download</p><p>06:03 - Reading the master spreadsheet for stock and inbound data</p><p>08:28 - How Amazon penalizes your ranking when inventory drops</p><p>09:21 - Turning spreadsheets into a Claude dashboard</p><p>14:31 - Spotting restocked SKUs that are ready to be pushed</p><p>16:41 - Exactly when to pause, trim, or boost PPC budgets</p><p><br></p><p><strong>🦡 Resources &amp; Links</strong></p><p><br></p><p>🦡 <a href=" https://www.adbadger.com/pricing/ " target="_blank" rel="ugc noopener noreferrer">GET AD BADGER</a> ➡️</p><p>- Find <a href="https://www.linkedin.com/in/michael-erickson-facchin/ " target="_blank" rel="ugc noopener noreferrer">Michael Erickson Facchin </a>— Ad Badger’s CEO and soul, PPC whisperer, and your go-to guide through the wild world of Amazon advertising</p><p>- Today on the show, we’re thrilled to welcome <a href="https://www.linkedin.com/in/maryna-nelep-83717649/?locale=en_US&skipRedirect=true&locale=en_US" target="_blank" rel="ugc noopener noreferrer">Maryna Nelep</a>, an Amazon PPC manager and proud member of our Ad Badger family!</p><p>- <a href="https://www.adbadger.com/blog/amazon-ppc-education/how-to-audit-your-amazon-ppc-account-using-bulk-files-and-business-reports-the-ppc-den-podcast/ " target="_blank" rel="ugc noopener noreferrer">How to Audit Your Amazon PPC Account Using Bulk Files and Business Reports</a></p><p>- <a href="https://www.adbadger.com/blog/amazon-ppc-education/youre-not-out-of-stock-so-why-are-your-sales-down-the-ppc-den-podcast/ " target="_blank" rel="ugc noopener noreferrer">You’re Not Out of Stock, So Why Are Your Sales Down?</a></p><p>- <a href="https://www.adbadger.com/blog/amazon-ppc-education/why-amazon-ppc-bulk-files-are-more-powerful-than-ever-and-how-to-get-started-the-ppc-den-podcast/ " target="_blank" rel="ugc noopener noreferrer">Why Amazon PPC Bulk Files Are More Powerful Than Ever (And How to Get Started)</a></p><p>- <a href="https://www.adbadger.com/blog/amazon-ppc-education/3-bad-habits-in-amazon-ppc-its-time-to-break-the-ppc-den-podcast/ " target="_blank" rel="ugc noopener noreferrer">3 Bad Habits in Amazon PPC It’s Time to Break</a></p><p>📚<a href=" https://www.adbadger.com/amazon-ppc-checklist/" target="_blank" rel="ugc noopener noreferrer"> Unlock our FREE comprehensive Amazon Marketing Playbook</a></p><p>- <a href="https://www.adbadger.com/newsletter/" target="_blank" rel="ugc noopener noreferrer">Subscribe to our newsletter</a></p><p>- <a href="https://www.adbadger.com/amazon-ppc-checklist/ " target="_blank" rel="ugc noopener noreferrer">Transform your workflow with our comprehensive Amazon Advertising checklist</a></p><p>- <a href="https://www.adbadger.com/amazon-ppc-checklist/ " target="_blank" rel="ugc noopener noreferrer">Review all our show notes</a></p><p><br></p><p>-</p><p><br></p><p>Host and Executive Producer: Michael Erickson Facchin</p><p>Guest Co-Host: Maryna Nelep</p><p>Senior Producer: Nancy Lili Gonzalez</p><p>Podcast Coordinator &amp; Graphic Designer: Sofiia Podash</p><p>Video and Audio Editor: Pedr