Welcome to the Sick Marketing Support.

User Tag List

Results 1 to 4 of 4
  1. #1
    Expired/Coder


    Join Date
    Jul 2010
    Posts
    160
    Reputation Points
    1064
    Mentioned in
    0 Post(s)
    Tagged in
    0 Thread(s)
    Thanks (Given)
    19
    Thanks (Received)
    94
    Likes (Given)
    0
    Likes (Received)
    0
    Dislikes (Given)
    0
    Dislikes (Received)
    0

    Cog How to use scrapebox + excell for sick packets building

    In this thread I would like to give a few advices for those, who have problems with creating their own packets, the most common problems in this process are two:

    - It is hard to harvest a big list of specific platform forums
    - The harvested list contains a lot of invalid urls

    However I will try to help you to solve both of these problems, firstly let's talk, how to harvest, a good list:

    1. Decide, what quality of forums you are looking for and choose the main keyword according to your decision, a real world example:

    - You want to harvest a lot of forums, without (or very minor) moderation and you don't really care about the forums pagerank, for this situation you choose a keyword ''viagra'' because almost all moderated forums removes these kind of posts and, if forum are flooded with this type of advertising , it probably don't have any moderation.

    - You are looking for a high quality blogs with as high pagerank as possible, so you choose a keyword ''university'' , in this way you will probably harvest quite a lot of .org and .edu forums, which have high authority in Google (but at the same time, you can only expect to submit successfully in the minority of them due to various of security mods and accurate moderation).

    2. Scrape at least 5000 keywords by using your primary keywords and scrapebox ''Google Wonder wheel scrapper'' (or choose alternative tools, for example I prefer server based scrappings alternatives, such as Keyword Ninja).

    3. Add a footprint, which will allow you to harvest visible (don't expect that this will be 100% accurate, but you will definitely get better list, compared with simple footprints, such as ''Powered by SMF'') forum profiles, I can really recommend ''1buckplr'' tips, which you can find here: Packet Making Tips - Sick Submitter Support

    4. Get domain pagerank of all harvested urls (if you are looking for high quality blogs I would recommend to remove all urls with N/A and PR0 instantly

    5. Save list as excell csv file

    Now it is time to open Microsoft Excell to make our list suitable for sick list wizard, you might think that now I will begin to talk about various excell formulas and other difficult tasks, but, in fact, it is very simple to optimize your list (I will write down steps for Excell 2007 if you are using other version, or Open Office, you will probably find all required functions, but it will be located in different menu places):

    1. Open file, which you saved with scrapebox

    2. Select tab, in which all urls are located (for example, click A letter at the top)

    3. Click ''Data'' in the menu

    4. Click ''Text to Columns'' in the ''Data Tools'' submenu

    5. Select ''Delimited'' and click ''Next''

    6. Deselect ''Tab'', select ''Other'' and insert the symbol, which separates the correct forum url and unneeded ending (you will probably notice this instantly, after you look into your harvested list, at the moment, I have experience only with SMF forums, so the symbol for SMF is ''?'''. Click ''Next'' and ''Finish''

    7. Select the tab with the unneeded ending (for example tab B) and press delete button in your keyboard

    Now we will move to Sick:

    1. Open ''List Wizard'' and paste your harvested urls (I recommend to seperate packets every 1000 urls, for faster sick performance)

    2. Select the forums platform and click ''Create and save list''

    3. Open saved packets in Sick submitter. You will notice that ~5% of url's are still incorrect (sick sees unneeded ending as login information, etc), so you have 2 solutions:

    -Remove all invalid url's instantly
    -Try to modify incorrect url's manually (in the excell csv file) and then creating a new packet with corrected url's

    4. Run a test submission with sick submitter

    5. Copy all successful submissions URL's and paste it to .txt file

    6. Open Scrapebox ''Link checker'', input URL, which you used for test submission as a ''website'' and .txt file with profiles urls as ''Blog list''

    7. Export all failed links

    8. Open excell .csv file and with scrapebox ''urls to compare'' function delete failed forum links

    9. Remake packet with sick ''List Wizard''

    (you must do link checking instantly, as some forums have good moderation and your test submission link will be removed quickly).

    Of course it is just a basic guide (probably all coders will not see anything new in it) and it can be modified for better results, but, in my opinion, new sick members might need this kind of basic tutorial to understand that packets building is not something very difficult and you don't need to have any specific skills (only creativity and determination)
    Last edited by falco; 08-03-2010 at 06:49 AM. Reason: added more information
    Thanks sbhall, Horation, ashley, CityTiger, Boink and 10 others thanked for this post

  2. #2



    Join Date
    Mar 2010
    Posts
    2,407
    Reputation Points
    9328
    Mentioned in
    1 Post(s)
    Tagged in
    0 Thread(s)
    Thanks (Given)
    977
    Thanks (Received)
    818
    Likes (Given)
    0
    Likes (Received)
    0
    Dislikes (Given)
    0
    Dislikes (Received)
    0

    Default

    Thanks for the useful tips,

    I do a similar thing using Notepad++ and regex find-replace for the trimming of the URLs.


    Also for those who havent got Excel, Open Office is a suitably powerful alternative
    Professional Premium Templates
    Ultimate Template Collection


  3. #3
    Expired/Coder


    Join Date
    Jun 2010
    Location
    Mexico
    Posts
    2,554
    Reputation Points
    6003
    Mentioned in
    0 Post(s)
    Tagged in
    0 Thread(s)
    Thanks (Given)
    384
    Thanks (Received)
    533
    Likes (Given)
    0
    Likes (Received)
    0
    Dislikes (Given)
    0
    Dislikes (Received)
    0

    Default

    I'll go ahead and add this in here to keep it all on one spot.

    Just as many times you need to remove data from a link, sometimes you need to add it. This code will let you combine multiple columns in excel into a single column:

    in column a, put the first bit of info. Ex: http://
    in column b1, put the second bit of info. Ex: Website.com
    in column c1, put the third bit of info. Ex: /register.php
    in column d1, put the following formula: =CONCATENATE(A1,B1,C1)

    Then copy b1-d1 down so it'll fill in the cells next to the urls.

    This will give you http://www.website.com/register.php

    If you're going to use the URLs in Excel you'll want to remove the code. You can do this by highlighting the entire column and clicking copy. Then right click and choose "Paste Special". Then choose "Values". This will just leave the URL without the code.

    This is a great formula to have because with it you can combine any columns you want.

    I frequently use it to add 'http://' to the front of URLs which have been stripped so I can easily make the clickable (i.e. errors from sick that you want to look at to see what the problem is).

    Also, to make a list of URLs in excel clickable just click on the top URL and click F2 and hit enter. That'll make it clickable in excel.
    Last edited by mandom; 08-04-2010 at 06:52 AM.
    Thanks Boink, Jewbacca, novoweb, mikemiller, jamhall830 and 3 others thanked for this post

  4. #4
    Member

    mikemiller runs:

    Sick Submitter

    Join Date
    Jul 2010
    Posts
    60
    Reputation Points
    43
    Mentioned in
    0 Post(s)
    Tagged in
    0 Thread(s)
    Thanks (Given)
    115
    Thanks (Received)
    3
    Likes (Given)
    0
    Likes (Received)
    0
    Dislikes (Given)
    0
    Dislikes (Received)
    0

    Default

    Quote Originally Posted by mandom View Post
    I'll go ahead and add this in here to keep it all on one spot.

    Just as many times you need to remove data from a link, sometimes you need to add it. This code will let you combine multiple columns in excel into a single column:

    in column a, put the first bit of info. Ex: http://
    in column b1, put the second bit of info. Ex: Website.com
    in column c1, put the third bit of info. Ex: /register.php
    in column d1, put the following formula: =CONCATENATE(A1,B1,C1)

    Then copy b1-d1 down so it'll fill in the cells next to the urls.

    This will give you http://www.website.com/register.php

    If you're going to use the URLs in Excel you'll want to remove the code. You can do this by highlighting the entire column and clicking copy. Then right click and choose "Paste Special". Then choose "Values". This will just leave the URL without the code.

    This is a great formula to have because with it you can combine any columns you want.

    I frequently use it to add 'http://' to the front of URLs which have been stripped so I can easily make the clickable (i.e. errors from sick that you want to look at to see what the problem is).

    Also, to make a list of URLs in excel clickable just click on the top URL and click F2 and hit enter. That'll make it clickable in excel.
    Thanks this tip is very very helpful

 

 

Similar Threads

  1. Limit your link building?
    By Dan in forum General Submitter Support
    Replies: 2
    Last Post: 09-06-2010, 09:05 PM
  2. Scrapebox
    By Nanny Rose in forum General Submitter Support
    Replies: 13
    Last Post: 08-11-2010, 06:31 AM
  3. Building your own packets
    By Nanny Rose in forum Pre-Sale Questions
    Replies: 13
    Last Post: 07-25-2010, 10:38 AM
  4. searching in scrapebox
    By jofer29 in forum General Submitter Support
    Replies: 1
    Last Post: 06-17-2010, 04:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •