prep work for community ranking