If you do Subscribe and Save, it is quite tedious to determine whether the scheme is profitable and whether it does generate repeat sales from a presumed ‘captive audience’ of buyers.

We have no immediate intention of providing S&S functionality in SL, there doesn’t seem to be that much demand for it. But just in case this would change, we have built a prototype to see what S&S KPI’s could be extracted from the data we already hold.

So here is an allegedly working Google sheet that operates off a filtered SL Orders download.

Please make sure you COPY THE SHEET FIRST and follow the instructions in the README FIRST tab.

The sheet shows you a monthly breakdown of S&S sales by ASIN, providing Units, Orders, Revenue, Profit, number of cancellations, cancellation rate per month and overall cancellation rate, as well as +/- monthly units variance.

It also shows per ASIN which customers have ordered regularly every month and provides a view of the reordering pattern by month by customer.

You can find the sheet here:

https://docs.google.com/…/19rPJg63005o_YnQzGZ3e2gSDa8…/edit…