1. Amazon
Case 01 / Decision-support application
Evaluate search-term wins and losses
with repeatability and profitability in mind.
A decision-support app that cleans and aggregates Amazon Ads search-term data with Python, then connects repeat evaluations, key-metric visualizations, and recommendations for the next test. The public demo uses fictional data only.
01 / Decision overview
See wins and losses with their supporting evidence on one screen.
Rather than ranking targets by purchases in the latest period alone, the dashboard combines repeat counts, score, click thresholds, and ROAS in one decision view.
- Filter by brand, ad type, evaluation period, appeal theme, or branded keyword.
- Review 60 wins, 45 losses, and 15 pending decisions from the same population.
- The public demo contains only fictional brands, products, and figures.
02 / Aggregation foundation
Standardize the time period and comparison dimensions before interpreting the numbers.
Before comparing brands or ad types, recalculate sales, spend, efficiency, and sample sizes for the selected period using consistent rules.
- Put ad-attributed sales, ad spend, ROAS, and purchases in the primary view.
- Review clicks, CVR, CPA, CTR, and CPC using the same period definition.
- Recalculate rates from totals instead of taking simple averages.
03 / Appeal and keyword analysis
Group search terms by appeal theme while retaining a path back to individual keywords.
Compare semantically related search terms by appeal theme, then drill down to an individual keyword, product target, or campaign proxy when needed.
- Separate four levels: appeal themes, natural-language keywords, SP/SB product targets, and SD proxies.
- Compare the latest evaluation with all-time wins, losses, and pending decisions in one row.
- Display evaluation groups separately so winning and losing appeal themes are not mixed.
04 / Evaluation criteria
Do not mistake one lucky week for a winning pattern.
Instead of deciding from the latest period alone, combine click volume with repeat performance over time and separate initial from repeat evaluations.
- Set minimum clicks, benchmark CVR, and winning/losing ROAS thresholds by brand and ad type.
- Keep cases with insufficient data pending instead of forcing a win or loss.
- Flag targets with high ROAS but few purchases for further validation.
05 / Long-term trends
Separate efficiency from scale to assess whether a change is sustained.
Start with long-term trends by brand, then review ten key metrics and the ROAS-versus-click distribution.
- Keep brand, ad type, and start and end dates synchronized across views.
- Compare ROAS, CVR, CTR, CPA, and CPC along the same timeline.
- Recalculate from actual sales, spend, clicks, and purchases instead of relying on averages alone.
06 / Change detection
Review alerts for all ten metrics in one place.
Each card shows the latest value, week-over-week change, and whether it is within range; color and sparklines highlight changes that need review.
- Review sales, spend, outcomes, traffic, and efficiency in separate charts.
- Compare drops in ROAS or CVR and rises in CPA against their thresholds.
- Pair color with values, signs, and labels so meaning does not depend on color alone.
07 / Next-test planning
Prioritize what to test next based on expected learning, not predicted wins.
Score candidates for scaling delivery, adjusting bids, or continued observation based on changed and sustained evaluations.
- See this week’s changes beside the proposed actions and trace the supporting evidence.
- Show priority, action, target, and repeat evaluation in the same row.
- Exclude targets without a product mapping or those that require manual review from recommendations.
08 / Implementation and operations
Reproduce the same evaluations by replacing the Excel file.
Raw data is cleaned and aggregated with Python, combined with semantic labels in Excel, and loaded in the browser. Switching views does not trigger another analysis.
- Python makes column validation, type conversion, aggregation, evaluation, and joins reproducible.
- GPT supplies semantic labels such as appeal themes; numeric evaluations remain in explainable rules.
- Excel is processed in the browser and is not sent to an external server.