Advanced Demo · Interactive Walkthrough

A guided tour of an Amazon Ads intelligence platform — built by an operator.

Below is a complete picture of the project: what each of the sixteen modules does, how the workflow connects, and the engineering choices that keep the analysis inside your browser. Scroll to explore. Click Launch Live Demo when you're ready to drive it yourself.

Launch Live Demo — no signup Take the tour

149K+rows in <2s

16analysis modules

0uploads needed to analyze

First time here?

What you're looking at

AdInsight Pro is a self-built intelligence layer for Amazon Advertising. It replaces a stack of spreadsheets, VLOOKUPs, and manual audits with a single browser dashboard whose analysis runs on your machine.

Built by an operator

Every module exists because the workflow it replaces was painful enough to automate. No "nice to have" features — only the things that move ACoS, surface waste, or save an hour of manual work.

Runs in your browser

DuckDB-WASM parses 149K-row bulk files in under two seconds, locally. Analysis needs no upload, no server round-trip, and no third-party tracking — cloud storage is opt-in, only for sessions you choose to save.

Bulk-ready output

Every optimization writes back to Amazon's exact bulk-upload schema. You paste the export straight into Campaign Manager — no reformatting, no schema-mapping, no copy-paste broken bids.

Sixteen modules · one dashboard

Every analysis you actually run, in one place

Hover any card to see it lift in 3D. Each one is fully clickable inside the live demo — sample data is pre-loaded so you can explore immediately.

60D Bulk File Summary

Drop in an Amazon Bulk Operations export. Get campaign, ad-group, target, search-term, and placement performance in one pass.

XLSXDuckDBPareto

4-Month Time Series

Weekly trend tracking, MoM deltas, and Pareto breakdowns from your Daily Performance export. See momentum before it shows up in monthly reviews.

CSVEChartsTrends

Audit Insights

Detects match-type conflicts, auto-converting search terms missing from exact, structural gaps, and zero-sale spend draining the account.

Auto-detectConflictsWaste

Custom Analysis Studio

Drag-and-drop pivot tables, formula columns, computed rules, and charts on any CSV or Excel file. Save templates and reuse them across accounts — like Excel pivots, but built for ad data.

PivotsFormulasTemplatesdnd-kit

SQP Analysis Studio

Multi-period Search Query Performance pulled from TiDB, cross-checked against your live bulk file. Ship defend, offense, and negation actions as one bulk upload.

SQPTiDBDefend / Offense

Compare Periods

Side-by-side comparisons across any two windows. Auto-flags improvements, regressions, and campaign-level deltas — no manual VLOOKUPs.

WoW / MoMDeltasRegressions

Rule-Based Optimization

Author bid, pause, and negation rules. Preview the impact, then export an Amazon-shaped bulk file ready for upload — no reformatting required.

Bid rulesNegationsBulk export

Ads Structure Analysis

Interactive Portfolio → Campaign → Ad-Group → Target tree with @xyflow/react. Pan, zoom, and inspect paused / eligibility status in one canvas.

Tree viewReact FlowStatus

Campaign Builder Studio

Guided 5-step wizard: pick a goal, paste ASINs, choose structure, set bids. Outputs an Amazon-format-perfect Sponsored Products bulk file — free and offline.

5-step wizardASIN pasteBulk output

Forecast & Budget Planner

Holt-Winters projections on your daily history. 30/60/90-day forecasts with weekly seasonality, confidence bands, and what-if bid sliders.

Holt-Winters30/60/90dWhat-if

Bid Simulator

Project bid +/- and pause-bottom-X% scenarios on ACoS, ROAS, spend, and sales — computed from your live data, not a guess.

What-ifElasticityScenarios

ACoS & Profit Calculator

Break-even ACoS, target ACoS, max-bid suggestions, and full unit economics. Pure math — no API, no upload.

Break-evenMax bidUnit economics

Keyword Research Lab

Free suggestions from Amazon Suggest, Google Suggest, and DataMuse. No API keys, no signup. Score, filter, export, send to Campaign Builder.

3 sourcesScoringXLSX export

Listing Optimizer

Score your title, bullets, description, and backend keywords. Char/byte counts, keyword coverage, readability, dedupe — all offline.

Byte countsCoverageReadability

Quick Audit

Four structural sanity checks on your bulk file: duplicate ad groups, orphan keywords, ineligible-product spend, placement bid leaks.

4 checksInstantStructural

Negative Keyword Vault

Cross-session memory of every negative you've ever exported. Auto-fills from Rule Optimization. Search, dedupe, apply universally.

Cross-sessionDedupeUniversal

End-to-end workflow

From bulk file to bid update — five stages

The same data flows through every module. Start at the left, follow the flowing pulse, and you'll see how a raw export turns into an Amazon-ready optimization upload.

Upload

Drop a Bulk Operations .xlsx or Daily Report .csv. Or just hit Launch — sample data is pre-loaded.

Parse

DuckDB-WASM ingests in-browser. Apache Arrow keeps the columnar data zero-copy across modules.

Audit

Insights, conflicts, and Pareto breakdowns generate automatically. Time series, structure, and KPIs render in parallel.

Optimize

Custom Studio for ad-hoc analysis. Rule engine for bid / pause / negate decisions. Compare windows for regressions.

Export

Bulk-shaped .xlsx ready to paste into Campaign Manager. Or export PDFs for stakeholder review.

Engineered for speed & privacy

The stack — and why each piece is here

Frontend

Astro 5 · React 19

Astro ships zero JS for marketing pages; React 19 hydrates only the interactive dashboard islands. Fast TTI, low bundle.

Engine

DuckDB-WASM · Apache Arrow

Columnar SQL inside the browser tab. 149K rows parsed sub-2s, no server round-trip, no analytics calls.

Compute

Polars · mathjs

Backing the Custom Studio's pivots and formula columns. Lazy evaluation keeps even chained formulas instant.

Charts

ECharts · Recharts

ECharts for dense data (time series, Paretos); Recharts for embedded inline KPIs. Both fully theme-aware.

Canvas

@xyflow/react · dagre

Powers the Ads Structure tree. Auto-layout via dagre, pannable / zoomable canvas via React Flow.

Hosting

Cloudflare Pages · D1

Edge-served static + a tiny D1 database for invite-based auth. Demo route is fully zero-auth.

Ready to drive it yourself?

The interactive demo loads with a real 60-day bulk file and 4 months of time-series data. Every module is clickable, every chart is live.

Launch Live Demo Sign In with Invite