InsideView Target Fields and Datatypes Mappings in the Export File

Follow

InsideView Target identifies and corrects bad data in your Salesforce CRM, Eloqua and Marketo application supplies missing information, and maintains the accuracy of data via regular updates. Given as little as a company name or email domain, InsideView Target will update those accounts with company and contact data, and then push the updates and matches for that company and contact record with all relevant fields available in the InsideView database—allowing your organization to properly route and score the company. 

To learn how to export a company or contact data, read the article How to Export List of Companies or People from InsideView Target in our Knowledge Base.

The tables below summarize the InsideView fields with their descriptions and the datatype to which they are mapped in your Salesforce CRM, Eloqua and Marketo applications.

For more information on InsideView accuracy benchmarks and data management methodologies, please visit http://www.insideview.com/reliability/.

Contact/Executive Details

InsideView Field Description Salesforce CRM Datatype Mapping Export/Sync

First Name

The first name of a contact

String, Picklist, and Multipicklist

 Yes

Last Name

The last name of a contact

String

Yes

Title

The job title of a contact. For example, the title field will shows, vice president or Chief Executive Officer

String, Picklist, and Multipicklist

 Yes

Biography

A short biography of the contact that is retrieved from the data sources.

String

Yes 

Email

The email address of the contact. 

String

Yes

Job Level

The job level of the contact. For example, Director-Sales or Director-Marketing

String 

Yes

Job Function

The job function of the contact. For example, Sales, Finance, or IT

String

Yes

Executive City

The city to which an executive belongs. For example, New York

String

Yes

Executive State

The state from where an executive hails. For example, California.

String

Yes

Executive Country

The country of an executive.

String

Yes

Last Validated Date

The date when the executive's record was last validated.

String 

Yes

InsideView Executive ID

The unique identifier of an executive in InsideView's database.

String

Yes

InsideView Employment ID

The unique identifier of an executive's employment in the InsideView database.

String

Yes

IMPORTANT: Please refer to the Company Location Details and Company Firmographics Data tables below for the company fields that can be exported from InsideView Target. The company fields are same in the Contact data file exported.


Company Location Details

The Company Name field is mandatory to find a company account.

InsideView Field Description Salesforce CRM Datatype Mapping Export/Sync

City

The name of the city. For example, New York or San Francisco.

String, Picklist, and Multipicklist

 Yes

Street

The street name. It might include abbreviations. For example, Margaret Dr means Margaret Drive or Lincoln St means Lincoln Street.

Textarea

 No

State

An abbreviation of the state name. For example, NY means New York, and CA means California.

String, Picklist, and Multipicklist

 Yes

Country

The full name of the Country. For example, United States or Australia.

String, Picklist, and Multipicklist

Yes 

Postal Code

The postal code for the city. For example, postal code for New York is 10017

String and Multipicklist

Yes

Account Address

The company address of the company.

String 

Yes

Phone

The phone number of the company

String

Yes

Fax

The fax number of the company

String

Yes

Data Source

The data source from where the company details are retrieved

String

Yes

 

Company Firmographics Data

InsideView Field Description Salesforce CRM Datatype Mapping Export/Sync

InsideView Account ID

A unique identifier for the company in the InsideView database.

For example, Google’s InsideView ID is 736233.

String

 

Yes

Account/Company Name

The full name of a company that is refreshed.

String, Picklist, and Multipicklist

 Yes

Account/Company Status

The current status of a company that is refreshed.

Possible values are Operating, Subsidiary, and Acquired.

String, Picklist, and Multipicklist

No 

Account/Company Description

The detailed description of the company.

Text Area

Yes 

Primary Category

The primary category of a company

 

String

Yes

Parent Company Revenue

The annual revenue of a parent company in USD.

Currency 

 Yes

Account Annual Revenue

The annual revenue of a company in USD.

Currency

Yes 

Company Employee Count/ Number of Employees

Number of employees in a company. 

This number changes as when employees join or leave a company. The accuracy of this number is validated by our content team periodically to keep it current.

Integer and double  Yes 

Primary Business

The primary business identifies the actual business of that particular company, which can either be an industry or a sub-industry. 

For example, InsideView's primary business is "Internet Information Services", which is listed as a sub-industry under the "Media" industry.

Picklist Yes

Account Industry

The type of industry the company belongs to. 

For example, Google’s industry type is computer software: software & services.

Picklist  Yes

Account Website

The website URL of the company.

URL and String Yes 

Company Blog URL

The company’s blog website URL.

URL and String  

Company Facebook URL

The company’s Facebook page URL.

URL and String  

Company Twitter URL

The company’s Twitter page URL.

URL and String  

Equifax ID (EFX ID)

A unique Equifax identifier (EFX ID) for a company. 

For example, Google’s Equifax ID is 015875469.

 String, Picklist, and Multipicklist  Yes

Fiscal Year-End (FYE) Date

The fiscal year end month for a company   String, Picklist, and Multipicklist  

 Parent ID

The unique identifier of the parent company.  String  Yes 

Parent Name

The name of the parent company.

String Yes 

Account Primary NAICS Code

The six digit North American Industry Classification System (NAICS) code of the company. 

For example, Google’s NAICS code is 519130.

 String Yes 

Primary NAICS Description

The NAICS description of the company. 

For example, Google’s NAICS description is Internet Publishing and Broadcasting and Web Search Portals.

 String  

Account SIC Code

The four digit Standard Industrial Classification (SIC) code of the company. 

For example, Google’s primary SIC code is 7375.

 String Yes 

Primary SIC Description

The SIC description of the company. 

For example, Google’s SIC description is Information Retrieval Services.

 String  

Sub Category/ Industry

The sub industry type of the company. 

For example, InsideView's top-level industry type is Computer Software and sub-industry type is CRM (formerly a Sales Intelligence Software).

Picklist Yes 

Ultimate Parent ID

A unique identifier for the ultimate parent company in the InsideView database. 

For example, ASDA Financial Services, Limited'InsideView ID is 16088486. The ASDA Stores, Limited is the parent company of ASDA Financial Services. The parent company ID is 1264919.

The ASDA Stores, Limited is the subsidiary of the ASDA Group, whose ultimate parent company is Wal-Mart Stores, Inc and it's ID is 727545.

String Yes 

Ultimate Parent Name

The name of the ultimate parent company in a family tree.

For example, ASDA Financial Services Limited's ultimate parent company is Wal-Mart Stores, Inc as illustrated in the screen below:

 String  Yes

Parent Company City

The name of the parent company’s city. For example, New York or California.

String  

Parent Company Country

The full name of the parent company’s country. For example, United States or Australia

String   

Parent Company ID

A unique identifier for the parent company in the InsideView database.

String   

Parent Company Number of Employees

Number of employees in the parent company.

Integer and Double  

Parent Company Street

The street name of the parent company that might include abbreviations. For example, Margaret Dr means Margaret Drive or Lincoln St means Lincoln Street.

TextArea  

Parent Company State

An abbreviation of the state name for the parent company. For example, NY means New York, and CA means California.

String  

Parent Company Zip

The zip code of the parent company’s address.

String  

Account Ticker Symbol

The stock market ticker of the company. 

For example, Oracle’s stock market ticker is ORCL and Google’s ticker is GOOG.

String, Picklist and Multipicklist Yes

Technology

The type of technology company uses. For example, a company uses SQL Server.

String Yes

 

Was this article helpful?
0 out of 0 found this helpful
Powered by Zendesk