Generate Themed Lists Automatically with Google Drive
A recent discussion within the community inspired me to share this feature as I'm sure some of you will be able to find a use for it. To give you a little background:
The advertiser's business creates wiring for a variety of products but he wanted to exclude car makes and models as this was generating 50% of the total incoming traffic and would not be feasible to create due to the overall costs to the clients. Manually entering each car make as a negative keyword would be too time consuming and the lists we found online always seemed to be incomplete. There is a great (and sometimes entertaining) feature in the spreadsheets section of Google Drive which could help address issues such as this one.
The feature is simply called Auto-fill and this is how you use it:
- Login to Google Drive using your usual Google Profile details and open a new spreadsheet using the Create button.
2. Introduce a word into the first cell and then a related word in the cell below it. So in our example to produce a list of car makes I would use "bmw" and "jaguar". It's worth noting that you don't need to limit this to two cells, the more you have then the more relevant the result is likely to be.
3. Now highlight these two cells and while holding the Ctrl key (or ALT key for Mac users) drag the little square box in the bottom right corner of the "jaguar" cell down as far as you like. Once releasing the mouse and Ctrl key you should be presented with an extended list of car makes which have automatically been generated.
This handy feature isn't restricted to car makes however and can be applied to an unbelievable amount of subjects, it's just a case of working out how it can be best applied to your own AdWords campaigns. Let me know if you do end up using it and in what situation via the comments so that we can all share from your experience!
I have been managing AdWords accounts for over 8 years now at an international marketing agency level and also as a freelancer. I am very passionate about Google's PPC platform and pretty much anything else that is Google related. My theory in life is to learn something new every day and this community is definitely a good place to do so; I would recommend anyone reading this to stick around as it's an excellent source of information with great people contributing to it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.