Accounts
6
At risk
2
Revenue at risk
$134,000
Customer Health Scorecard
Score each account on usage, support, relationship and payments to spot churn risk early.
SpreadsheetAccounts & CustomersFree
Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.
Shown with sample data
Track every referral from invite to first purchase, calculate rewards automatically and see what you owe and when.
A refer-a-friend programme only works if rewards are fair and paid on time. Log each referral with the referrer, the new customer, status and first order; the sheet applies your rules from the Settings sheet (flat reward plus a percentage, a cap, a minimum order and a refund window), shows which rewards are eligible, what is owed now, conversion rate, referred revenue and the true cost per acquired customer.
Many businesses spend 10–25% of a customer’s first-year gross profit on the referral reward. Start with what a customer is worth to you and what you currently pay to acquire one through ads, then set a reward that is clearly cheaper but still motivating.
After the friend’s first order has passed your returns or refund window, so you are not paying for orders that are later refunded. The sheet holds rewards as In refund window until then.
Track the referral conversion rate (purchases ÷ referrals), referred revenue and cost per acquired customer (rewards plus friend discounts ÷ new customers). Compare that cost with your other acquisition channels.
Download a copy
Downloads need a free account.