Google BigQuery Ranking Order with Customer Hits Problem: A Solution for Consecutive and Non-Consecutive Visits

Combining and Ranking Rows with Columns from Two Matrices in R: A Step-by-Step Solution