Calculate the number of favorable comments above 7 points needed for each platform, which can be improved to 8 points

Report about Serene Vegas Boutique Hotel Las Vegas

Specify target websites for statistics, including booking, Expedia, Agoda and Ctrip.

In terms of monthly statistics, from August 2022, the number of favorable reviews with more than 7 points and negative reviews with less than 7 points for each of the four platforms in each month shall be classified. (Excel can be used to represent the following content), for example:

In August, Booking received 10 comments in total, among which 4 comments were rated more than 7 points, praising hotel staff for their professionalism. 3 reviews, 7 or less, mainly cleanliness issues.

In September, Booking received a total of 20 comments, among which XXX scored more than 7 points… .

August, Expedia, total XXX, of which, XXX,

In September, Expedia, total XXX, of which, XXX,

And so on, each platform does the same statistics.

Calculate the number of favorable comments above 7 points needed for each platform, which can be improved to 8 points (Ctrip5 points).