CRM Freshlink Plus

Overview

In addition to all of the features included in CRM FreshLink, the Plus version adds additional key consumer data elements to complete the profile of each record in the CRM file. Appended attributes include age, income, Gender and more than 80 additional data elements. This wealth of information provides key insights to boost segmentation and personalization

Input

Input Field Description
Full Name Full individual Name
First Name First name, 15 characters maximum
Last Name Last name, 20 characters maximum
Address1 Address line 1, 64 characters maximum
Address2 Address line 2, 64 characters maximum
City City name, 28 characters max. * Either City/State or Zip5 is required
State 2 character state abbreviation. * Either City/State or Zip5 is required
Zip5 5 digit numeric USPS zip code. * Either City/State or Zip5 is required
Phone 10 digit numeric phone number (without spaces, dashes, or parentheses)
Phone2 10 digit numeric 2nd phone number (without spaces, dashes, or parentheses)
Email Email address, 100 characters maximum
IP IP v4 address in dotted decimal nnn.nnn.nnn.nnn format
SHA2 64 characters SHA2 email address encryption
SHA1 40 characters SHA1 email address encryption
MD5 32 characters MD5 email address encryption
*At a minimum, one of the following input combinations is required for processing:
  • Phone
  • Phone2
  • Email
  • FName + LName
  • FullName
  • Address1 + Zip
  • Address1 + City + State
  • IP
  • Sha2
  • Sha1
  • MD5
For Identity append/competition & additional contact information, CRM FreshLink requires phone, email or name & address input. The Powerflex2 system will produce an output file in the same format as the one received.

Output

