I'm working on a project and I would like to have about 500 adgroups online for testing. I may have to change each of the adgroup's headline or ad text from time to time. The problem is that it could take a lot of time doing it manually, and editing each adgroup within Google's interface.
Is there some kind of automation software that will enable me to upload all of the 500 in batch? Something like a spreadsheet would be optimal, where I can change the texts of some adgroups, and then upload as a batch to Google.
There are two things from Google that speed up keyword submission and ad-generation:
1) Google "Bulk-Sheet" Unless you have an account rep, you'll have trouble getting a hold of one of these. It is essentially a dump of the entire account into a spreadsheet. (Much more complicated than Overture's IMHO.)
2) Google Ad-Automator I think this is stil in beta, but they have finally let the cat out of the bag in a newletter(s?). Essentially, you upload a spreadsheet of your product information, and Google generates an ad on the fly for relevant queries.