I have a Google Adwords campaign with around 200 ad groups. I would like to add some keywords which follow a similar structure to each ad group. They will be like this: *standard keyword text 1* + location 1 *standard keyword text 2* + location 1 *standard keyword text 3* + location 1 *standard keyword text 1* + location 2 *standard keyword text 2* + location 2 *standard keyword text 3* + location 2 *standard keyword text 1* + location 3 *standard keyword text 2* + location 3 *standard keyword text 3* + location 3 etc If I would like to add more keywords after I have initially done this, in the future I will probably want to add more keywords to each location so it may go like this: *standard keyword text 1* + location 1 *standard keyword text 2* + location 1 *standard keyword text 3* + location 1 *standard keyword text 4* + location 1 *standard keyword text 1* + location 2 *standard keyword text 2* + location 2 *standard keyword text 3* + location 2 *standard keyword text 4* + location 2 *standard keyword text 1* + location 3 *standard keyword text 2* + location 3 *standard keyword text 3* + location 3 *standard keyword text 4* + location 3 Does anyone know how I can construct a spreadsheet to help me do this quickly and easily? Is it even possible?
... so probably there's some solution somewhere in the web, but I still haven't found it Perhaps AdWords reps can direct you to a solution on Google Doc. In Excel you can use the Ampersand operator ("&"): =[cell with standard keyword text1]&[location1] etc. Still, doing it fast/elegantly will require the use of Macros. If you only care about keyword-to-ad relation, i.e. you're not trying to bid differently for each location - then consider using the new destination URL parameters {param1}, {param2}, which require API, see: http://adwords.google.com/support/aw/bin/answer.py?hl=en&answer=178482 These are "ad placeholders" - the first time I see Google AdWords are copying a feature from Microsoft AdCenter. Generally it goes in the opposite direction It's like keyword insertion, with one important difference: you have better control of the expression you're inserting into your text ad.