Field No. Output Field Description Return Values
1 Cleansed Phone Data in this column indicates that phone input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Phone number or blank
2 Input Phone Type Phone Owner Id Match CategoryIP – Individual - PhoneHP – Household - PhoneAP – Address - PhoneNP – Name – PhoneLP – Last Name – PhoneFP – First Name - PhoneZP –Zip - PhoneP- Phone VerifiedX – No Match IP, HP, AP, NP, LP, FP, ZP, P, X
3 Cleansed Phone 2 Data in this column indicates that phone input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Phone number or blank
4 Input Second Phone Type Phone Owner Id Match CategoryIP – Individual - PhoneHP – Household - PhoneAP – Address - PhoneNP – Name – PhoneLP – Last Name – PhoneFP – First Name - PhoneZP –Zip - PhoneP- Phone VerifiedX – No Match IP, HP, AP, NP, LP, FP, ZP, P, X
5 Cleansed Email Data in this column indicates that email input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Email address or blank
6 Cleansed First Name Data in this column indicates that name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. First name or blank
7 Cleansed Last Name Data in this column indicates that name input data has been successfully cleansed by CRMFreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Last name or blank
8 Cleansed Middle Name Data in this column indicates that name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Middle name or blank
9 Cleansed Full Name Data in this column indicates that full name input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Full name or blank
10 Cleansed Full Address Data in this column indicates that address input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Address or blank
11 Cleansed City Data in this column indicates that city input data has been successfully cleansed by CRMFreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. City or blank
12 Cleansed State Data in this column indicates that State input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. State or blank
13 Cleansed Zip Data in this column indicates that zip input data has been successfully cleansed by CRM FreshLink or that the input data has been confirmed as clean. An invalid input generates a blank field. Zip or blank
14 Unique Customer PID Unique individual that was matched to on the database.1st Character – Y (Person found on the database)/N (Person not found on the database). Remaining characters - Unique Identifier. String Value 32 characters max.
15 Household ID Unique address + Last Name that was matched to on the database.1st Character - Y (Address found on the database)/N (Address not found on the database). Remaining characters - Unique Identifier. String Value 100 characters max.
16 Address ID Unique address that was matched to Infutor’s Identity Graph.1st Character - Y (Address found on the database)/N (Address not found on the database).Remaining characters - Unique Identifier. This can be used in conjunction with other data points to understand if multiple customers are living at the same household. String Value 32 characters max.
17 Refreshed First Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 50 characters
18 Refreshed Last Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 50 characters
19 Refreshed Middle Name If input data is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no data was input, then we reference the Infutor Identity Graph to populate a result. 1 Character
20 Refreshed House Number If an input House Number is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no House Number was input, then we reference the Infutor Identity Graph to populate one. 10 Characters
21 Refreshed Pre Directional Street Pre Direction: N, S, E, W, NE, SW, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
22 Refreshed Street Name Street name. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 28 Characters
23 Refreshed Street Type Street suffix: ST, AVE, BLVD, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
24 Refreshed Post Directional Street Post Direction: N, S, E, W, NE, SW, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
25 Refreshed Apartment Type Secondary Unit designator: Apt, Suite, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
26 Refreshed Apartment Number Secondary unit number: Apt #, Suite #, etc. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 8 Characters
27 Refreshed Full Address Full address output in a single field. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 100 Characters
28 Refreshed City USPS City Name. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 28 Characters
29 Refreshed State USPS state abbreviation. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 2 Characters
30 Refreshed Zip5 Numeric USPS zip code. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 5 Characters
31 Refreshed Zip +4 Extension Numeric USPS zip+4 extension. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 4 Characters
32 Refreshed Delivery Point Code Delivery point code with check digit. If an input is provided, this field returns that input, and if it was successfully cleansed, the cleansed output will show here. If no input was provided, then we reference the Infutor Identity Graph to populate one. 3 Characters
33 Refreshed Carrier Route Code Carrier Route Code. If an input address is provided, this field returns the carrier route for that input, and if it was successfully cleansed, the carrier route for the cleansed output will show here. If no input address was provided, then we reference the Infutor Identity Graph to populate an address and this field contains the corresponding carrier route code. 4 Characters
34 Zip4 Type Code Appended USPS Zip+4 typeF – firm or company addressG – General delivery addressH – High-rise or business complexP – PO Box addressR – Rural route addressS – Street or residential addressBlank - Unknown F, G, H, P, R, S
35 Delivery Point Validation Appended Delivery Point ValidationY – Address DPV confirmed for both primary and (if present) secondary numbersD – Address DPV confirmed for primary number only, secondary number information was missingS – Address DPV confirmed for the primary number only, and secondary number information was present but unconfirmedN – Both Primary and (if present) Secondary number information failed to DPV confirmBlank – Address not presented to table Y, D, S, N
36 Appended Validation Date Appended address last validated date YYYYMMDD or YYYYMM, depending on availability.
37 Address Improvement Code Address Improvement Codes:0 - Source Address is best address.1 - Source Address NCOA'd.*2 - Corrected Source Address NCOA'd*.3 - New proprietary change of address returned.4 - Corrected Source Address returned.5 - Source Address NCOA'd, but MLNA.6 - Corrected Source Address NCOA'd, but MLNA.*7 - Source Address NCOA'd, but NIXIE.*8 - Corrected Source Address NCOA'd, but NIXIE.* *Values 1, 2 ,5 - 8 are returned only with the NCOA Add on. 0-8
38 Appended Phone Net new appended 10-digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
39 Appended Phone Type Phone type for the Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
40 Appended DID Direct Inward Dial Number Y or blank
41 Appended Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU - Unknown R, B, P, U
42 Appended First Date Date record was first received YYYYMMDD
43 Appended Last Date Date record was last received as connected YYYYMMDD
44 Appended Telco Name Name of original telephone company provider 100 Characters
45 Appended Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
46 Appended DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
47 Appended Match Score Appended Match Score (See Appendix B) nnn
48 Appended Match Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
49 Appended Second Phone Net New Appended 10-digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
50 Appended Second Phone Type Phone Type for the second appended phoneL – Land LineV - VoIPW – WirelessO – Other (Pay phone, Pager, Toll Free) L, V, W, O
51 Appended Second DID Direct Inward Dial Number Y or blank
52 Appended Second Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU – Unknown R, B, P, U
53 Appended Second First Date Date record was first received YYYYMMDD
54 Appended Second Last Date Date record was last received as connected YYYYMMDD
55 Appended Second Telco Name Name of original telephone company provider 100 Characters
56 Appended Second Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
57 Appended Second DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
58 Appended Second Match Score Appended Match Score (See Appendix B) nnn
59 Appended Second Match Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
60 Appended Third Phone Net New Appended 10 digit numeric phone number (without spaces, dashes, or parentheses) 10 characters
61 Appended Third Phone Type Phone Type for the Third appended phoneL – Land LineV - VoIPW – WirelessO – Other (Pay phone, Pager, Toll Free) L, V, W, O
62 Appended Third DID Direct Inward Dial Number Y or blank
63 Appended Third Record Type Appended Record TypeR – ResidentialB – BusinessP – PayphoneU – Unknown R, B, P, U
64 Appended Third First Date Date record was first received YYYYMMDD
65 Appended Third Last Date Date record was last received as connected YYYYMMDD
66 Appended Third Telco Name Name of original telephone company provider 100 Characters
67 Appended Third Phone Confidence Score Telephone confidence score1 is highest confidence, 5 is lowest. 4’s are considered possible disconnects, 5’s are likely disconnects. PHV 1-3 are considered high confidence records. 1 - 5
68 Appended Third DA Code Directory Assistance Flag, 1 character max. Y – Record as it appears in Directory Assistance D – Record was removed / delisted from Directory Assistance Blank – Private record (not in Directory Assistance) Y, D, Blank
69 Appended Third Score Appended Match Score (See Appendix B) nnn
70 Appended Third Category Appended Matched Category (up to 3, one for each appended phone)I – IndividualH – HouseholdA – AddressZ – Name/Zip I, H, A, Z
71 Appended Email Net New Appended Email Address 100 Characters
72 Appended Email Suppression Code Email Suppression Code N - Email is Eligible for Deployment N or blank
73 Appended Email Match Score Appended Match Score (See Appendix B) nnn
74 Appended Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
75 Appended Email URL Appended URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
76 Appended Email Last Date Appended Email Last Seen Date YYYYMMDD
77 Appended Second Email Net New Appended Email Address 100 Characters
78 Appended Second Email Suppression Code Email Suppression Code N – Email is Eligible for Deployment N or blank
79 Appended Second Email Match Score Appended Match Score (See Appendix B) nnn
80 Appended Second Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
81 Appended Second Email URL Second Appended Email URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
82 Appended Second Email Last Date Second Appended Email Last Seen Date YYYYMMDD
83 Appended Third Email Net New Appended Email Address 100 Characters
84 Appended Third Email Suppression Code Email Suppression Code N – Email is Eligible for Deployment N or blank
85 Appended Third Email Match Score Appended Match Score (See Appendix B) nnn
86 Appended Third Email Match Category Appended Matched Category I – Individual (First Name, Last Name, and Address)H – Household (Last Name and Address)A – Address (Address)Z – Name/Zip (Last Name and Zip Code) I, H, A, Z
87 Appended Third Email URL Third Appended Email URL - Indicates the website the consumer "opted-in" to receive marketing emails. 100 Characters
88 Appended Third Email Last Date Third Appended Email Last Seen Date YYYYMMDD
89 Valid Address The validation scores validate the quality of the of the input address data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worst, and 100 being the best. Score 0-100
90 Valid Phone The validation scores validate the quality of the of the input phone data by scoring the formatting of the data on a scale from 0 - 100;0 being the worst, and 100 being the best. Score 0-100
91 Valid Second Phone Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
92 Valid Email The validation scores validate the quality of the of the input email data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worst, and 100 being the best. Score 0-100
93 Valid Name The validation scores validate the quality of the input name data by comparing against common name tables and vulgar word tables to return a score on a scale from 0-100. Score 0-100
94 Phone Confidence Score The Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
95 Second Phone Confidence Score Score 0-100 that reflects the confidence that a given phone is active and hasn't been reassigned, based on activity & velocity indicators Score 0-100
96 Address Confidence Score Score 0-100 that reflects the confidence, accuracy, and deliverability for the input postal address. Score 0-100
97 Name To Phone Using Infutor's identity graph, the "Name" to "Phone" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Phone" on a scale from 0 – 100. Score 0-100
98 Name To Second Phone Using Infutor's identity graph, the "Name" to "Second Phone" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Second Phone" on a scale from 0 – 100. Score 0-100
99 Name To Email Using Infutor's identity graph, the "Name" to" Email" verifies the quality of the of the input identity by scoring the linkage of the "Name" to "Email" on a scale from 0 – 100. Score 0-100
100 Name To Address Using Infutor's identity graph, the "Name" to "Address" verifies the quality of the input identity by scoring the linkage of the "Name" to "Address" on a scale from 0 – 100. Score 0-100
101 Address To Phone Using Infutor's identity graph, the "Address" to "Phone" verifies the quality of the input identity by scoring the linkage of the "Address" to "Phone" on a scale from 0 – 100. Score 0-100
102 Address To Second Phone Using Infutor's identity graph, the "Address" to "Second Phone" verifies the quality of the of the input identity by scoring the linkage of the "Address" to "Second Phone" on a scale from 0 – 100. Score 0-100
103 Address To Email Using Infutor's identity graph, the "Address" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Address" to "Email" on a scale from 0 – 100. Score 0-100
104 Phone To Email Using Infutor's identity graph, the "Phone" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Phone" to "Email" on a scale from 0 – 100 . Score 0-100
105 Second Phone To Email Using Infutor's identity graph, the "Second Phone" to "Email" verifies the quality of the of the input identity by scoring the linkage of the "Second Phone" to "Email" on a scale from 0 – 100 Score 0-100
106 Deceased The deceased field is used to determine if an identity is living or deceased. A score of 100 represents the individual is living and a score of 0 represents the individual is deceased. If the field is Blank, it means Unknown 0 or 100 or Blank
107 USLocation The "US Location" field is used to determine if an identities' IP Address is recognized to be within USA. A score of 100 represents the individual's IP Address is recognized to be within USA. 0 or 100
108 Valid Count A count of the number of Validation Components which returned a positive verification. Decimal value, 0-5.
109 Linkage Count A count of the number of Linkage Components which returned a positive verification. Decimal value, 0-9.
110 Risk Flag Count A count of the number of Risk Flag Components which returned a positive verification. Decimal value, 0-2.
111 Validation Summary A summary of the Validation Components results. Pass, Fail, or Inconclusive
112 Linkage Summary A summary of the Linkage Components results. Pass, Fail, or Inconclusive
113 Risk Flag Summary A summary of the Risk Flag Components results. Pass, Fail, or Inconclusive
114 ID Verify Score The validation scores validate the quality of the of the input contact data by scoring the formatting of the data on a scale from 0 – 100; 0 being the worse, and 100 being the best. Score 0-100
115 Property Type Indicator Property type indicator, 2 digit numeric:10 = Single Family Residence / Townhouse11 = Condominium (residential)20 = Commercial21 = Duplex, Triplex, Quadplex22 = Apartment23 = Hotel, Motel24 = Commercial (condominium)25 = Retail26 = Services (general public)27 = Office Building28 = Warehouse29 = Financial Institution30 = Hospital (medical complex, clinic)31 = Parking32 = Amusement – Recreation50 = Industrial51 = Industrial Light52 = Industrial Heavy53 = Transport54 = Utilities70 = Agricultural80 = Vacant90 = Exempt nn
116 Land plus Improvement Value The “total” (i.e., land + improvement) value closet to current market value used for assessment by county or local taxing authorities. Integer (dollars)
117 Improvement Value The “improvement” value closest to current market value used for assessment by county or local taxing authorities. Integer (dollars)
118 Improvement Value Indicator The “improvement” value indicatorA = AssessedM = MarketP = AppraisedT = Transitional A, M, P, or T
119 Assessed Value The Total Assessed Value of the Parcel's Land & Improvement values as provided by the county or local taxing/assessment authority. Integer (dollars)
120 Length of Residence Length of Residence in years, 2 digits. 00 - 99
121 Homeowner H=Homeowner, R=Renter, A=Likely Homeowner, B=Likely Renter H, R, A or B
122 Dwelling Type Dwelling Type. S=Single Family Dwelling Unit (SFDU). M=Multi-family Dwelling Unit (MFDU). S or M
123 Total Acres Total land mass in acres. (4 decimal points). Example: 13000=1.3 acres. Integer
124 Land Square Feet Total land mass in Square Feet. Integer
125 Year Built The construction year of the original building. (e.g., YYYY). YYYY
126 Living Square Feet The area of a building that is used for general living. This is typically the area of a building that is heated or air conditioned and does not include Garage, Porch or Basement square footage. Integer
127 Number of Rooms Total number of rooms contained in the primary building. Integer
128 Number of Bedrooms Total number of bedrooms contained in the primary building. Integer
129 Number of Bathrooms Total number of bathrooms, 2 implied decimal places. 2.00 baths = 200. Integer
130 Total Full baths Total number of Full Baths (typically comprised of a sink, toilet, and bathtub / shower stall). A home containing 2 1/2 baths would have the number 2 stored in this field. Integer
131 Total Half baths Total number of Half Baths (typically comprised of a sink & toilet). A home containing 2 1/2 baths would have the number 1 stored in this field. Integer
132 Air Conditioning Type The type of air conditioning method used to cool the building(e.g., Central, Wall Unit, Evaporative):0=AC.NONEACA=AC.COMMERCIAL A/CACE=AC.CENTRALACH=AC.CHILLED WATERACP=AC.CENTRAL PARTIALACW=AC.CENTRAL & UNITADU=AC.DUAL UNITAEV=AC.EVAPORATIVEAFA=AC.FAN COOLINGAHT=AC.HEAT PUMPAOF=AC.OFFICE ONLYAPF=AC.REFRIGERATIONAPK=AC.PACKAGEAPR=AC.PACKAGE ROOFAPT=AC.PARTIALAPV=AC.REFRIGERATION/EVAPORATIONASE=AC.SEPARATE SYSTEMASO=AC.SOLARASP=AC.SPLIT SYSTEMAWA=AC.WALL UNITAWI=AC.WINDOW UNITAWN=AC.WALL/WINDOW UNIT nnn(3 characters)
133 Presence of Fireplace This field is populated with a "Y" if a fireplace is located within the building. Y or blank
134 Presence of Pool Populated with a "Y" if a Pool is present on the parcel. Y or blank
135 Roof Type 999=BYPASS9A0=IRREGULAR9B0=LEAN TOA=A-FRAMEB=BARNC=CANOPYD=DORMERE=FRAMEF=FLATG=GABLEH=GABLE/HIPI=HIPJ=GEODESICK=MANSARDL=BARRELM=MONITORN=CONTEMPORARYO=SHEDP=PITCHEDQ=PYRAMIDR=ARCHEDS=SAWTOOTHT=CATHEDRAL/CLERESTORYU=BUBBLEV=GAMBRELW=SWISS CHALET/ALPINEX=COMPLEX/CUSTOMY=BUTTERFLYZ=GAMBREL/MANSARD nnn(3 characters)
136 Tax Amount The tax amount provided by the county or local taxing / assessment authority Integer (dollars)
137 Recording Date The date the sales transaction was record at the county YYYYMMDD
138 Sell Price Price of the sale as depicted on the recorded sales transaction. Integer (dollars)
139 Mortgage Amount Amount of loan. Integer (dollars)
140 Mortgage Date Date mortgage was initiated. YYYYMMDD
141 Mortgage Term The length of time of the mortgage in years. Integer (years)
142 Mortgage Due Date Date mortgage becomes due. YYYYMMDD
143 Gender M=male, F=Female, blank or U=unknown. M, F, or U
144 Age Adult age. 0 - 99
145 Median Year Built The year home was built. 4 digits. nnnn
146 Estimated Household Income Estimated household income, 1 character:A = Less than $20,000B = $20,000 - $29,999C = $30,000 - $39,999D = $40,000 - $49,999E = $50,000 - $74,999F = $75,000 - $99,999G = $100,000 - $124,999H = $125,000 or more A - I
147 Marital Status M=Married, S=Single, A=Likely Married, B=Likely Single. M, S, A, or B
148 Wealth Score Model based on income, homeownership, and other assets owned:A = Estimated Net less than $5,000B = Estimated Net $5,000 - $19,999C = Estimated Net $20,000 - $49,999D = Estimated Net $50,000 – $79,999E = Estimated Net $80,000 - $99,999F = Estimated Net $100,000 - $249,999G = Estimated Net $250,000 - $499,999H = Estimated Net over $500,000 A - H
149 Home Market Value Estimated Home Market value:A = $1,000 - $24,999B = $25,000 - $49,999C = $50,000 - $74,999D = $75,000 - $99,999E = $100,000 - $124,999F = $125,000 - $149,999G = $150,000 - $174,999H = $175,000 - $199,999I = $200,000 - $224,999J = $225,000 - $249,999K = $250,000 - $274,999L = $275,000 - $299,999M = $300,000 - $349,999N = $350,000 - $399,999O = $400,000 - $449,999P = $450,000 - $499,999Q = $500,000 - $749,999R = $750,000 - $999,999S = $1,000,000+ A - S
150 Presence of Children Presence of Children. Y= Children present. Y or blank
151 Number of Children Number of Children. A=No Children, B=less than 3, C= 3-5 Children. A – C
152 Median House Value Median House Value Code:A = Less than $50,000B = $50,000 - $99,999C = $100,000 - $149,999D = $150,000 - $249,999E = $250,000 - $349,999F = $350,000 - $499,999G = $500,000 - $749,999H = $750,000 - $999,999I = $1,000,000+ A – I
153 Median Years of School Median years of school, 3 digits max. 1 implied decimal. eg 210 = 21.0 years 000-220
154 GEO Credit **This is a premium attribute field available only by subscription. Contact Infutor Sales for more information. Purchasing Power Model refers to the GEO Credit Score, 1 character:A = (820-High)B = (800-819)C = (780-799)D = (760-779)E = (740-759)F = (720-739)G = (700-719)H = (680-699)I = (660-679)J = (640-659)K = (620-639)L = (600-619)M = (580-599)N = (560-579)O = (540-559)P = (520-539)Q = (500-519)R = (480-499)S = (460-479)T = (Low-459) A - T
155 Phone Type Phone type for the Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
156 Second Phone Type Phone type for the 2nd Phone. L=Landline, V=VoIP, W=Wireless, O=Other. L, V, W, O
157 Auto Make Vehicle Make, 30 characters max. String value
158 Auto Model Vehicle Model, 30 characters max. String Value
159 Auto Year Vehicle Year YYYY
160 Auto Class Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
161 Auto Fuel Type Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
162 Auto MFG Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
163 Auto Style Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
164 Mileage Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
165 Last Verified Date Last verification date. YYYYMMDD
166 Second Auto Make Second Vehicle Make, 30 characters max. String value
167 Second Auto Model Second Vehicle Model, 30 characters max. String Value
168 Second Auto Year Second Vehicle Year YYYY
169 Second Auto Class Second Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
170 Second Auto Fuel Type Second Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
171 Second Auto MFG Second Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
172 Second Auto Style Second Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
173 Second Auto Mileage Second Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
174 Second Auto Last Verified Date Second Vehicle Last verification date. YYYYMMDD
175 Third Auto Make Third Vehicle Make, 30 characters max. String value
176 Third Auto Model Third Vehicle Model, 30 characters max. String Value
177 Third Auto Year Third Vehicle Year YYYY
178 Third Auto Class Third Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
179 Third Auto Fuel Type Third Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
180 Third Auto MFG Third Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
181 Third Auto Style Third Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
182 Third Auto Mileage Third Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
183 Third Auto Last Verified Date Third Vehicle Last verification date. YYYYMMDD
184 Fourth Auto Make Fourth Vehicle Make, 30 characters max. String value
185 Fourth Auto Model Fourth Vehicle Model, 30 characters max. String Value
186 Fourth Auto Year Fourth Vehicle Year YYYY
187 Fourth Auto Class Fourth Vehicle Class CodeCROSSOVERFULL SIZE CARFULL SIZE SUVFULL SIZE TRUCKFULL SIZE VANMID SIZE CARMID SIZE TRUCKMID SIZE SUVMINIVANSMALL CARSMALL SUVSMALL TRUCK 15 characters
188 Fourth Auto Fuel Type Fourth Vehicle Fuel Code:B - BiodieselcolumnD - DieselF - Flex-FuelG – GasolineH - Fuel CellI - Plug-In ElectricL - Electric/GasN - CNG (Compressed Natural Gas)P - PropaneY - Hybrid B, D, F, G, H, I, L, N, P, Y
189 Fourth Auto MFG Fourth Vehicle Manufacturing CodeA - AntiqueC - Chrysler ProductsF - Ford ProductsG - GM ProductsH - High end ImportsL - Low End ImportsO - Other A, C, F, G, H, L, O
190 Fourth Auto Style Fourth Vehicle Style Code:CONVCOUPECUVHATCHBACKLUXURYPICKUPSEDANSPORTUTILVAN 10 characters
191 Fourth Auto Mileage Fourth Vehicle Mileage from the last odometer reading in increments of 10,000.A=0-10,000. Z= 250,000+. A-Z
192 Fourth Auto Last Verified Date Fourth Vehicle Last verification date. YYYYMMDD
193 IP Address IP v4 address. xxx.xxx.xxx.xxx IP v4 address
194 Region Region. State name if within the US. 50 characters
195 IP City Approximate city the IP address is located within. 28 characters
196 IP Zip Approximate latitude of the IP address. 11 characters
197 Latitude Approximate longitude of the IP address. 11 characters
198 Longitude Approximate Zip code associated with the IP address. 5 characters
199 Internet Provider Internet service provider responsible for the IP address 255 characters
200 IP From Starting IP of the range that the IP address belongs xxx.xxx.xxx.xxx IP v4 address
201 IP To Final IP of the range that the IP address belongs xxx.xxx.xxx.xxx IP v4 address

