Task #76

Customer retention

A product analyst is calculating retention: the share of a month's new customers who came back for another purchase 1, 2 and 3 months later.

  1. In G2:I7, calculate the share of returning customers out of the new customers of their month.
  2. Highlight in red the shares below 20%.
Task #76
Customer retention

A product analyst is calculating retention: the share of a month's new customers who came back for another purchase 1, 2 and 3 months later.

  1. In G2:I7, calculate the share of returning customers out of the new customers of their month.
  2. Highlight in red the shares below 20%.