Capstone · Marketing team sending a product announcement
Prepare a consented audience for an email campaign
Marketing wants to send an announcement to opted-in members in two segments. The member export has padded emails, opt-in answers in many spellings, customer keys that are blank for some orders, and regions left empty.
Produce an audience list that contains only clearly opted-in members with valid emails, joined to their segment without matching blank keys, plus a list of members who need a consent confirmation.
Checkpoints
1. Emails trimmed and lowercased; dots and plus tags kept.
Normalize emails under a declared policy2. Opt-in parsed from approved spellings; missing never means yes.
Keep identifiers as text and parse yes/no flags3. Segments joined without matching blank or missing keys.
Join orders to customers without matching blanks4. Unknown regions labelled for reporting; no invented values.
Label unknown categories, keep missing numbers missing
Final quality report
Write it in your private notes below (saved to your account) or in your own document. It isn't auto-graded; use it to practise the handoff interviewers ask about.
- Audience size by segment and how many were excluded for each reason.
- Why a missing opt-in is treated as not consented.
- Members needing consent confirmation and how to contact them lawfully.
- Fields the signup form should validate.
Sign in to bookmark this and keep private notes.