Desktop Report - Lifetime Value of an Account

This report would scrape data from ledger to calculate first off the average revenue per family account. Then it would scrape data from enrollment status (assuming revenue obtained only when the child is tagged as enrolled is what we would like to examine) and overlay the two. Average revenue per family account divided by average duration of time the account is active gives you the average lifetime value of an account. It would be nice to see it both ways -- meaning average LVA and specific LVA per family account.

Why this is useful - as a FBC, I help the franchisee run their business at peak profitability. One of the data points I would like to be able to monitor is customer acquisition cost. This is a calculation that needs LVA as an input and I have another tool that would help me understand marketing spend against lead volume.