Adjust overall ratings
Amrayu78
Not sure if this is doable, but we'd like to change how Overall Ratings for Titles are calculated.
I feel like ratings by users who do not completely watch the series skews the overall ratings. I'd like to have those excluded.
Here's the logic:
If a Drama/Movie/SP is not marked as "Completed" on the WatchList
AND if the title is still airing (is in the current season),
it shouldn't be counted in the Overall Rating.
Ratings will only count under these conditions:
- Drama/Movie/SP is marked as "Completed" or "Dropped" in the Watchlist
- Has completely aired (for Dramas and SPs it has an END date + total episodes added)
Users can still give a rating if the Status is "In Progress", but if it's "In Progress" their rating won't be included in the Overall Rating.
Overall Rating = The one that shows everywhere on the site (below the title), in Search, in Watchlists.
I'd also like to add some additional wording on the Reviews tab. Please see the attachment.
Amrayu78
Max Romanchenko New task for you!
Max Romanchenko
Amrayu78 Hi, Duong, sorry for the slow reply!
I went ahead and implemented the new rating logic. Reviews from users who haven't completed or dropped a title won't count toward the Overall Rating anymore. They'll still show up in the Reviews tab but grayed out.
I have questions:
- Can users leave a rating without adding the title to their Watchlist?
Currently yes - but under the new logic, that rating will never count toward the Overall Rating since it requires Completed or Dropped status. Should we keep it this way or block rating if the title is not in the Watchlist?
- Should I recalculate all existing ratings or only apply the new logic going forward?
- Also there are still some inconsistencies from the MDL import on some titles (ratings and review counts are off, please see screenshots). It would be good to sort that out first, otherwise any recalculation won't be accurate.
Amrayu78
Max Romanchenko
- Can users leave a rating without adding the title to their Watchlist?
Currently yes - but under the new logic, that rating will never count toward the Overall Rating since it requires Completed or Dropped status. Should we keep it this way or block rating if the title is not in the Watchlist? >>> Yes, let's keep it this way. They may eventually add it to their watchlist.
- Should I recalculate all existing ratings or only apply the new logic going forward? >>> Yes. I feel that these one-off ratings are skewing the overall ratings. It's a bit unfair to drama viewers to count these.
- Also there are still some inconsistencies from the MDL import on some titles (ratings and review counts are off, please see screenshots). It would be good to sort that out first, otherwise any recalculation won't be accurate. >>> I agree. I've not had time to import more of these into the database because it's such a resource heavy project. I'm not sure if you have a better way of handling these imports. If you want me to hand it off to you, let me know because aligning the MDL titles with our titles was a time-consuming.