1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Bet you don't know this answer!!

Discussion in 'BlackHat Lounge' started by Scotland, Jul 21, 2010.

  1. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Hey ppl,

    Ive got keywords entered into a spreadsheet file. There are 4 columns of keywords, the first has phrases like...how do i. The second column contains words such as lose weight, the third contains keywords like quickly and easily...

    Anyway, ive got about 50 keywords in each column, and what i would like to do is mix each and every keyword together so that i create 2 word, 3 word and 4 word phrases.

    I need to cover every combination basically and was wondering how i could a) do this and b) automate it...

    I will gladly share all the keywords to anyone who can help me out
     
  2. BassTrackerBoats

    BassTrackerBoats Moderator Staff Member Moderator Jr. VIP

    Joined:
    Mar 10, 2010
    Messages:
    12,714
    Likes Received:
    21,909
    Occupation:
    I don't actually have a job
    Location:
    It's an Algo, of course it can be gamed.
    Home Page:
    • Thanks Thanks x 1
  3. loclhero

    loclhero Supreme Member

    Joined:
    Jun 11, 2007
    Messages:
    1,453
    Likes Received:
    2,413
    Gender:
    Male
    Location:
    Copperhead Road
    Fuck...my wife just got on a plane for a biz trip. I won't hear from her until later tonight but I'll send this to her. She is the goddess queen of excel, could probably knock it out in a minute or two.
     
    • Thanks Thanks x 3
  4. AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    that is an excellent question!
    you could probably do it with a macro. Maybe
    You can definitely do this in access or some other db program.
     
  5. Chronos

    Chronos Junior Member

    Joined:
    May 5, 2010
    Messages:
    126
    Likes Received:
    294

    Am I nerd for thinking this would be a +1 in a girl?
     
    • Thanks Thanks x 1
  6. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Ive found a website that allows you to combine the 3 colums, you can only enter in a maximum of 12 per column, but this does exactly what i want. It looks like its a php script, id actually pay for this script cos i see good potential for it....

    Any idea how to get the php script?
     
  7. AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    what's the site?
     
  8. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    Sorry , im so stupid!!

    hxxp://www.searchenginepromotionhelp.com/m/keywords-combiner/word-combinations.php

    If this could be extended to more words in each colums, mixed with product keyword and buying keywords, this could be quite a good tool to source out some longtail keywords.

    Anyone else think this??
     
  9. bertbaby

    bertbaby Elite Member

    Joined:
    Apr 15, 2009
    Messages:
    2,019
    Likes Received:
    1,496
    Occupation:
    Product marketing
    Location:
    USA
    Home Page:
    Use a concatenation formula in Excel in a separate column to combine labels or strings:

    [FONT=Arial,Helvetica][SIZE=-1]Step-by-Step:[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]Cells F129 contains Mary and G129 contains Brown[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]Another cell, say, F132 contains the concatenation formula: =F129&G129[/SIZE][/FONT]
    [FONT=Arial,Helvetica][SIZE=-1]F132 will display: MaryBrown[/SIZE][/FONT]
     
    • Thanks Thanks x 2
  10. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    That worked a treat too!!
     
  11. essares1

    essares1 Junior Member

    Joined:
    Apr 27, 2009
    Messages:
    163
    Likes Received:
    27
    Send me the list. I will create 50x50x50x50 lines and send it to you. How I do it? I program it.
     
  12. 3gpstreet

    3gpstreet Newbie

    Joined:
    Nov 20, 2008
    Messages:
    15
    Likes Received:
    59
    Home Page:
    Use black coffee and Excel formula to combine the sells and rows
     
  13. AtomBoy

    AtomBoy Junior Member

    Joined:
    Feb 21, 2008
    Messages:
    119
    Likes Received:
    121
    Location:
    Venice, CA
    • Thanks Thanks x 1
  14. Scotland

    Scotland Regular Member

    Joined:
    Apr 4, 2009
    Messages:
    379
    Likes Received:
    204
    Occupation:
    Student
    Location:
    On Way To Personal Legend
    This is a smashing tool old chap.

    Much thanks n stuff given!!