Assign deterministic per-segment activity ranks with SQL ROW_NUMBER ordered by engagement score and username.
