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

Anyone Use Spyfu With Kw Research here's an Imacro Script

Discussion in 'Black Hat SEO' started by supamanjon, Mar 9, 2010.

  1. supamanjon

    supamanjon Power Member

    Joined:
    Dec 19, 2009
    Messages:
    644
    Likes Received:
    68
    Code:
    
    VERSION BUILD=3700331       
    'Uses a Windows script to submit several datasets to a website, e. g. for filling an online database
    TAB T=1      
    ' Specify input file (if !COL variables are used, IIM automatically assume a CSV format of the input file
    'CSV = Comma Separated Values in each line of the file
    CMDLINE !DATASOURCE test.csv
    'Number of columns in the CSV file. This must be accurate!
    SET !DATASOURCE_COLUMNS 1
    'Start at line 2 to skip the header in the file
    SET !LOOP 2
    'Increase the current position in the file with each loop 
    SET !DATASOURCE_LINE {{!LOOP}}
    ' Fill web form
    URL GOTO=http://www.spyfu.com/     
    TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:aspnetForm ATTR=ID:ctl00_MainContent_Search1_SearchTextBox CONTENT={{!Col1}}
    TAG POS=1 TYPE=INPUT:IMAGE FORM=ID:aspnetForm ATTR=ID:ctl00_MainContent_Search1_SearchButton
    TAG POS=1 TYPE=SPAN ATTR=ID:ctl00_Top_ctl00_TermLabel   
    SET !EXTRACT_TEST_POPUP NO
    TAG POS=1 TYPE=SPAN ATTR=CLASS:Red18px&&TXT:*&&ID:ctl00_Top_ctl00_TermLabel EXTRACT=TXT  
    TAG POS=1 TYPE=TD ATTR=CLASS:H1Text&&TXT:* EXTRACT=TXT
    TAG POS=2 TYPE=TD ATTR=CLASS:NormalText&&TXT:* EXTRACT=TXT  
    'The SAVEAS statement was added manually to write the extracted table to a file
    'The name of the file to store the extracted information to is specified with the FILE= attribute of the SAVEAS command
    'The FOLDER=* attribute indicates that the default folder is used. You can specify another folder with FOLDER=c:\yourfolder
    SAVEAS TYPE=EXTRACT FOLDER=* FILE=spyfu.csv
    
    
    Replace test.csv with your excel file that you have keywords in. The keywords need to be in the first column.

    Replace spyfu.csv with whatever you want your scraped results to go to.

    This script plugs in your keywords at spyfu searches and scrapes the kw name,cost per click, and advertisers perfect for kw research if you use spyfu like i do. Also when you run the imacro scripts just press play loop for however many rows you have. Since it's a simple free script if the spyfu doesn't come up with any results which happens if there are no ads for that keyword it will stop the script, so just remove that kw or start on a new row.
     
    • Thanks Thanks x 1
  2. supamanjon

    supamanjon Power Member

    Joined:
    Dec 19, 2009
    Messages:
    644
    Likes Received:
    68
    guess no one uses it
     
  3. PlatinumPi4u

    PlatinumPi4u Junior Member

    Joined:
    Mar 5, 2010
    Messages:
    168
    Likes Received:
    29
    new to scripts, but not new to excel, spyfu, etc...

    so how do I run this?