Scenario $2$

Next, assume that WDRP has been approach ed by several leading streaming services to consider advertising before a stream starts. There are generally three types of streams shown on these services: $1)$ Acquired shows from networks, $2)$ Movi or $3)$ Original progran ining we produce.

Because WDRP wants to be associated with positively perceived content, you have been asked to look at public sentiment for each of the most popular streaming programs to try and see which ones give us the most potential engagement and positive sentiment$.$

We will use "Net Promoter Score" $($NPS$)$ as our metric, to measure the strength of positivity for content. First you will need to calculate the Positive Sentiment Score, then the Negative Sentiment Score, and finally, the Net Promoter Score $($NPS$).$

Positive$/$Negative Sentiment scores

You create positive and negative scores based on a percentage.

To create the Positive Sentiment Score, you take the Positive Mentions value $($From Column I$)$ and divide it by the sum of the Positive, Neutral, and Negative ention values $($From Columns I to K$).$

$($Note that this is different from "Total Engagement" so don't use that$).$ Do this for the negative sentiment as well but use Negative Mentions instead of P itive $($Column K instead of Column I$).$

Finally, be aware, these scores are on a per$-$row basis. You do not select any other values than those on the row you are working with.

Net Promoter Score

To get the Net Promoter Score $($NPS$),$ start with positive sentiment percentage and subtract the negative sentiment percentage from it$.$

Next, multiply that number by $100.$ The final number is your NPS$.$

As an example, if you get a $\mathrm{.}06$ difference, the NPS score is $6.($Multiplying a percentage by $100$ turns it into a number value$).$

$38$ words

Focus