Why I don't trust Trustpilot reviews system
When it comes to make a choice between possible options (for restaurants, hotels, …), we kinda all have this reflex of going to see the reviews on Google. It naturally redirects us to different reviews systems such as Google Maps, Tripadvisor, or … Trustpilot.
When it comes to make a choice between possible options (for restaurants, hotels, …), we kinda all have this reflex of going to see the reviews on Google. It naturally redirects us to different reviews systems such as Google Maps, Tripadvisor, or … Trustpilot.
In this article, I will focus on Trustpilot and I will show you why I don’t trust this platform anymore. It claims to be objective, but in fact, it is far from being so, and let me explain why.
- Backstory
- Goals of the experience
- Gathering the datasets
- Results
- Do it yourself
- Limits
- How to trust back the platform ?
Backstory
Recently, I’ve been looking for a good orthodontics company to straighten my teeth. It’s been 10 years since I wanted to do so, and I was finally ready. There were a lot of possible companies, but there was one that always appeared in my researches. Let’s call it The famous orthos.
The tricky thing is that they had a very good average reviews (4.5/5 at the time). However, when I read the detailed feedbacks, most of them were unsatisfied clients that warned people to avoid their services.
Since then, I wondered : how accurate were those feedbacks ?
To answer that, there will be 3 criterias for a feedback to be accurate (in my personal opinion, it might differ from your perspective):
- There is a feedback comment in the review (at least one character)
- The reviewer has more than one review in his/her profile
- The reviewer is in the same country as me
But now, the most important part of this is : how can I gather the thousands of feedbacks with less effort ?
The answer is : web scraping.
Goals of the experience
Generalization
My actual situation was quite common. Maybe not in orthodontic field, and maybe not for only me. Anyone that wants to challenge reviews they find on Trustpilot should be able to reproduce this experience.
Awareness of companies practices
Companies might use anything they can to gain your trust. In our case, we will see how inacurrate was the 4.5/5 rate in my context.
Reviews sources
This will hopefully make you understand how important it is to check the reviews sources, and to ask yourself how accurate it is to make your own decision.
And of course…
For my personal fun !
Gathering the datasets
If you wonder how technically I proceeded, you can jump to the detailed section about it.
Here are the raw data scraped :
Yeah, the column names are in french. And yeah, the
response date
is always empty, but nevermind, we can go with it !
Interesting right ? Well, we can’t deduce anything at the moment. The most exciting part is now !
Results
Few verifications
To make sure everything worked fine during scraping, let’s check :
- the number of reviews
- overall : 3720 rows in the excel file
- per page : 20 rows in average, except the first one (only 8 of them are displayed in Trustpilot)
- the reviews score histogram : kind looks like the one in Trustpilot
Now that our data look okay, let’s analyze them deeper.
As stated before, these 3 criterias will make a review reliable :
- There is a feedback comment in the review (at least one character)
- The reviewer has more than one review in his/her profile
- The reviewer is in the same country as me
Now we are good to get into serious things !
Reviews for this orthodontics company are not that good
I’m gonna get right to the point : this company is scamming its reviews. Actually, I found so many things but I will just talk about 3 of them.
1. Less than 1% of my three criterias were found
Most of the reviews (99.5% of them) are :
- without any comment written down
- AND from reviewers who use Trustpilot for the very first time
- AND not from France
Visually, that means that the only reviews that I was interested in are the first one among the 7 possible scenarios :
2. From 3700+ reviews to 10 left
If I keep my three criterias, it will only keep 10 reviews out of the 3720 collected. In fact, most of them were complaining. See how false it is to immediately accept the 4.5/5 average score displayed on the company’s Trustpilot page ?
3. They massively imported reviews 3 times
As you can see in previous screenshot, there are 3 picks of good reviews :
- 07 oct 2020
- 21 oct 2021
- 21 dec 2021
They were probably running some commercials at the same period, so they needed to get good reviews asap to make people follow their orthodontics program. How can I be so sure ? Because most of them are the first ratings from reviewers.
FUNFACT : Trustpilot use Lorem Ipsum to hide problematic reviews
In my data :
On the website :
Let’s take another example : Google translation
You can discover it directly at my Tableau Public dataviz, that you may clone for the DIY.
Do it yourself
Here is what you will need :
- Web Scraper extension installed
- Stable internet connection (I mean, of course)
And voilà !
Step 1 : install and open the Web Scraper in your browser console
Step 2 : import a new site map
Step 3 : copy the script
You can get the sitemap JSON content here.
Copy the whole content in the sitemap JSON
field.
And this is how it should look like :
In your case, you will have to change 2 values :
- a) COMPANYNAME
Replace it with the exact name of the company you’re searching for in Truspilot. In my case, it’s The_famous_orthos_com in the_id
, and thefamousorthos.com in thestartUrl
. Then, theSitemap name
will show up automatically. - b) LASTPAGEINDEX
- Go to Trustpilot reviews page :
https://fr.trustpilot.com/review/COMPANYNAME?languages=all&sort=recency
with changing COMPANYNAME with the real name on trustpilot - Replace LASTPAGEINDEX from your sitemap JSON with the last page index, at the bottom of the page. In my case, as shown below, it’s 189.
- Go to Trustpilot reviews page :
Now, click on Import Sitemap
.
Step 4 : run the scraper
Click on Start scraping
, then wait for the magic to happen !
Step 5 : download the data, and make the dataviz
Choose the xlsx format, as it handles comas that may be present in your scraped data.
To make the dataviz, you can duplicate my Tableau Public dataviz and replace the data with your own.
Limits
The more reviews, the more it takes time
For 189 pages scrapped, it took about 30 minutes to gather the whole data. It’s about 4k rows that makes 1Mb excel file.
HTML structures may change
If Trustpilot pages structures ever change, I/you will have to maintain the whole webscrapper script (but it still works in february 2024 though).
Unexpected scraping conditions
- Rate limits : change timeout parameters
- IP bans : too fast, change timeout parameters or reload your box and PC
- Unstable internet connections : make sure you won’t have a service interruption
- PC on standby : if you leave the computer scraping on its own, make sure it doesn’t go on standby mode
Legal uses
If you only use this script for personal purposes, it is totally fine. However, if you want to use those data for commercial purposes, it might be illegal depending on your country law. If you do so, I’m not responsible of any of your acts.
How to trust back the platform ?
Actually, the Trustpilot concept is good : help people to make a decision based on what other people said. The thing is, fake testimonies should be prohibited or at least limited. As a workaround, you can :
- apply the filter to show up only verified reviews
- show only feedback in your language
- call the company to explain reviews you don’t understand (not sure they will respond though…)
I hope this article convinced you to be more aware of reviews sources !
NB : I actually made this experience AFTER signing my orthodontics treatment with The famous orthos 😂 I hope my storytelling made you captivated though !