Lead Processing
For leads from Leads page and others.



Leads from FreeFFa's typically contain some duplicates and/or error entries.

You can get additional FREE leads every day from Etracking which will definitely contain some  multiple search engine entries. This is the method I use to "process"
both FreeFFa and Etracking sites leads.

This process reduces your list to email addresses only. Do not use this if you need date/time stamp, or if you want to use personalization (first, last, full name).

 Don't let my long detailed explanation here scare you. The process is quite simple once you do it a few times.

Instructions to Filter and Sort leads with Open Office Calc and Notepad

To download this free desktop software suite go to: http://www.openoffice.org/

This method removes duplicates and all info but email addresses and sorts leads.

　 This entire process as described below usually takes about 5-8 minutes once you learn it.  That includes collecting leads and complete processing.

Remember, For freeffa paying and free Etracking members, leads will accumulate if you don't download every day and processing will take 1-2 minutes per day of accumulation longer.

I do have the complete Microsoft Office suite, but use Open Office to better my knowledge of it so I can share with others that do not have Microsoft Office software. I find it to be as easy to use for most things I do. I am not making a statement for or against either or any product.

I save all files I make to DESKTOP in XP so they are easy for me to find. With Vista I save to folders on my desktop. Then with XP after uploading leads in Veremail, I put the lead files I created in designated folders.

I like to use the mouse wherever possible instead of keyboard commands.

 "Click" means left mouse click unless "right click" is specified.

Downloading leads from FFA and Etracking and Webcatch

1. Open a blank notepad window.

After logging in on left side of FREE FFA page and page morphs to next page. Second entry on the top row (after setup), is FFALEADS. Click FFALEADS 1 time. Do not click it a second time for any reason! It will take a few seconds to a minute or more for your leads to appear. (If you click a second time, you will get no, Zero, 0 leads!)

a. When leads appear at FREE FFA page, right click on window with leads, choose select all, right click and choose copy in highlighted area, right click on empty notepad window and choose paste.

b. eTracking and Webcatch; Copy/paste leads to same notepad following last FFA's lead.

 Process: At eTracking or Webcatch after logging in and clicking View and Download My Contacts button. Left click start of leads and hold mouse cursor while moving the cursor down over all leads till all leads are highlighted, then right click in highlighted area and choose copy go to notepad window and right click and choose paste with cursor on first row after last lead from FFA site. Same process with eTracking and Webcatch leads.

c. Remove spaces: Usually about 50 entries will have a space preceding some leads. We need to remove that space for proper sorting and duplicate removal. To do this you click EDIT at top of notepad, click REPLACE in window that opens, hit your space bar on your keyboard 1 time, click REPLACE ALL in the column on right, wait while the spaces are automatically removed. (about 15-30 seconds with XP, Instantly with VISTA).  Hour glass may be visible while spaces being removed in XP, or you may see the little grey removing box moving down your list.  When done close little EDIT window by clicking X box top right corner.

 d. Save and assign name to notepad and save to desktop or wherever and leave open for further use.

 

Keys on your keyboard you will, or may need to use for the following process.

Keyboard with notations image

Sorting and filtering leads

2. Open OpenOffice CALC

NOTE: Sometimes when highlighting a column it will flash rapidly in XP. I don't know why, but I give it a few seconds incase it's doing something, then I proceed as normal whether it is still flashing or not.

Note: Whenever transferring leads from Notepad to CALC page; Always go to the little scroll handle on right side of CALC page and bounce handle off of bottom of scroll area by clicking on scroll handle and moving it to bottom as far as it will go and release. Why? I don't know, but sometimes it doesn't make all leads available till you do this.

a. Go to notepad window and right click on window with leads, choose select all, right click and choose copy in highlighted area, right click in A1 box (Column A Row 1), on CALC page and choose paste.

b. Text import window opens, click/check in comma, (also should already be a check in TAB) click OK.

c. Close notepad. We will no longer use this notepad file. I save mine till I have completed this entire process incase I goof up I can always start over.

3. On CALC work page, Click on A, (for A column), (highlights whole A column), right click on A, choose DELETE COLUMNS

