Скачать с ютуб Use SQL to Analyze the Impact of Upsell Marketing Campaigns (with American Express PM) в хорошем качестве

Use SQL to Analyze the Impact of Upsell Marketing Campaigns (with American Express PM)

Don't leave your SQL interviews to chance. Sign up for Exponent's SQL interview course today: http://bit.ly/3zlMpdE In this SQL mock interview, a product manager demonstrates how to use SQL queries to help executives of an unnamed company understand the impact of their upsell marketing campaigns. Watch as he explains the definition of an upsell and walks through several examples of how to analyze the numbers behind these campaigns. If you're interested in data analysis or marketing strategy, this video is for you! Chapters (Powered by ChapterMe) - 00:00 - Data scientist asks for average duration of upsell campaign 00:16 - Data tables for periodic marketing campaigns 01:07 - Data scientist asks for average duration of upsell campaigns 03:29 - SQL query lists campaign users eligible for upsell 04:12 - Labeling data for upsell campaigns efficiency 04:59 - Trans users join transactions in campaigns 06:50 - JOIN transactions, IDs, campaigns, eligibility 10:21 - Un upsell campaign eligible users 11:52 - SQL query ranks products that benefit best 12:51 - Absolute difference between upsell and non-upsell campaigns 16:14 - SQL query pairs product purchases with upsold items 17:38 - Transaction IDs for trans user campaigns 22:39 - Tran user campaign IDs and purchases 27:12 - SQL query to identify 10 most successful campaigns 29:59 - Noncampaign transactions for upsell campaigns 33:32 - Data structure daily transactions, campaigns, successful campaigns 37:26 - Marketing problems solved, preparation tips for candidates 39:01 - Discussing upsell campaigns in interview context 40:22 - Tips for future interviews 👉 Subscribe to our channel: http://bit.ly/exponentyt 🕊️ Follow us on Twitter: http://bit.ly/exptweet 💙 Like us on Facebook for special discounts: http://bit.ly/exponentfb 📷 Check us out on Instagram: http://bit.ly/exponentig 📹 Watch us on TikTok: https://bit.ly/exponenttiktok ABOUT US: Did you enjoy this interview question and answer? Want to land your dream career? Exponent is an online community, course, and coaching platform to help you ace your upcoming interview. Exponent has helped people land their dream careers at companies like Google, Microsoft, Amazon, and high-growth startups. Exponent is currently licensed by Stanford, Yale, UW, and others. Our courses include interview lessons, questions, and complete answers with video walkthroughs. Access hours of real interview videos, where we analyze what went right or wrong, and our 1000+ community of expert coaches and industry professionals, to help you get your dream job and more! #sql #sqlinterview #datascience #businessanalyst