08. Interpreting the Data

Owned by PeterF (Deactivated)
Sept 06, 2016
1 min read

After the leads have been downloaded from the Lead Cleanser they need to be interpreted into which numbers are connected, disconnected and unknown.

During the export process there are 4 additional columns that are added to the csv. They are; Vaild, Cost, Processed, Date.

For example:

Phone Vaild Cost Processed Date
XXXXXXXX 1 1 1 2012-1-27 16:50:48
XXXXXXXX 0 1 1 2012-01-27 16:38:02
XXXXXXXX 0 0 0 2012-01-27 17:21:59

 

 

Field Description Value = 1 Value = 0
Phone The phone number submitted N/A N/A
Vaild Whether the number is connected or not Connected Disconnected
Cost Number of Cleansing Units used 1 unit used No units used
Processed Whether a result was returned Result returned No result returned. This means that we tried to check it the number a few times (3) and we could not acurately determine its state. Around 80% of these numbers are valid.
Date Time and date the result was returned N/A Number not processed.

This data can then be sorted by the Valid column by Descending which will put all of the connected numbers at the top of the spreadsheet.