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…
precentage-increase-decrease.xls
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 tot his 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!
« Facebook Pages and Fan Interaction | Home | Google Launches ‘Social Search’ »
Leave a Comment