Understanding the Contract and Payment Patterns in Tableau Story

In this segment, Favio will create some visualizations on the contract and the payment patterns, which can be presented to the senior management to help them understand these variables better. 

In the forthcoming video, Favio will create a visualization on the contract pattern with respect to the churn, total charges and tenure. Let us watch the video.

So, in the video, Favio created a visualization on the contract pattern. The visualization is shown below for your reference.

The conclusions that can be drawn from this visualization are as follows:

• Customers with the highest LTVs are the ones that are using bank and credit card transfers (automatic transfers) for making their payments.
• Customers who used automatic payment methods showed a tendency to be with the company longer as compared with those who used non-automatic payment methods.
• People are more likely to not churn if they use non-automatic payment methods, such as mailed cheques and electronic cheques; however, this does not contribute much to LTV.

In the next segment, Favio will create some simpler plots to visualise the lifetime value.

So, in the video: 

• The total charges are significantly higher for people who are on a 2-year contract than those who are on a month-to-month contract.
• People who stayed with the company had mostly subscribed to the 2-year contract as compared with people who had left. 
• People who left the company were paying significantly higher monthly charges than those who did not leave. Therefore, although this might be good for an LTV, it may not be as good for the churn scenario of the company.

Thus, this plot shows the clear picture that people are likely to stay with the company for a much longer period and contribute more to it in terms of LTV if they have subscribed to a 2-year contract.

In the next video, Favio will create a visualization to understand the payment patterns in the company. Let’s watch the video.

So in the video, Favio created a plot that can help you get a good understanding of the payment patterns of the customers with respect to their tenure and average charges. The visualization is shown below for your reference.