Appendix A: Demographic Tag Descriptions

The following is a table of demographic tag descriptions.
XML Tag Name Description Description
Percent Range Black Percent Range Black Penetration Range - See Below
Percent Range White Percent Range White Penetration Range - See Below
Percent Range Hispanic Percent Range Hispanic Penetration Range - See Below
Percent Range Asian Percent Range Asian Penetration Range - See Below
Percent Range English Speaking Percent Range English Speaking Penetration Range - See Below
Percentage Range Spanish Speaking Percentage Range Spanish Speaking Penetration Range - See Below
Percent Range Asian Speaking Percent Range Asian Speaking Penetration Range - See Below
Percentage Range SFDU Percentage Range SFDU Penetration Range - See Below
Percent Range MFDU Percent Range MFDU Penetration Range - See Below
Mail Order Respondent Mail Order Respondent Percent Penetration Range - See Below
Percent Range Automobile Owner Percent Range Automobile Owner Penetration Range - See Below
Penetration Range White Collar Penetration Range White Collar Penetration Range - See Below
Penetration Range Blue Collar Penetration Range Blue Collar Penetration Range - See Below
Penetration Range Other Occupation Penetration Range Other Occupation Penetration Range - See Below
 
Penetration Percentage Ranges
A Greater than 95 K 50 thru 46
B 95 thru 91 L 45 thru 41
C 90 thru 86 M 40 thru 36
D 85 thru 81 N 35 thru 31
E 80 thru 76 O 30 thru 26
F 75 thru 71 P 35 thru 21
G 70 thru 66 Q 20 thru 16
H 65 thru 61 R 15 thru 11
I 60 thru 56 S 10 thru 06
J 55 thru 51 T Less than 6

