def consolidate_conversion(x):
    """
    Collapses the conversion status to Yes or No.
    """
    xl = x.str.lower()
    if any(xl.str.startswith('purchase')) or any(xl.str.startswith('converted')) or \
            any(xl.str.startswith('y')) or any(xl.str.startswith('processed')) or \
            any(xl.str.startswith('payment_completed')) or any(xl.str.startswith('initiated')) \
            or any(xl.str.startswith('pdf_error')) or any(xl.str.startswith('toprocess')) \
            or any(xl.str.startswith('delivered')):
        return 'Y'
    else:
        return 'N'