ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCV
1
2
3
4
5
6
7
 💡Please make a copy first. Do not alter the functions, cells or columns and
only enter data into the cells that have a light blue background.

This tool aims at helping you to decide on initial rewarding parameters by giving you an impression of the revenue & cost dynamics and ROIs of Cello's referral program.

Disclaimer: The data below is based on real-world, state-of-the-art referral programs that use best-in-class integrations and activations through Cello. Not every program performs equally well in every stage of the referral funnel. Each product and referral program is unique and requires appropriate adjustments.
8
9
Product1) Please specify your product specifics

The first part of the calculator consists of providing some details of your product. You can pick the Go-to-Market (G2M) strategy you have, the approximate monthly Average Revenue per Customer (ARPA) and the number of Monthly Active Users (MAUs) 		Your Input
10
a) Please pick your current G2M strategyG2M​
changes Cello Benchmarks
11
b) Please pick your current mtl. ARPA. Based on this value we will provide benchmark dataCurrent mtl. ARPA*​
changes Industry Data
12
c) Please specify the number of your Monthly Active Users (MAUs)MAUs
13
d) How much is your user base expected to grow year over yearYoY Expected
User Growth
14
*we use € as currency, you can take the equivalent in $
15
16
2) Please specify your referral program details

The second part consists of your referral program details. Based on your input data above we will provide you benchmark recommendation, but you are free to select the parameters that best suits your product.
17
Your InputIndustry Data
18
Referral Programa) Please specify your monthly Average Revenue Per Customer (ARPA)Monthly ARPA
19
b) Please specify the % of your ARPA you would like to reward to the referrer% Referrer
20
c) Please specify the Reward Cap until when you want to reward the referrerReward Cap
21
d) Please specify whether you would like to provide a Event Based Reward (e.g. for qualified leads, for demo bookings). This is mostly only done when you have a demo-only G2M strategyEvent Based Reward
22
e) Please specify the % discount a referee should get on the monthly subscription. % Referee Discount
23
f) Please specify the duration of the referee discount
Period Referee Discount
24
25
26
27
28
3) Your approximate Referral Program Results (monthly)
The below will provice you an idea of how the program will perform. The numbers are impacted by the G2M you selected which have an influence on the Cello Benchmark. It considers a good and a great scenario. Please consider that his calculation is based on a linear growth scenario.
29
30
Predicted Monthly ResultsCello Benchmarks
31
AverageGreatBest-in-ClassAverageGreatBest-in-Class
32
ResultsThe number of users who will open your program Monthly Active Users000Activation Rate
33
The number of users who will open and share a referral linkSharing Users000Sharing Rate
34
The number of new users who will click the referral linkUnique Views000Unique Views
35
The number of new users who will sign-upNew User Sign-Ups000Sign-Up Rate
36
The number of new users who purchased a paid plan New User Purchases0.00.00.0Purchase Rate
37
The new generated Monthly Recurring RevenueMRR€0€0€0
38
39
40
41
Results Average
(ROI can be also interpreted as LTV:CAC ratio)		Total Revenue over 7 years via referralsAvg LTV:CAC over 7 years
42
€00.00
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
Results Great
(ROI can be also interpreted as LTV:CAC ratio)		Total Revenue over 7 years via referralsAvg LTV:CAC over 7 years
72
€00.00
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100