Select Repeat Customers by ASIN

We were sent us a support ticket today asking:

“Is there a way to filter for repeat customers by specific ASIN?”

And we had to reluctantly respond that we do not have such facility.

This is not the first time such a question was asked and every time I bend my head in shame. Important as this function is, I have been resisting distracting Yasir and his team to develop it, as they are currently working on a very important piece of functionality which we have been yearning for, for ages.

So, as a stopgap measure, I have developed a Google sheet which provides the facility.

Don’t get me wrong, we will eventually add this functionality natively into SL, but for the moment, this will help those of you who want to create FaceBook custom and lookalike audiences from your customer data or use the info for marketing purposes.

In conjunction with the existing SL filters, this Google sheet will allow you to find customers with repeat orders for several use cases:

– By specific ASIN or by a list of specific ASINs
– By specific date range
– Excluding customers who have refunded
– By City, State or ZIP code
– Customers who participated in a specific promotion ID
– Or by any combination of the above

Please make a copy of the following Google sheet onto your own Google Drive and follow the instructions on the “Read Me First” tab of the sheet.

https://docs.google.com/…/1O1-kx4faMvLPLgvSySyFyQO4Sy…/edit…


Significant Improvement to the Sales Statistics Screen

The sales statistics screen can now show the following combination of product sales data, over a user-selectable period of time:

– Sales By SKU
– Sales By ASIN
– Sales By Parent ASIN
– Sales By Product Group
– Sales By Brand

Moreover, for each of the above entities (SKU, ASIN, Parent ASIN, Product Group and Brand), you can show aggregate results by:

– Individual day during the selected period
– Individual week during the selected period
– Individual month during the selected period
– Individual quarter during the selected period
– Individual semester during the selected period, and
– Individual year during the selected period.

The screen now sports:

– A Period Selector
==> (Today, Yesterday, Last 7 Days, Last 30 Days, Last 90 Day, This Month, Last Month, Last 3 Months, Last Year, Year To Date, One Year, Custom)

– A Scope Selector
==> (By SKU, By ASIN, By Parent ASIN, By Brand, By Product Group)

– An Interval Selector
==> (By Day, By Week, By Month, By Quarter, By Semester, By Year)

– A button to view the results via a Chart View

As already advised earlier, the By Interval screen now shows red/green table rows to indicate a downtrend or uptrend.

Please note that as a consequence of this update, the Product Statistics screen will be retired in 30 days time, as all its functions can now be provided through this new Sales Statistics screen

Over-Table Filter Display

A long overdue feature.

When a table is filtered, the filtered field names and their filtered values are now displayed above the corresponding table.

This also works with Dashboard filters, by the way.