Using the Telematch Leads
We currently generate four files as part of the Telematch Leads program. Those files are described briefly below.
|match.txt :||This file can be opened, sorted, and printed using Microsoft Excel. It contains all of the phone numbers from your IVR and the Web which were matchable to our database. This file is the most flexible, but it also more difficult to use.|
|print.txt :||This file can be opened and printed using Notepad. It contains all of the phone numbers from your IVR and the Web which were matchable to our database. It is sorted by zip code. This file is the easiest to use, but is the least flexible.|
|nomatch.txt :||This file can be opened, sorted, and printed using Microsoft Excel. This file contains all of the phone numbers from your IVR that were not matchable to our database. It does not include data from the web, since that data is not Bureau specific.|
|cd.txt :||This file is not human redable, but can be imported into your database system. It contains all of the phone numbers from your IVR and the Web which were matchable to our database. It contains duplicate records so that those companies get inquiry credit when they are imported into your database.|
|raw.txt :||This file is for debugging purposes only. It contains a list of all the phone numbers that came from your IVR system, the count of inquiries against each number, and a yes/no field indicating if that number exists in our matching database.|
Opening and Printing the Print File
The print.txt file can be opened using any text editor. This is the easiest file to use, because you can open it simply by double-clicking the file.
To print the file, simply select File, Print.
Opening the Match or Nomatch Files
The match.txt and nomatch.txt files can be opened using Microsoft Excel. Below are detailed instructions on how to open these files.
1. Open Microsoft Excel by selecting Programs, Microsoft Excel from the Windows Start button.
2. Select File, Open.
3. On the open dialog box, select "Text Files" from the "Files of Type" drop-down box.
4. Use the Look In drop-down box to navigate to the location where you saved your leads files.
5. Select the file, and click the Open button.
6. The import wizzard will open. On step 1, make sure the "Delimited" option is selected, then click Next.
7. On step 2, make sure that Tab is selected as the delimeter, and that quote (") is selected as the text qualifier. Then, click Next.
8. On step 3, leave all the colums at their default (General), and click Finish.
9. The document is now open. Highlight all of the columns and rows by clicking on the box at the top left of the sheet. See the orange arrow in the snapshot below.
10. Select Format, Column, Auto Fit Selection.
Sorting the Match or Nomatch Files
Now that you have the file open, you can sort it and print it in any format you desire. Read on for more detailed instructions on how to sort the file.
1. Select all of the columns and rows, as you did before.
2. Select Data, Sort.
3. Make sure that "No header row" is selected, then choose the column to sort by in the first drop-down box. In this example, I will sort by zip code, which is Colum G.
4. Click OK, and your data will be sorted.
Printing the Match or Nomatch Files
The files print easily in landscape mode. The instructions below describe how to change to landscape mode, and how to tell excel to print 1 page wide (i.e. everything on a single page).
1. Select File, Page Setup.
2. In the page setup dialog, select the Landscape option. Then, select "Fit To" and enter 1 and 999 in the pages boxes, so that it reads "Fit to: 1 pages wide by 999 tall".
3. Select OK, and you are ready to print!