How to group more than 10.000 unsorted keywords

Discussion in 'Google AdWords' started by t_money, Jul 6, 2007.

  1. #1
    Hi everybody,

    I've got a big problem :eek:

    I've got more than 10.000 keywords, all from different verticals (travel, finance, telco, ...) and I would like to group them in specific adgroups in Google in order to get a higher Quality Score, rather than putting them in generic lists/adgroups like Group001, Group002, and so on.
    For example, I'd like to have an adgroup named Hotel formed by keywords about... hotel or synonyms (hotel rome, hotel milan, milan motel, florence motel, ...).
    For me it's impossible to classify the keywords one by one and I found that Google and Microsoft Adcenter's tools for grouping keywords are not working well, at least for my purposes.
    Do you know a way, a tool, or anything else that can help me solve this problem?
    I can even build up my own tool or apply a specific algorithm, but I can't find the way.

    Can you help me or just give me some hints?

    Everything will be very appreciated :)
     
    t_money, Jul 6, 2007 IP
  2. Huligan

    Huligan Peon

    Messages:
    328
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Yeah, I highly recommend using Google's AdWords Editor. You can download it for free. It is extremely useful with dealing with large AdWords accounts. Also, consider making each one of your verticals a campaign. I know that makes it difficult with your daily budget, but organization will improve your ads. If only to save you time.
     
    Huligan, Jul 6, 2007 IP
  3. GuyFromChicago

    GuyFromChicago Permanent Peon

    Messages:
    6,728
    Likes Received:
    529
    Best Answers:
    0
    Trophy Points:
    0
    #3
    GuyFromChicago, Jul 6, 2007 IP
  4. t_money

    t_money Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The grouping tool on Google Adwords Editor is not working very well...

    I make you a quick example of the problem. Consider this keywords:
    hotel milan
    hotel florence
    hotel amsterdam
    amsterdam car rental
    amsterdam cheap flight
    amsterdam deals
    amsterdam insurance
    amsterdam girls
    milan flight
    milan restaurants
    milan clubs

    Obviously my aim is to group all of them by specific niche/vertical, for example:
    adgroup: HOTEL | keywords: hotel milan, hotel amsterdam, ...
    adgroup: FLIGHT | keywords: ...

    But I can not be sure that Google Editor's grouping tool will give me this representation... it can output also:
    adgroup: MILAN | keywords: hotel milan, flight milan, ...
    adgroup: AMSTERDAM | keywords: hotel amsterdam, amsterdam girls, ...

    Having more than 10.000 kws, it's really impossibile to check all the results and the correct clustering... consider also that I'm not using only English words... but also Dutch kws (I don't know Dutch :) ) or German kws (I don't know German as well...).

    That's a really tough problem
     
    t_money, Jul 6, 2007 IP
  5. GuyFromChicago

    GuyFromChicago Permanent Peon

    Messages:
    6,728
    Likes Received:
    529
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Sorry, I missed that in your first post:eek:

    So have you used the Editor tool yet and you're not happy with the results or are you just worried that the tool will not group your keywords the way you want them?

    Can't help with you not knowing the other languages that well, that would make it tough:)

    In terms of checking you should be able to run the grouping tool and evaluate at least a sample of the ad groups it creates without actually publishing those changes. If it looks terrible, don't publish it. If you do publish all the changes just dedicate some time on day 1 and 2 to check the ad groups for consistency...just check them in order of impression or click volume to make sure you catch any potential costly problems early on.
     
    GuyFromChicago, Jul 6, 2007 IP
  6. t_money

    t_money Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    I haven't use the Google Editor's tool on this set of keywords yet, but I have already experienced its results with other accounts (even with less keywords inside) and usually the outcome is not good.
    I will follow your hint, that is try to use it and then evaluate the clustering, but it is only possible with known language keywords... it will be impossible with Dutch or German ones :)

    I was wondering also to create single-keyword adgroups but in this way the account navigation would be very difficult... Honestly I don't know what to do.

    Anyway I think that an automated clustering tool will be useful for anybody running ad-campaigns with large amounts of keywords... that's why I'd like to build one. The main problem is only to find a way for retrieving synonims of a particular word and then discarding words like adjectives, city name, and stuff like that from a list.
    Once you've got a depurated list of keywords based on nouns you can cluster them matching noun-keywords with your initial set... :)
     
    t_money, Jul 7, 2007 IP