Appendix B: Match Score Descriptions

Category Description Score Description
IE = Individual with Email 100 Exact First, Exact Last, Exact Street Address, Unit W/A, Zip
IP = Individual with Phone 101 Fuzzy First, Exact Last, Exact Street Address, Unit W/A, Zip
IEP = Individual with Email and Phone 102 Exact First, Fuzzy Last, Exact Street Address, Unit W/A, Zip
103 Fuzzy First, Fuzzy Last, Exact Street Address, Unit W/A, Zip
104 Exact First, Exact Last, Exact Street Address, Unit Missing, Zip
105 Fuzzy First, Exact Last, Exact Street Address,Unit Missing, Zip
106 Exact First, Fuzzy Last, Exact Street Address, Unit Missing, Zip
107 Fuzzy First, Fuzzy Last, Exact Street Address, Unit Missing, Zip
108 Exact First, Exact Last, Fuzzy Street Address, Zip
109 Fuzzy First, Exact Last, Fuzzy Street Address, Zip
110 Exact First, Fuzzy Last, Fuzzy Street Address, Zip
111 Fuzzy First, Fuzzy Last, Fuzzy Street Address, Zip
HE = HouseHold with Email 200 Exact Last, Exact Street Address, Unit W/A, Zip
HP = HouseHold with Phone 201 Fuzzy Last, Exact Street Address, Unit W/A, Zip
HEP = HouseHold with Email and Phone 202 Exact Last, Exact Street Address, Unit Missing, Zip
203 Fuzzy Last, Exact Street Address, Unit Missing, Zip
204 Exact Last, Fuzzy Street Address, Zip
205 Fuzzy Last, Fuzzy Street Address, Zip
AE = Address with Email 300 Exact Street Address, Unit W/A, Zip
AP = Address with Phone 301 Exact Street Address, Unit Missing, Zip
AEP = Address with Email and Phone 302 Fuzzy Street Address, Zip
NP = Name/Phone 400 Exact First, Exact Last, Phone
401 Fuzzy First, Exact Last, Phone
402 Exact First, Fuzzy Last, Phone
403 Fuzzy First, Fuzzy Last, Phone
LP = Last/Phone 450 Exact Last, Phone
451 Fuzzy Last, Phone
NE = Name/Email 470 Exact First, Exact Last, Email
471 Fuzzy First, Exact Last, Email
472 Exact First, Fuzzy Last, Email
473 Fuzzy First, Fuzzy Last, Email
NEP = Name/Email with phone 470 Exact First, Exact Last, Email, Phone
471 Fuzzy First, Exact Last, Email, Phone
472 Exact First, Fuzzy Last, Email, Phone
473 Fuzzy First, Fuzzy Last, Email, Phone
LE = Last/Email 480 Exact Last, Email
481 Fuzzy Last, Email
LEP = Last/Email with Phone 480 Exact Last, Email Phone, Email
481 Fuzzy Last, Email Phone, Email
FP = First/Phone 460 Exact First, Phone
461 Fuzzy, Phone
FE = First/Emaill 490 Exact First, Email
491 Fuzzy First, Email
FEP = First/Email with Phone 490 Exact First, Email, Phone, Email
491 Fuzzy First, Email, Phone, Email
EP = Email with Phone 900 Phone with Email Verified
P 900 Phone Verified
E 900 Email Verified
X or none 999 No match found

