Hi to everyone,
I used data.ai API (specifically portfolio/app-store end) to obtain data about all the ratings of an app for the last month but I can’t figure out how to calculate the rating for that period from raw data like this:
I read online that Google is now weighing recent ratings more heavily than historical ratings, so using a simple formula like the following one will return incorrect rating:
RATING NUM = MAX(0,[@[one_star_incremental]])+2*MAX(0,[@[two_star_incremental]])+3*MAX(0,[@[three_star_incremental]])+4*MAX([@[four_star_incremental]],0)+5*MAX([@[five_star_incremental]],0)
RATING DEN=MAX(0,[@[one_star_incremental]])+MAX(0,[@[two_star_incremental]])+MAX(0,[@[three_star_incremental]])+MAX([@[four_star_incremental]],0)+MAX([@[five_star_incremental]],0)
OVERALL RATING FOR LAST WEEK = sum(RATING NUM) / sum(RATING DEN)
Can someone help figuring out what weights should I give to the most recent reviews?
Thank you!
Best answer by rmartinshort
View original