Plz help!!!

Discussion in 'Google AdWords' started by slacker84, Apr 3, 2008.

  1. #1
    I need a really good keyword generator
    and possibly sometihingthat can generate long tail keywords
     
    slacker84, Apr 3, 2008 IP
  2. PPC-Coach

    PPC-Coach Active Member

    Messages:
    1,450
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    90
    #2
    Excel is your friend. Take your base keyword and attach it to a couple expansion lists.
     
    PPC-Coach, Apr 3, 2008 IP
  3. UpsideDown

    UpsideDown Banned

    Messages:
    137
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I never knew excel has such a feature. Can you tell me in short how can i do it in excel?
     
    UpsideDown, Apr 4, 2008 IP
  4. magda

    magda Notable Member

    Messages:
    5,197
    Likes Received:
    315
    Best Answers:
    0
    Trophy Points:
    280
    #4
    you can also use hittail.com if you already have a site that's getting traffic, and a nice free keyword generator that's good for longtails is Massive Keyword List Builder from ibizresearch.com
     
    magda, Apr 4, 2008 IP
  5. PPC-Coach

    PPC-Coach Active Member

    Messages:
    1,450
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    90
    #5
    With excel you can put your base keyword in one column, then put your expansion list in the second column. For example:

    base keyword is in A1, expansion is B1, you'd put "=concatenate(A1, " ",B1)" in C1

    That will combine them for you and voila, you've got a long tail keyword. Now repeat that for the entire list. You can also add in the different match types and other keyword variations and you can build a HUGE list.
     
    PPC-Coach, Apr 4, 2008 IP