I applied online. I interviewed at Yelp (San Francisco, CA) in Nov 2019
Interview
The first interview was with the recruiter and it was just basic questions, confirming who you are and to slightly expand on your experiences. Once they agree to move forward, they will schedule a technical interview, testing your Excel abilities.
I applied through a recruiter. I interviewed at Yelp in June 2018
Interview
Played e-mail tag with the recruiter for a good 2 months. She would reply back to my email and then I would reply and she wouldn't reply back for 5+ more days at a time. Being a recruiter and sending out responses in a timely fashion is her JOB I don't know what the heck she is doing but worst experience with a recruiter I've ever had. Eventually had the first interview (phone with recruiter) that went well, and then had my second part (excel assessment) a week after. The excel assessment is 45 minutes and they give you a large data set where you have to use formulas/charts to answer the questions. You then have a follow up interview immediately after with one of the managers on the team. I failed this so didn't go onto the third (business case study) interview.
Interview questions [1]
Question 1
Define & calculate a metric that measures retention of users from a review writing perspective.