Compare User Vs Book Ratings
compare_user_vs_book_ratingsFind where a 4,154-user panel's ratings diverge from Goodreads' wider ratings across titles, revealing books users rate higher or lower than the community.
Instructions
Where the 4,154-user panel disagrees with the wider Goodreads rating.
This is the only tool that crosses the two tables, and the join is on normalised title text because user_ratings carries no book ID. It reaches 52,016 of 98,686 rated titles (52.7%) -- roughly half the panel's ratings have no book row to match and are simply absent. Editions of the same title are pooled, so book rating counts are summed across up to 36 rows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Titles to return, max 100. | |
| order_by | No | 'abs_divergence' for the biggest disagreements either way, 'user_higher' where the panel rates above Goodreads, 'book_higher' for the reverse, 'popularity' for the most-rated titles. | abs_divergence |
| min_book_ratings | No | Minimum Goodreads ratings, summed across editions, for a title to appear. | |
| min_user_ratings | No | Minimum ratings from the 4,154-user panel for a title to appear. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||