2 Replies Latest reply on Oct 8, 2018 2:38 AM by Suganthini Govindhasamy

# How to Calculate ARPU monthly & Annualy

Hi,

I have 3 years of data, each customers has multiple ID numbers. and I want to calculate APRU customer wise annually and monthly.

• ###### 1. Re: How to Calculate ARPU monthly & Annualy

Hello,

In you attachment there is no date field,so not sure, about monthly and yearly calculation.

For ARPU try below logic:

3. ARPU = [customer wise revenue]/[Num of records per customer]

If you have your date column, you can modify the above logic as below, to get monthly and annually data:

Yearly

1. customer wise revenue = {FIXED [Customer],year([Date]):sum([Revenue])}

2. Num of records per customer = {FIXED [Customer],year([Date]):sum(1)}

Monthly

1. customer wise revenue = {FIXED [Customer],DATETRUNC('month', [Date]):sum([Revenue])}

2. Num of records per customer = {FIXED [Customer],DATETRUNC('month', [Date]):sum(1)}

1 of 1 people found this helpful
• ###### 2. Re: How to Calculate ARPU monthly & Annualy

Thanks a lot. It Helped me