Customer Retention Rate Concepts

The video tutorial explains the concept of customer retention rate, demonstrating both manual and dynamic calculations. It starts with a basic example of calculating retention rate manually, then progresses to using measures for dynamic calculations. The tutorial covers creating subtables and grouping data to find repeat customers, and concludes with displaying the retention rate dynamically using a row card.

What is the basic formula for calculating customer retention rate?

• Total customers divided by number of new customers

• Number of new customers divided by total customers

• Total customers divided by number of repeat customers

• Number of repeat customers divided by total customers

In the given example, how many customers visited the store only once?

• 20

• 980

• 13

• 1000

What is the total number of customers in the manual calculation example?

• 1000

• 780

• 793

• 980

How many customers are identified as repeat customers in the manual calculation?

• 13

• 793

• 1000

• 780

What is the purpose of using a matrix in calculating retention rate?

• To figure out the retention rate for customers

• To determine the average order value

• To calculate total sales

• To identify new customers

What does a distinct count of order IDs help determine?

• Total sales revenue

• Total number of customers

• Number of orders placed by a customer

• Average order value

How many customers visited the store just once in the matrix example?

• 20

• 13

• 980

• 793

What is the retention rate calculated using the matrix example?

• 99.12%

• 97.45%

• 95.67%

• 98.36%

What is the first step in using measures to calculate retention rate?

• Calculate total sales

• Determine average order value

• Write a measure for distinct count of orders

• Identify new customers

What is the criteria for identifying repeat customers using measures?

• Distinct count of orders is less than or equal to one

• Distinct count of orders is equal to one

• Distinct count of orders is less than one

• Distinct count of orders is greater than one