Appendix C: Connex Clusters

These are optional fields which provide Groups of consumers that have been segmented based on demographics, psychographics and media consumption, among other lifestyle traits. Please contact Infutor Sales to request these fields.
Field Description
Household Cluster Name Precisely segment and deliver targeted communications at the household level with similar demographics, behaviors, attitudes, preferences, buying habits and media consumption.
Household Cluster Code Assigned code for HouseholdCluster
Detailed Household Cluster Name Precisely segment and deliver targeted communications at the household level with similar demographics, behaviors, attitudes, preferences, buying habits and media consumption.
Detailed Household Cluster Code Assigned detail cluster code for HouseholdCluster
Neighborhood Cluster Name Drive geo-based audience segmentation strategies that maximize your marketing budget when household-level targeting is not an option.
Neighborhood Cluster Code Assigned cluster code for NeighborhoodCluster
Family Cluster Name Ideal for higher-level strategic segmentation and understanding of larger customer groups including categorizing household-level clusters into a broad category of similar audience segments.
Family Cluster Code Assigned cluster code for FamilyCluster
Messaging Cluster Name Ideal for increasing the relevance of offers by tailoring the message to the unique profile of differing customer and prospect segments.
Messaging Cluster Code Assigned cluster code for MessagingCluster
Digital Cluster Name Target consumers based on their online social media and mobile behaviors, preferences and buying habits.
Digital Cluster Code Assigned cluster code for DigitalCluster
Generation Cluster Name Ideal for reaching consumers at specific life stages, as well as for marketing strategies that align with generational attitudes and experiences.
Generation Cluster Code Assigned cluster code for GenerationCluster
Generation Group Code Assigned cluster code for GenerationCluster
Lifestage Cluster Name Develop messaging strategies based on significant milestones in consumers' lives including career, marriage, Children, retirement, and more.
Lifestage Cluster Code Assigned cluster code for LifestageCluster
Lifestage Group Code Assigned group code for LifestageCluster