updated queries for guest conversions