There are times when you need to transform a variable to be able to better answer a question or to gain additional insight. In this recipe we will calculate the ratio of donors to total prospective donors. The data set already has a donate/not donate variable in the form of
TARGET_B. We will calculate something similar for all of the campaigns, allowing us to present results on a line chart and look at trends.
We will start with the
Conversion Rates.str stream.