Watershed is a media services company that provides online streaming movie and television content. As a...

Transcribed Image Text:

Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market of streaming service providers, Watershed is interested in proactively identifying will unsubscribe in the next three months based on the customer's characteristics. For a test set of customers, the file Watershed contains an indication of whether a customer unsubscribed in the past three months and the classification model's estimated unsubscribe probability for the customer. In an effort to prevent customer churn, Watershed wishes to offer promotions to customers who may unsubscribe. It costs Watershed $10 to offer a promotion to a customer. If offered a promotion, it successfully persuades a customer to remain a Watershed customer with probability 0.6, and the retaining the customer is worth $70 to Watershed. Assuming customers will be offered the promotion in order of decreasing estimated unsubscribe probability; determine how many customers Watershed should offer the promotion to maximize the profit of the intervention campaign. Compute the average profit from offering the top customers a promotion as: Profit = Number of unsubscribing customers in top >> x (P(unsubscribing customer persuaded to remain) × (70-10) + P(unsubscribing customer is not persuaded) x (0-10)) + Number of customers who don't intend to unsubscribe x (0-10) *The maximum profit of $_ occurs when SHOW STEPS in Excel Partial Data Info Customer Unsubscribe? 57 111 141 158 180 119 140 0 0 1 0 1 1 1 customers are offered the promotion. Probability of Unsubscribe 0.99 0.99 0.99 0.99 0.99 0.98 0.98 Watershed is a media services company that provides online streaming movie and television content. As a result of the competitive market of streaming service providers, Watershed is interested in proactively identifying will unsubscribe in the next three months based on the customer's characteristics. For a test set of customers, the file Watershed contains an indication of whether a customer unsubscribed in the past three months and the classification model's estimated unsubscribe probability for the customer. In an effort to prevent customer churn, Watershed wishes to offer promotions to customers who may unsubscribe. It costs Watershed $10 to offer a promotion to a customer. If offered a promotion, it successfully persuades a customer to remain a Watershed customer with probability 0.6, and the retaining the customer is worth $70 to Watershed. Assuming customers will be offered the promotion in order of decreasing estimated unsubscribe probability; determine how many customers Watershed should offer the promotion to maximize the profit of the intervention campaign. Compute the average profit from offering the top customers a promotion as: Profit = Number of unsubscribing customers in top >> x (P(unsubscribing customer persuaded to remain) × (70-10) + P(unsubscribing customer is not persuaded) x (0-10)) + Number of customers who don't intend to unsubscribe x (0-10) *The maximum profit of $_ occurs when SHOW STEPS in Excel Partial Data Info Customer Unsubscribe? 57 111 141 158 180 119 140 0 0 1 0 1 1 1 customers are offered the promotion. Probability of Unsubscribe 0.99 0.99 0.99 0.99 0.99 0.98 0.98

Answer rating: 100% (QA)

To determine the maximum profit for the intervention campaign we need to calculate the profit for different numbers of customers offered the promotion and find the number that yields the highest profi... View the full answer