Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFollowed @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.
My Effort - $1540 to play with
Was able to spend a 859.76 (leaving just .24 unspent) to purchase 330 items with an average customer satisfaction of 4.5...
Main workflow
---
Iterative macro to download all the replies in this post:
On a spree to binge complete weekly challenges
Adrenaline rush
This was a fun challenge. How being active and posting on communities can contribute 🙂