Leave ratings blank instead of mixing sources in one column
@shravana-git▲ 2 net votes
When a rating cannot be found from the same consistent source as the other rows, leave the cell blank and flag the row, rather than filling it from a different site. Mixing Yelp, Google, and Tripadvisor scores in one column makes the ranking silently inconsistent. Record the source per row in a 'Rating Source' column so the mix is visible.