Background:
JobMatch Alerts, a job search company, is sending job alert emails to its members, so that they can apply to the job openings that match the keywords they are interested to. The member first set keywords to trigger the alert, and emails will be send to them once there are matching jobs.
The data set we will be analyzing consists of three tables:
- email_responses. Logging the email id, timestamp and action.
- emails. Logging the email id, timestamp, title, login info and member id. We are specifically interested in emails titled ‘T plus N’, which are emails that recommends job openings to users.
- members. Logging the member id, date of registration, email domain, first name, city, state, zip, degree_level, graduation year, pcp_score, keyword that the member set alerts for.
Please analyze the data and summarize your observation. What recommendation can you give to the product managers and the engineers of the recommendation system?
The data you will get:
All company names in this question are fictional.