Deciding Amazon PPC Bids in Google Sheets using a Formula for Campaign Funnel Movement

It's important to move top performing keywords and search terms from Auto/Phrase/Broad campaigns in Amazon down into Exact Match campaigns.

This allows you to have more granular control of bids and placement settings for each search term.

I've figured out a great formula in Google Sheets for quickly deciding on bids when moving keywords down the funnel from Auto > Phrase > Exact match campaigns.

This is saving me a ton of time and taking a lot of the guesswork out of the process.

Remember to never rely completely on formulas, however. I always go back and check metrics to make sure the bids are set to something I'm comfortable with.

Would love to hear your thoughts. How do YOU decide bids?