Bilingual Review Intelligence Platform Development by Gian-Carlo JavierBilingual Review Intelligence Platform Development by Gian-Carlo Javier

Bilingual Review Intelligence Platform Development

Gian-Carlo Javier

Gian-Carlo Javier

ReviewSignal — Bilingual Review Intelligence Platform

Turn a brand's product reviews (Amazon, Shopify, Trustpilot, MercadoLibre) into a decision-ready report — sentiment breakdown, the top recurring complaints and praised features, and 3–5 concrete, quantified recommendations.
Now available in English and Spanish with optimized sentiment models for each language.

Fixed scope, fixed price, delivered in 5–7 days.

What it produces

Sentiment breakdown — overall, by product, and over time
Top 5 recurring complaints and Top 5 praised features (NMF topic modeling)
3–5 recommendations — e.g. "40% of negative reviews center on packaging/staleness — fix the most-affected SKUs."
A shareable client-style HTML report plus supporting CSVs

ContenLanguage | Sentiment Model | Description |

|------|----------|-----------------|-------------| | ReviewSignal.ipynb | English | VADER | End-to-end analysis notebook (English reviews) | | es/ReviewSignal-ES.ipynb | Spanish | Multilingual BERT | End-to-end analysis notebook (Spanish reviews) | | outputs/ | — | — | English reports (HTML, Markdown, CSVs) | | outputs-es/ | — | — | Spanish reports (HTML, Markdown, CSVs) |

Report Outputs (each language)

reviewsignal_report.html — Client-facing report (executive summary + embedded charts + recommendations)
reviewsignal_report.md — Markdown summary
recommendations.csv — Recommendations with focus SKUs and affected product count
top_complaints.csv — Complaint themes + prevalence
top_praise.csv — Praise themes + prevalencecus SKUs | | outputs/top_complaints.csv | Complaint themes + prevalence | | outputs/top_praise.csv | Praise themes + prevalence |

Data

Demo data is the Amazon Fine Food Reviews dataset (~568k reviews), pulled via the Kaggle API (kagglehub):

The loader normalizes everything to a platform-agnostic schema (platform, product_id, user_id, rating, timestamp, title, text), so swapping in a Shopify / Trustpilot / MercadoLibre export is a one-line mapping change. kaggle auth login # Configure Kaggle API credentials

Then open ReviewSignal.ipynb and run all cells. Set SAMPLE_SIZE = None in the config cell to run on the full dataset (the default samples 80,000 reviews for responsiveness).

How it works

Sentiment — star ratings (1–2 negative, 3 neutral, 4–5 positive) plus a VADER compound score on the review text for time trends.
Topics — TF-IDF + NMF run separately on negative and positive reviews; each review is assigned its dominant theme and the theme's share is its % of that class.
Product names — the raw data only has ASINs, so a readable name is derived from the distinctive TF-IDF terms in each product's own reviews.
Like this project

Posted Jul 10, 2026

Developed a bilingual review intelligence platform for sentiment analysis.