A review signal: what 1,120 one and two-star reviews say about 30 UK energy suppliers, and who answers them
Описание и применение
Автоматизированный рецепт сбора и анализа недавних отзывов с одной и двумя звёздами от 30 поставщиков энергии в Великобритании, выявляющий основные темы жалоб и показатели отклика.
Задача
Collect and analyze recent one- and two-star Trustpilot reviews for 30 UK energy suppliers to identify common complaint themes and response rates.
Результат
The automation produced 1,120 one- and two-star reviews, revealing 43% about contact issues, 30% billing, and 28% smart meter problems. 86% of reviews older than three days received a reply, with a median reply time of 15 hours.
Рабочий процесс
- 1. Define supplier list and create recipe-3-companies.txt
- 2. Run Apify actor trustpilot-reviews with snapshot parameters (90 days, 100 reviews per company, includeCompanyInfo=true)
- 3. Run actor with complaint pull parameters (30 days, stars 1-2, 100 reviews per company, onlyNew=true)
- 4. Export results to CSV/JSON
- 5. Apply keyword matching script (recipe-3-analysis.py) to classify reviews into complaint themes
- 6. Aggregate counts and percentages per theme
- 7. Calculate response metrics (reply rate, median reply time)
- 8. Generate summary tables and visualizations
Доказательства
We built it for 30 UK energy suppliers on 15 October 2026 with our trustpilot-reviews Actor on Apify.
The complaint pull: 1,120 one and two-star reviews from the last 30 days, at 28 of the 30 suppliers, in 3 minutes 53 seconds, for $0.28.
43% of the 1,120 are about getting through to someone: hold times, call-backs that never come, emails with no answer.
86% of the one and two-star reviews that were at least three days old had a reply from the company.
- Дата записи: 2026-10-20T14:56:06.842Z