Want to ace your data science interview? 🚀 85% of successful candidates practice with real interview questions. Explore the ones companies actually ask: www.interviewquery.com/questions?
There's a doubt I have. Shouldn't we have only considered those notifications that were sent for a product id, and id the user clicked them then we can attribute the purchase to that notification. We can't attribute a purchase to a notification not intended for the product
Would've been simpler if: 1. In a first cte, grab attribution to all purchases AND their notif type in a simple left/inner join 2. Aggregate all the notifs sent by type and left join to the cte to get conversions by notif type This get get to the conversion by type quicker and more efficiently (less joins)
Want to ace your data science interview? 🚀
85% of successful candidates practice with real interview questions.
Explore the ones companies actually ask: www.interviewquery.com/questions?
thank you for having me on your channel team!! great interview experience & platform to code on 🙂
There's a doubt I have. Shouldn't we have only considered those notifications that were sent for a product id, and id the user clicked them then we can attribute the purchase to that notification.
We can't attribute a purchase to a notification not intended for the product
It has not considered product_id?
Hi,
can you please share the scripts and what is the output needed
Loved the approach!!
Glad you liked it!
Would've been simpler if:
1. In a first cte, grab attribution to all purchases AND their notif type in a simple left/inner join
2. Aggregate all the notifs sent by type and left join to the cte to get conversions by notif type
This get get to the conversion by type quicker and more efficiently (less joins)