b. Column B with email addresses becomes A column. Expand column A now to see whole email address by placing cursor between A and B top of columns and while holding cursor with arrows showing, move to right to desired width of column.

4. Click on any box in C column

a.Click ctrl and down ARROW on your keyboard at the same time. This should take you to first entry in column C.

b. Right Click in box for that row in column A, right click and choose DELETE, in little window that opens choose move cells left, then ok.

NOTE: (when clicking in a box, do not click on text in box, click in open area in box). You may have to move email address more than once the left to get in A column.

c. Click on box in C column again, hit ctrl & down arrow at same time in column C again and repeat step 4b above.

Keep repeating this process till no more entries to process in C column. Then click ctrl & home or ctrl & UP arrow at same time to return to top of page.

D. If you wish to eliminate entire row. Instead of clicking box in A column, right click on row Number, (example 257), at beginning of row.

Choose DELETE ROW. Repeat process for any entire row you wish to delete. If multiple rows, just move cursor over all number rows you wish to delete, right click and choose DELETE ROWS.

4. Left click and hold on B for B Column top of work page. (highlights B column with dates in it), move held down cursor to right (highlighting columns), till you get to double letter columns. AA AD, etc. release and right click anywhere in the hilited area and choose DELETE.

b. now you should only have email entries in A column and no other info on page at all.

5. FILTER:

a. Left click on A, (highlights A column), click DATA in top tools row. choose FILTER, choose STANDARD FILTER.

b. in FIELD NAME (will show A1 email address), click scroll arrow and choose NONE, now click MORE on bottom right side of filter window, New filter window opens.

Range contains column labels should be checked automatically. Now you must click in this EXACT order Click/check COPY RESULTS TO..., left click B1 box on CALC work page, Click/check NO DUPLICATION box

KEEP FILTER CRITERIA should have box checked automatically. Click OK.

Note:Use this exact sequence of clicks for filter process, if you get out of order just cancel filter and start over.

c. Right click A on CALC work page (A column should highlight). Choose DELETE COLUMNS. B column should move to become A column.

d. Widen A column with placing cursor between A and B top of columns and when you see arrows move cursor to right to desired width.

6. Sort:

a. Now Click on A top of column to hilite A column, click DATA (top Row of Tools area), choose SORT

b. Click OK. Ascending should be chosen in first 2 boxes of this window automatically. Sorting is done.

Delete any blank, date, or useless rows that might appear near first few rows on CALC work page in column A.

7. Save Leads:  Save in Calc as text "txt", "csv" or other format.

To save in notepad as text "txt" only: Go to work page and choose ctrl and end at the same time. Write down last number of last lead (example 1743).

Left click and hold cursor down on that last lead (hiliting it), moving cursor up a couple leads while pressing and holding shift key down, keep shift key down and release cursor button, then with mouse use scroll handle right side of window to go to top of page and then click on 1A box, all this time holding the shift key down. The whole column of leads should be hilited now. Let up shift key, right click on hilited leads and choose COPY, go to fresh notepad and right click and choose PASTE. Then on notepad click FILE, then SAVE and enter your file name for your leads.

(You must copy paste this way because if you just hilite A column and Copy, it will include empty rows under leads to bottom of CALC work page.)

Do it however you like. Then click SAVE and close this notepad. Your leads are saved as a text "txt" file.

You are done collecting and processing the days leads.

Load leads in your auto responder as it instructs.

Personally I can load 10,000 leads a day in my Veretekk Gold System auto responder. Ask me about it if interested.

I am available to assist you. Please contact me if you need additional help with this process.

If you'd like some free useful marketing and SEO software go here:  SOFTWARE

You can email me; leads at mimbiz.com

Call: 206-202-1477 I will call you back ASAP.

Skype: mimbiz1 (text "leads"), when add to contacts

To our success, John

 

This website and contents designed by John Evans                        
Copyright © 2003 MIMBIZ.com All rights reserved. 

206-202-1477 1johnevans at gmail.com  Skype: mimbiz1
BOX 44   Osceola IN   46561