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)