Expected sales until end of month should only include "AUTO_RENEW" licenses

[spraot]

Most server licenses are AUTO_QUOTE, and extensions for these are often purchased several months before or after expiry, or not at all.

In the case of server licenses, the prediction is actually not very good at all, and it might be better just to project that the remaining business days in the month will have the same amount of sales as the average for the past few months.

[spraot]

Also, the number is not correct for server addons, since when a server addon is renewed, the price is only half of the original price. Actually, even that cannot be relied on, since the user may not have bought exactly one year of maintenance originally (two years is common). To be correct, we would have to get the current sale price from the marketplace API.

[thecatontheflat]

@rachetfoot If you could give me a logic (in pseudo-code or in diagram) for calculation of expected sales till the end of month or quarter or year — it would help me to build a proper implementation

[spraot]

Something like the following would probably be pretty reasonable as a sort of "minimum expected renewals", although this number will be quite far from the total amount of sales, so it is still only of limited use. In general, sales fluctuate a lot from month to month for server addons, and are therefore hard to predict.

I'm pretty sure we can get the price from API 2.0, although I think it's still in beta.

licenses = licenses WHERE expiry between now and end of month AND license.renewal == AUTO_RENEW
sum = 0
for license in licenses {
  licensePrice = price from marketplace API
  if license.key ends with "ondemand" {
    sum += licensePrice
  } else {
    sum += licensePrice/2
  }
}