What Type Of Data Can I Clean?

Sunshine on Transformania

Sales and marketing is a journey, not a destination. And we appreciate you sharing your journey to greater ROI with your friends at Transformania!

Not only do we clean your important marketing contact data, we format it too. And the details below will show you how we can help process your data quickly and securely.

You can upload a spreadsheet with lots of columns of data and then you can map to our data columns.

Or, to make things even faster, you can use our Transformania Source File Template and paste your contacts into the appropriate columns before you upload to our platform. Download it from here.

 

Here is a list of all the columns of data you can clean:

Source Full Name (Example: Dr. Robert J. Smith III)

A contact’s full name. Must include a first and last name at a minimum but can also include a middle name, nickname, prefix (e.g. Mr., Mrs., Dr., etc.), and suffix (e.g. Jr., III, PhD, etc.)

For a particular contact, this column can be empty provided that both the Source First Name and Source Last Name columns are not empty.

 

Source First Name (Example: Robert)

A contact’s first name.

Can be empty unless Source Full Name column is empty. Data in this column is ignored if Source Full Name is not empty.

 

Source Middle Name (Example: J.)

Can be empty. Data in this column is ignored if Source Full Name is not empty.

 

SpreadsheetSource Last Name (Example: Smith)

A contact’s last name.

Can be empty unless Source Full Name column is empty. This column is ignored if Source Full Name is not empty.

 

Source Prefix (Example: Mr., Ms., Dr., etc.)

Can be empty. Data in this column is ignored if Source Full Name is not empty.

 

Source Suffix (Example: Jr, III, PhD, etc.)

Can be empty. Data in this column is ignored if Source Full Name is not empty.

 

Source Job Title (Example: Director of Public Relations)

Can be empty.

 

Source Organization (Example: Nike, Inc.)

Can be empty. 

 

Source Full Address (Example: 123 Main Street, Miami, FL 33155)

For a particular contact, this column can be empty provided that both the Source Address1, Source City, Source State, and Source ZIP Code columns are not empty. If all of the key address columns (Source Full Address, Source Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

Source Address1 (Example: 123 Main Street)

Can be empty unless Source Full Address column is empty. Data in this column is ignored if Source Full Address is not empty. If all of the key address columns (Source Full Address, Source Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact. 

Source Address2 (Example: Suite 800)

Can be empty. Data in this column is ignored if Source Full Address is not empty.

 

Source City (Example: Miami)

Can be empty unless Source Full Address column is empty. Data in this column is ignored if Source Full Address is not empty. If all of the key address columns (Source Full Address, Source Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source State (Example: FL or Florida)

Can be empty unless Source Full Address column is empty. Data in this column is ignored if Source Full Address is not empty. If all of the key address columns (Source Full Address, Source Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source ZIP Code (Example: 33155)

Can be empty unless Source Full Address column is empty. Data in this column is ignored if Source Full Address is not empty. If all of the key address columns (Source Full Address, Source Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source Email (Example: [email protected])

Can be empty. If empty, Transformania will not perform email address-dependent functions on that contact.

 

Source Phone (Example: 390-888-3123)

Can be empty. If empty, Transformania will not perform phone number–dependent functions on that contact.

 

Source Distance Full Address (Example: 123 Main Street, Miami, FL 33155)

Can be empty. If provided, Transformania will calculate the distance and driving time between this address and the contact’s address.

This column can be empty provided that both the Source Distance Address1, Source Distance City, Source Distance State, and Source Distance ZIP Code columns are not empty. If all of the key distance address columns (Source Distance Full Address, Source Distance Address1, Source Distance City, Source Distance State, and Source Distance ZIP Code) are empty, Transformania will not calculate distance and drive time for that contact.

 

Source Distance Address1 (Example: 123 Main Street)

Can be empty unless Source Distance Full Address column is empty. Data in this column is ignored if Source Distance Full Address is not empty. If all of the key address columns (Source Distance Full Address, Source Distance Address1, Source City, Source State, and Source ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source Distance Address2 (Example: Suite 800)

Can be empty. Data in this column is ignored if Source Distance Full Address is not empty.

 

Source Distance City (Example: Miami)

Can be empty unless Source Distance Full Address column is empty. Data in this column is ignored if Source Distance Full Address is not empty. If all of the key address columns (Source Distance Full Address, Source Distance Address1, Source Distance City, Source Distance State, and Source Distance ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source Distance State (Example: FL or Florida)

Can be empty unless Source Distance Full Address column is empty. Data in this column is ignored if Source Distance Full Address is not empty. If all of the key address columns (Source Distance Full Address, Source Distance Address1, Source Distance City, Source Distance State, and Source Distance ZIP Code) are empty, Transformania will not perform address-related functions for that contact.

 

Source Distance ZIP Code (Example: 33155)

Can be empty unless Source Distance Full Address column is empty. Data in this column is ignored if Source Distance Full Address is not empty. If all of the key address columns (Source Distance Full Address, Source Distance Address1, Source Distance City, Source Distance State, and Source Distance ZIP Code) are empty, Transformania will not perform address-related functions for that contact.