Meta Product Sense

Product Sense Case: This team has a 1:1 call feature enabled and wants to enable a new feature video conference. Based on the information available for 1:1 calls, define the success for the video conference feature.


/
This table has 1 row per unique call.
(i.e. Assume it only includes calls between 2 individuals)


Table name: video_calls
+-----------------+---------------+---------------------------------------+
|  column         |  data_type    |  description                          |
+-----------------+---------------+---------------------------------------+
|  caller         |  BIGINT       |  ID of person who made the call    |
|  recipient      |  BIGINT       |  ID of person who was called       |
|  ds             |  STRING       |  date of the

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Popular Interview Questions from Top Companies

rom video_calls where date_diff(ds,today()) = 1) then user_id
when user_id in (select recipient from video_calls where date_diff(ds,today()) = 1) then user_id
else null end)/count(user_id))*100.0    per_of_dau_user
from dim_all_user dau
where date_diff(ds,today()) = 1 and country = 'fr' and dau_flag = 1


(is_france & is_dau_yesterday & is_video_call) / (is_france & is_dau_yesterday)


video call feature
-

caller   ds #recipient age-group country
123         10          25-30     us