We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Followed @cgoodman3 and optmisied for rating - mainly to practise using the tool
I don't mind that the count might be a bit padded towards the benefit of these children, but what I do mind is that my workflows containing optimisation were functional in 2019.2 and are dysfunctional in 2019.3. Here I present you with my workflow that uses optimisation on all products to maximise the review rating at the cost of purchasing them.
Assumptions of my solution: 1) calculate overall rating based on numReviews and customerRating, with half impact of each index. I also standardized the numbers between 0 and 1. 2) purchase strategy is high rating priority which means that first choice is the item with highest rating and select 10 items and then turn to the second highest rating item.
Was able to spend a 859.76 (leaving just .24 unspent) to purchase 330 items with an average customer satisfaction of 4.5...
Iterative macro to download all the replies in this post: