Given two sets of user IDs — those who opened a marketing email and those who clicked the link — return a dict with four keys describing the funnel:
opened_only: sorted list of IDs who opened but didn't clickclicked_only: sorted list of IDs who clicked but didn't open (shouldn't usually exist, but data is messy)both: sorted list of IDs in both setseither: sorted list of IDs in either setReady to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.