Percentage Increase / Percentage Decrease…

AdWords Editor is a great piece of software.  One of the things it lets you do is to increase bids by any given percentage at a keyword level or an ad group level, so if you wanted to increase your bids on 1000 different keywords by 20% in one go, it is a piece of cake.

BUT – what if you don’t take a backup, then increase bids by 20%, upload your changes and then change your mind?

How do you change your bids back to exactly what they were?

Here is a wee spreadsheet I knocked up that does the calculation for you…

excel-icon

precentage-increase-decrease.xls

And for those of you who have a Google account and don’t want to much around with Excel or Open Office, here is the online Google Docs version :-

Google Docs Percentage Increase / Percentage Decrease spreadsheet.

Please bear in mind that I am very far from being an expert in MS Excel, and while it does work the other way round (getting back to the original bids after decreasing by a percentage) the wording is a bit confusing i.e. a decrease of -25% actually means an increase of 25%.

NB – this spreadsheet can also be used for a multitude of other uses e.g. if you accidentally change all the prices on your eCommerce system by a certain percentage and want to get back to exactly the original prices…

Maybe a similar spreadsheet exists to this exists elsewhere on the internet, but when I searched on Google I was not able to find one within 15 minutes so I created my own.

If anyone finds this useful, please let me know!

Thanks!

One thought on “Percentage Increase / Percentage Decrease…

  1. PPCNI says:

    [New Post] Percentage Increase / Percentage Decrease… – via #twitoaster http://www.ppcni.com/percentage-increase

Leave a Reply