Calculating lifetime revenue collected from a customer
What's the best way to determine the total revenue collected from a customer? This needs to take into consideration plan changes, cancellations, re-subscriptions, etc.
My current thinking: Request the customer XML. Then iterate and sum all transactions with response="approved" under all invoices under all subscriptions.
Is this all-inclusive? Any problems with this approach? Will old data (e.g. 2+ yrs ago) ever be archived/purged from the customer record, or will it always keep a record of everything that's ever happened?
Discussions are closed to public comments.
If you need help with Cheddar please
start a new discussion.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
Support Staff 1 Posted by Marc Guyer on 09 Jun, 2010 07:14 PM
You've got it.
We do have a concern right now about the size of the XML response. Over time, it will only get larger. We may introduce a default date restriction on the result. For example, we might by default only return a year's worth of history. To get more history, you would be required to specify a date in the past when requesting the customer data. We haven't exactly decided how that's going to work but rest assured that we will let you know well in advance.
We do not have any plans to archive or purge any customer data.
Marc Guyer closed this discussion on 09 Jun, 2010 07:14 PM.