Rating and Reviews Calculation

[Sarah528]

Hi, 

I have 21 reviews with 4.2 average rating, How many 5 star reviews would it take to bring my profile to 4.8?

Thanks in advance!

[Elena87]

@Sarah528 

63 in a row.

PaddyPower is offering 500-1 on this though, but good luck.

[David7870]

I have a 5.0 with 26 reviews then got my first 4.8. It still shows 5.0 though over all. How many dings does it take to lower it? Not that I want it but I wanna prevent it. 

[Sarah977]

@David7870  You can't get a 4.8 rating from a guest. Star ratings are only whole numbers. Where did you come up with the 4.8?

If you averaged out the star ratings they gave you in each category, that's not how it works. Only the separate Overall rating is what Airbnb uses to calculate your listing rating.

[David7870]

Oh I guess it wasn’t a 4.8. It was a five in everything but a 4 in one area only. All the other reviews were a 5 in everything.  

Assuming not all are 5 stars for everything all the time, at what point does it go down? 

[Sarah977]

@David7870  The only rating that Airbnb uses for your listing rating is the "Overall" rating,  which is a rating unto itself that guests mark.

You could have a 4* , or whatever, average rating in each of the other individual categories, like cleanliness, communication, etc, but those don't enter into it. As long as you keep up at least a 4.8 average rating on the Overall rating the guests give, you retain Superhost.

It seems weird, that they wouldn't average the other ratings to arrive at an overall score, but that's how it is.

If a guest gives a 4* Overall rating, you'd see your listing rating go down right away.

[David7870]

Thank you!!  

[Wende6]

I currently have a 4.8 overall.  The last 5 or so reviews have given me all 5 stars.  When does that get taken into account?  Meaning, how many 5 stars do I need to get from the guest, to bump my overall to 5 star?  It appears the guests still book with that rating, but it still bugs me.  One guest gave me 4 stars all around when nothing was wrong.  I asked why she did that and said "I don't rate anything 5 star"  WTF?

[Anna16680]

Same thing happened to me. I had 21 5* then had a guest leave two lovely private notes, all 5 * individual scores and a glowing review but with an overall score of 4*.  We work so hard to make sure the guests are happy with their stay. They are happy according to their review and personal notes, yet will not give us an A? It's hard to figure that one out. But at least I know that we tried our very best. 

[Drew2017]

In order to get 4.8 you would need a ratio of 1:4 4stars:5tars, or 20% 4stars to 80% 5stars.  This ignores any ratings less than 4 such as 1, 2 or 3...  So for every 5 guests, 4 need to give 5 stars to achieve 4.8.

So the algebraic calculation to work out how many 5 star ratings you need to get to 4.8 is:

N(4) + M(5) + 5(X)   = T

       N+M+X

N = number of 4 star ratings

M = number of 5 star ratings

T = Target rating required

X = Unknown variable which we are trying to work out...

NB:-Where something is in a bracket it is multiplied to, e.g. N(4) is N x 4 so if N = 2  it is 2(4) = 8

So, for example, If someone had 50 guests made up of 10 four star ratings and 40 five star ratings that works out at 4.8

Calculation is:

10(4) + 40(5).   =  4.8

         50  

Now if this host wanted a 4.9 rating, the algebraic calculation they would need to do is:

N(4) +M(5) +5(X)    = 4.9

     N+M+X

So, in this example...

N=10 (four star ratings)

M = 40 (five star ratings)

T = 4.9 (target rating)

X = Unknown number of 5 stars we need to get to T (target rating)

So when you plug the numbers in..

10(4)+40(5)+5(X)    =4.9

    10+40+X

Simplifying, we get:

=   240+5X = 4.9

        50+X

=  240+5X=4.9 (50+X)

=   240+5X = 245+4.9X

=   0.1X=5

      X= 5

             0.1

X = 50.     Therefore, in this case it will take 50 5 stars ratings to get from 4.8 to 4.9.

To check the maths you can substitute X for 50 back into the original equation

10(4)+40(5)+5(X)

       50+X

So if X = 50 we get...

10(4)+40(5)+5(50)

         50+50

=  4.9 so we now know that our equation was right and to get from 4.8 based on our number of guests and ratings we need a further 50 five stars.

So if you know the number of guests you have had and their ratings you can calculate it.  I simplified the calculation by ignoring 3 stars etc but it is easy to add to the equation, just create a separate letter for that category.

It's quite late and I've typed this quite fast so I hope i haven't made too many typos but it gives you the gist, and you should just be able to plug whatever your numbers are into the general equation to give you the number of 5 stars you need.

Drew

[Drew2017]

Doing algebra at school seems so long ago...  😊

But the algebraic formula to answer lots of these rating calculation questions is:

N(R)+5(X) = T

     N+X

Where:

N is number of guest ratings you have had so far.

R is your average rating so far

T is your target score

X is the unknown number we are trying to find to give the number of 5 star ratings you need to get to T (your target rating).

@Sarah528 

So to use Sarah's example who said "I have 21 reviews with 4.2 average rating, How many 5 star reviews would it take to bring my profile to 4.8?"

N=21

R=4.2

T=4.8

X=?  this we will find to answer her question...

So plugging these numbers into the equation we get....

21(4.2) + 5X = 4.8

   21+X

=88.2 + 5X = 4.8 (21+X)

=88.2 +5X = 100.8 + 4.8X

=0.2X = 12.6

X = 12.6.

        0.2

X = 63.     This is the number of 5 star ratings you need in a row to get to T (4.8 in this case)

@Wende6 

To get to 5 is impossible, the nearest you can get is 4.999...... (which is more or less 5 really)

So if you are currently at 4.8, and you want to know how many more 5 star rating you need to get to 4.99, you'll need to know the number of guest ratings you have had so far, and let's say you have had 100 guests, for example, then the formula is, as above.

N(R)+5(X) = T

     N+X

100(4.8)+5(X)  =  4.99

     100+X

=480+5(X) = 4.99

     100+X

=480 + 5(X) = 4.99 (100+X)

=480+5(X) = 499 + 4.99X

=0.01X = 19

X=19

      0.01

X = 1900.    So this says to get from 4.8 to 4.99, if we have had 100 guests so far, we need an unbroken run of 1900 5 star reviews. 🤪

To check the sum, we can plug X = 1900 back into the original formula of:

100 (4.8) + 5(X).

       100+X

which becomes

100(4.8) + 5 (1900). 

        100 + 1900

This sum equals 4.99 so we know this is correct.

It looks like a very difficult task to inch up to those levels.  But this is a general equation which can be used for any numbers you have or target you want to set, so you could play with the figures to set something realistic and achievable for you.

Drew