Amazon PPC Audit Pro

About

Amazon PPC Audit Pro — a complete Sponsored Products audit, optimization, and inventory-forecasting tool for sellers and agencies.

Upload your Amazon bulk file and reports, and in seconds get a full multi-tab audit dashboard, an AI-generated root-cause analysis with a prioritized action plan, FBA inventory forecasting that tells you exactly what and when to reorder, and one-click export to Excel, Google Sheets, or a client-ready report. Built by Byld Commerce for retail-media professionals who need fast, defensible, account-level decisions.

———————————————————————————
WHAT IT ANALYZES (20+ TABS)
———————————————————————————

- Executive Summary — top-line KPIs for the whole account at a glance.
- Account Health Score — a 0–100 composite grade (A–F) across efficiency, wasted spend, structure, coverage, growth, and inventory.
- Priority Action Plan — a ranked, root-cause-driven to-do list. Every step names what to change, why, the estimated dollar impact, and which tab to do it from.
- Wasted Spend — clicks and spend that produced zero orders, with the exact negatives to add.
- Bleeders — search terms that convert but at an ACoS well above target, with bid-down or pause guidance.
- CST Bucket & BCG Matrix — customer-search-term distribution and a stars/cash-cows/dogs view.
- Harvest Opportunities — converting search terms ready to promote into exact-match campaigns.
- Negative Opportunities — negative-keyword candidates scoped correctly to phrase/broad/auto/ASIN/category.
- Bid Efficiency — over- and under-bid targets versus your ACoS target.
- Structure Issues — seven best-practice checks including match-type isolation (with Broad Match Modifier detection), auto-campaign bucket splits, harvest-to-SKAG promotion, and under-bid exact keywords.
- Brand vs Non-Brand — spend and efficiency split so brand defense isn't flattering your blended numbers.
- ASIN Coverage Gap — organic bestsellers that are under-advertised, and ad-dependent listings that are a margin risk.
- ASIN PPC Performance & ASIN Placement Details — per-ASIN performance and placement breakdowns.
- Portfolio Performance — efficiency and pacing by portfolio.
- Placement Analysis — Top of Search vs Rest of Search vs Product Pages vs Amazon Business, with placement-bid guidance.
- Day-parting — day-of-week and hour-of-day heatmap with recommendations, surfacing the worst-day / high-spend / low-sales windows.
- Funnel Analysis, Funnel Expansion Map & N-Gram Analysis — winning and draining keyword fragments and funnel branches.
- SKU-ASIN mapping — clean reconciliation of SKUs to ASINs.

———————————————————————————
INVENTORY FORECASTING
———————————————————————————

Most PPC tools ignore inventory — but a sales-velocity drop is often a stock problem, not a bidding problem. Upload your FBA inventory report and order reports and the extension:

- Computes true sales velocity per ASIN, summed across all mapped SKUs.
- Distinguishes a SUPPLY problem from a DEMAND problem. When an ASIN is stock-constrained (sellable stock at or below Amazon's recommended minimum, or a lead-time-cover fallback), it uses the Maximum Sales Velocity — the peak sustained rate the product has proven — instead of the stock-out-suppressed recent rate. When stock is healthy, it uses the normal recent rate.
- Separates sellable stock (Inventory Supply at FBA) from reserved units (FC-processing, pending customer orders) so reserved units show in your total but never inflate velocity.
- Projects days of cover, stock-out date, reorder point, reorder quantity, and the last safe order date based on your lead time, safety stock, and target cover — all adjustable live in the dashboard.
- Flags overdue reorders and stock-outs that are quietly suppressing your sales and ad performance.

———————————————————————————
AI ANALYSIS, ROOT-CAUSE & ACTION PLAN
———————————————————————————

Run AI analysis to turn the raw audit into a narrative your client or team can act on:

- Root-Cause Analysis — the underlying drivers behind wasted spend and lost sales, each tied to the evidence that proves it and the downstream symptoms it causes.
- Priority Action Plan — a sequenced, dependency-aware runbook to optimize the account, ordered by impact and effort, distinguishing supply fixes (reorder) from demand fixes (bid, negate, restructure).
- Per-theme strategic findings across structure, bleed, funnel, ASIN, placement, timing, brand split, coverage, and inventory.
- Bring your own API key, stored locally per provider. The deterministic rule-based action plan is always generated even without AI.

———————————————————————————
DASHBOARD
———————————————————————————

- A fast, multi-tab interactive dashboard with charts, KPI cards, and grouped tables.
- Excel-style per-column sorting and filtering, including a dedicated sort/filter/search experience on the Inventory Forecast table.
- Hover tooltips across the entire dashboard — metrics, tabs, buttons, and controls — so every number is self-explanatory.
- Live recalculation of inventory plans when you change lead time, safety stock, or target cover.

———————————————————————————
EXPORTS
———————————————————————————

- Excel (XLSX) — a fully formatted workbook with every tab, the dashboard, AI notes, and the action plan.
- Google Sheets — the same audit pushed straight to a new Sheet.
- Client-ready report — a polished Word document and a Print / Save-as-PDF report including the Root-Cause Analysis and Priority Action Plan, with your own "Prepared by" branding.

———————————————————————————
PRIVACY
———————————————————————————

Your campaign data is processed in your browser to build the audit and is only sent externally when you explicitly run AI analysis (to your chosen provider with your own key) or export to Google Sheets (to your own account). No advertising data is sold or shared.

———————————————————————————
GETTING STARTED
———————————————————————————

1. Open the side panel and upload your Amazon bulk file, business report, purchased-product report, search-term impression-share report, and campaign report. Optionally add an order report, SP hourly report, and FBA inventory report for full functionality.
2. Run the audit and explore the dashboard.
3. Optionally run AI analysis for the narrative and action plan.
4. Export to Excel, Google Sheets, or a client-ready report.