Walmart Connect Ad Spend Efficiency?

Hey everyone, following up on the budget allocation discussion from last week. I'm still completely stuck, now specifically with improving ad spend efficiency on Walmart Connect. Honestly, I'm feeling incredibly frustrated and urgent right now because I'm burning through budget with minimal return, and it's starting to really hurt.

The Core Problem:

• Despite countless attempts to optimize, our Return on Ad Spend (ROAS) is either stagnant or, even worse, declining. It's infuriating.
• I'm absolutely convinced we're overspending significantly on underperforming products or keywords, and I just can't seem to pinpoint the exact culprits effectively.
• The challenge isn't just about allocating budget anymore; it's about ensuring every single dollar spent actually contributes to sales and isn't just evaporating into thin air.

What I've Already Tried (and why it failed):

• Manual Bid Adjustments: I've spent countless hours tweaking bids, but it honestly feels like a never-ending whack-a-mole game. I improve one area, and another inevitably dips.
• Negative Keywords: I've added a ton of negative keywords after meticulously analyzing search term reports, but the waste still persists. It's like I'm always a step behind, patching leaks while the ship is still sinking.
• Campaign Structure Experiments: I've tried separating campaigns by product type, performance, and even audience segments, but it hasn't fundamentally improved our overall ad spend efficiency. The needle just isn't moving.
• Daily Budget Caps: While setting daily budget caps prevents massive overspending, it often caps our reach on days when performance *could* actually be good. This feels incredibly counterproductive to growth and just adds another layer of frustration.
• Performance Report Deep Dives: I've stared at the data for hours on end, creating pivot tables and charts, but translating those raw numbers into truly actionable insights for better budget allocation and cutting waste is proving incredibly difficult. I feel blind.

My Urgent Questions:

• What are your absolute best, most proven strategies for identifying and ruthlessly cutting wasteful ad spend on Walmart Connect? I need surgical precision here.
• Are there any specific metrics or reports within Walmart Connect (or even external tools) that provide deeper insights into budget effectiveness beyond the standard ROAS/ACOS? I feel like I'm missing something crucial.
• How do you approach dynamic budget reallocation? Is there a method for automatically shifting budget from underperforming to high-performing campaigns/products in near real-time, or is it all manual?
• Finally, any tips on structuring campaigns specifically for maximizing ad spend efficiency and minimizing wasted impressions/clicks right from the get-go?

I'm at my wit's end and really, truly need some practical, actionable advice here. This is driving me insane. Help a brother out please...