You're being extremely granular in your approach. You're looking at each individual listing on a 2 week time frame and cutting losses based on that, this isn't right in my opinion. For some however, they can't afford to not cut losses, which is unfortunate because many times it's right before a big conversion wave.

I've had weeks where I've spent $1000 just to make $200 in sales from ads. But then I've had weeks where I've spent $1000 to make $6000 on Etsy ads. On a time frame greater than 2 months, my ROAS is about 5 to 6 overall on Etsy ads. Now this isn't to say this should be the same for you, considering what we're selling/etc.

I sound like a shill for Etsy ads at this point, which I'm not I promise lol