PPC Revamp: Request for Assistance

We have been neglecting our PPC functionality and we have fallen behind our competitors. Additionally, with 1.8 Billion (with a capital B) search terms in our database, performance on the search terms performance/keyword performance widgets is not great.

So, we have vowed to take action and get back in the saddle again.

We will start by restructuring the PPC database and assigning it to a dedicated server, rather than sharing the main servers. We aim to have this done by the end of this month and it should be relatively transparent to you.

The next bit is where we’d like to enrol your assistance: We’d like to work with you if you are an expert in PPC and are willing to share your ideas as to how to improve or transform our current PPC functionality. This will include implementing AMS functionality and automating the bidding and keyword management process. As we now have a budding AI specialist in our development team, we will investigate opportunities to use these new technologies.

If you wish to help, you should be

– Very well versed in PPC management
– Not a white labeller of ours (or, if you are, accept that if we develop according to your specifications, this will be available to all SL users and not exclusive to your white label account)
– Able to participate in regular conference calls to discuss/review design, specification and user interface
– Able to devote time to beta test the developments.

We aim to start sometime in early March and anticipate this will be 6 to 8 weeks of work.

Please let us know whether you’d want to participate.

Subscribe And Save Google Sheets Prototype

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…