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…