The Badger here. Episode 404 of the PPC Den Podcast.
Since 2018 Mike has been handing you spreadsheets. The bid calculator. The placement calculator. The n-gram sheet that took him eons to build. All of them needed you to copy, paste, and squint.
I retired the copy-and-paste. Go to sheets.adbadger.com, drop in your bulk file, and I dig through it right there in your browser. Add your business report and I'll line your ad numbers up against your organic ones too. It costs nothing. It stays free.
Every account starts at 100. Then I take points away. Most of them go to one thing: spend on search terms that never produced an order. Not at the keyword level. At the search term level, where the dirt actually is.
In this episode Mike walks through the whole audit, screen by screen, in the order he'd audit an account himself.
Reading bulk files is the most tedious job in Amazon advertising. I don't care. That's the job.
(0:00) Eight years of Ad Badger spreadsheets (1:30) Why we retired the copy-and-paste (2:12) How I score your account (3:00) Search term level vs. keyword level (3:51) Converting terms you haven't promoted yet (4:47) Structure, budgets and placements (5:40) Competitor ASINs worth targeting (6:24) Share of spend vs. share of revenue (7:22) Ghost impressions and bleeders (8:19) Why any ACOS beats no sales (9:22) N-gram analysis and negative keyword coverage (10:12) AMC audiences and total ACOS by product
Podden och tillhörande omslagsbild på den här sidan tillhör
The PPC Den. Innehållet i podden är skapat av The PPC Den och inte av,
eller tillsammans med, Poddtoppen.
