adds db association between clients and client analysis