DhPandya's avatar

Calculate the ratio of the customer registraion.

Hi everyone, Can anyone please guide me in calculating the customer registration ratio? Please have a look at this image. https://ibb.co/xJgXjsd Basically, I have to calculate the percentage of whether the customer registration is up or down.

Thank you so much for your attention and participation.

0 likes
9 replies
tangtang's avatar

@dhpandya

calculate the percentage of whether the customer registration is up or down

this can be simple or more complex depend on what the requirement you need, or how the result you need too.

for example :

the apps have the standart for customer registration like if total customer registered in one day is 40 so it will be count as 100% in percantage. but if only 20 customer has registered on that day, the percentage is only 50%. why ? because the apps have standart 40 customer is 100% in percentage.

but if the apps dont have standart for how to calculate the percentage, you can count percentage from the last day.

for the fisrt day app has 20 customer, and the second day 5 customer has rgistered, so total customer is 25.
to calculate the customer registration rate as a percentage, use the formula:

Customer Registration Rate (%) = (Number of Customers Registered / Total Number of Customers) * 100

Customer Registration Rate (%) = (5 / 25) * 100 = 20% // this can be state as down

so the percentage registered customer is 20% based on how many customer a day before.

or another sample

for the fisrt day app has `20` customer, and the second day `40` customer has rgistered, so total customer is `60`

Customer Registration Rate (%) = (40 / 60) * 100 = (2/3) * 100 ≈ 66.67% // this can be state as up

so the percentage registered customer is 66.67% based on how many customer a day before.

but there is no valid formula for this, you can use custom formula depend on what the result you need.

1 like
DhPandya's avatar

@tangtang It is making sense. But How can I know that the calculated percentage is up or down? Or everytime I have to calculate for the past two days?

tangtang's avatar

@DhPandya

not need everytime I have to calculate for the past two days?, if you have other static standart for the percentage.

percentage always need what is compared for. like 100% from what (can be 100% from 12 or 15 or another base for this percentage).

tisuchi's avatar

@dhpandya The word ratio is subjective.

It depends on what kind of visitors are coming to your site, and what they see on your page/site. Based on my knowledge, there should not be any certain standard ratio to convert your visitor to customer. But you increase this number by providing the right content/server to the visitors.

1 like
DhPandya's avatar

@tisuchi I've web application for a payment. Where I want to calculate the whether my app is getting positive registration or not. Like for the first day it has 50 customer registration and the day after it has 30 customer. So I want to calculate that percentage .

tisuchi's avatar

@DhPandya It's a different story then!

Since you have data already, simply calculate the registration percentage based on the date.

What are you struggling for?

1 like
DhPandya's avatar

@tisuchi Calculating the user percentage is what I'm struggling with.🙂 I apologize if my question was not clear for understanding. I have to display the percentage as described in the image. https://ibb.co/xJgXjsd

Snapey's avatar
Snapey
Best Answer
Level 122

i would take the previous 7 days as a rolling average ( add up all data from 7 days and divide by 7), then you can compare the current day to the rolling average

The reason to do this? suppose its a b2b app. Saturday and Sunday might be much lower leading to monday having a meaningless figure like 700%. The longer period you can average the better.

But, Its totally up to you how you structure it

2 likes
DhPandya's avatar

@Snapey Your idea seems good. Could you please add one dry run example? My Aim is that for the first 7 days, I have a total of 150 customers, but next 7 days I have 100 customers. So Now this is a down percentage and I want to calculate it and want to show it on the admin dashboard as mentioned in this screenshot. https://ibb.co/xJgXjsd

Please or to participate in this conversation.