Given a table that each day shows who was active in the system and a table that tracks ongoing user status, write a procedure that will take each day's active table and pass it into the ongoing daily tracking table. Possible states are: * user stayed (yesterday yes, today yes) * user churned (yesterday yes, today no) * user revived (yesterday no, today yes) * user new (yesterday null, today yes) Note: you'll want to spot and account for the undefined state.
Given a table containing date, post_id, relationship (e.g. Friend, Group, Page), interaction (like, share etc.) and a table containing poster id and post id, calculate: how many likes were made on friend posts yesterday
Basic SQL (don't remember specif question)
Our teams have developed an algorithm to detect spams and classify them at the bottom of the newsfeed. How to check if it works? If it's profitable?
How to analyze the network on Facebook,
I'm not allowed to share
How to identify close friends on social media?
Using a hypothetical schema from the portal product, identify the number of unique active users for a given country on a given day.
Q: Saying FB has only Comment and Like. How you would build an experiment to check if other emotions bottom can be added? (care, sad exc.). How you would build an A/B test?
SQL - joins, group by, date manipulation Business case - a mix of open ended questions framed like "how would you see if xyz is a good idea" and more specific questions about metric movements and experimentation
Viewing 1051 - 1060 interview questions