This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a CRM Data Analyst at Marriott. The marketing team is preparing a guest outreach campaign and needs a clean contact list. Many guest records have missing email addresses or phone numbers. Your task is to fill in the missing values with placeholders, create a combined full name column, and flag which guests had complete contact information before any filling was done. This flag will help the team prioritize guests with verified contact details.
You are a CRM Data Analyst at Marriott. The marketing team is preparing a guest outreach campaign and needs a clean contact list. Many guest records have missing email addresses or phone numbers. Your task is to fill in the missing values with placeholders, create a combined full name column, and flag which guests had complete contact information before any filling was done. This flag will help the team prioritize guests with verified contact details.