Data Mappings
| Mapping | Description | Example |
|---|---|---|
| Full Name | Person's full name | Satya Narayana Nadella |
| First Name | Person's first name | Satya |
| Last Name | Person's last name | Nadella |
| Middle Name | Person's middle name | Narayana |
| Initials | Person's initials | SN |
| Alternate Name | Person's alternate name | (None) |
| Picture URL | URL of person's picture |  |
| Phone
Local Format
|
Company's mainline number | (425) 882-8080 |
| Phone
International Format
|
Company's mainline number with country code | +1 425-882-8080 |
| Person's email address | satyan@microsoft.com | |
| Title | Person's current position at company | CEO |
| City | Person's current city | Redmond |
| State | Person's current state | Washington |
| Country | Person's country | United States |
| Country
ISO 3166-2 Format
|
Country under ISO3166 in A2 abbreviation | US |
| Country
ISO 3166-3 Format
|
Country under ISO3166 in A3 abbreviation | USA |
| Location | Person's location | Redmond, Washington |
| Timezone | Person's timezone | America/Los_Angeles |
| Timezone
Long Format
|
Person's timezone in human readable format | Pacific Standard Time |
| Timezone
Short Format
|
Person's timezone in short format | PST |
| Timezone
Offset to UTC
|
Person's timezone difference to UTC | -07:00 |
| Timezone
Offset to User's Local
|
Person's time zone difference to the Prospect user's local time | -03:00 |
| State
Long Format
|
Person's state | Washington |
| State
Short Format
|
Person's state two-character abbreviation | WA |
| Email Verified Status
Boolean
|
True if person's email address is verified, FALSE if unverified | TRUE |
| Email Verified Status
Short Text
|
YES if person's email address is verified, NO if email is unverified | YES |
| Email Verified Status
Descriptive Text
|
VERIFIED if person's email address is verified, SUGGESTED if email is unverified | VERIFIED |
| Twitter Screen Name | Person's Twitter handle | satyanadella |
| Current Position Duration | How long the person has been at this role | 5 years 4 months |
| Mapping | Description | Example |
|---|---|---|
| Company | Name Of Company | Microsoft |
| Company_Phone | Company Phone Number | 222 - 333 - 4444 |
| Company_Address_Country | Country of Company Address | United States |
| Company_Address_Country_ISO3166_A2 | Country of Company Address | US |
| Company_Address_Country_ISO3166_A2 | Country of Company Address | USA |
| Company_Address_Locality | City Of Company Adress | Chicago |
| Company_Address_Postal_Code | Postal Code Of Company Address | L3V 0N1 |
| Company_Address_Region | Company Address Region | Washignton |
| Company_Address_Region_ABBR | Company Address Region Abbreviation | WA |
| Company_Address_Street | Street of Company | 109 Berkshire Drive |
| Company_Address_Street2 | Street Of Company #2 | 902 Lnagley Road |
| Company_Address_Unparsed | Blank Company Address (user decides) | 90 Hungerford Road |
| Company_Founded | When Was the Company Founded | 2005 |
| Company_Industry | Industry of Company | Manufactoring |
| Company_Jobs_Posted | Jobs Posted by Company | 12 |
| Company_LinkedIn_Employee_Count | LinkedIn Employee Count of Company | 425 |
| Company_LinkedIn_ID | Company LinkedIn ID | 1035 |
| Company_LinkedIn_URL | Company LinkedIn URL | https://www.linkedin.com/sales/company/1035 |
| Company_Picture_URL | Company Picture URL | https://media-exp1.licdn.com/microsoft |
| Company_Size | Size of Company | 702 |
| Company_Size_Range | Size Range of Company | 150 - 250 |
| Company_Size_range_Without_Spaces_ Without_Text |
Size Range Of Company (Different Format) | 150-250 |
| Company_Size_Range_With_Spaces_With_Text | Size Range Of Company (Different Format) | 200- 250 Employes |
| Company_Size_Range_Max | Max Size Range of Company | 500 |
| Company_Size_Range_Min | Minimum Size Range of Company | 100 |
| Street | Street of Company | Langley Street West |
| Company_Website | Company Website | www.microsoft.com |
| Company_Website_Naked | Company Website Naked | microsoft.com |
| Location | Location Of Company | Toronto |
| Timezone | Time Zone Of Company | EST | ||
| Timezone_Long | Long Format Time Zone of Company | Eastern Standard Time | ||
| Timezone_Short | Short Format Of Time | EST | ||
| Timezone_Offset_UTC_DST | Timezone Offset from UTC DST | - 5:00 UTC | ||
| Timezone_Offset_Local | Timezone Offset to Local | 0:00 | ||
| City | City of Company | Toronto | ||
| State | State Of Company | Ontario | ||
| State_ABBR | State Abbreviation of Company | ONT | ||
| Postal_Code | Postal Code of | M5K 1E7 | ||
| Country | Country Of Company | Canada | ||
| Country_ISO3166_A2 | Country of Company 2 Abbreviations | CA | ||
| Country_ISO3166_A3 | Country of Company 3 Abbrevations | CAN | ||
| LinkedIn_ID | Company LinkedIn ID | 1035 | ||
| LinkedIn_URL | LinkedIn URL of Company | https://www.linkedin.com/sales/company/1035 | ||
| |
|
Other mappings go here