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…
