Difference between revisions of "LeadGen Business:List/File"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[LeadGen Xpress|← LeadGen Xpress]]
{{LGXBusinessNav}}
 
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''LeadGen Xpress Business Navigation'''
|-
| style="padding-right:220px;"|
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[LeadGen Xpress:Business|Introduction]]
|-
|[[LeadGen Xpress:Business#Calls|Business Calls]]
|-
|[[LeadGen Xpress:Business#Request Format|Request Format]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[LeadGen Xpress:Business:Request Parameters|Request Parameters]]
|-
|[[LeadGen Xpress:Business:Request Parameters#Standard Components|Standard Components]]
|-
|[[LeadGen Xpress:Business:Request Parameters#Actions|Actions]]
|-
|[[LeadGen Xpress:Business:Request Parameters#Authentication|Authentication]]
|-
|[[LeadGen Xpress:Business:Request Parameters#Geographic Types|Geographic Types]]
|-
|[[LeadGen Xpress:Business:Request Parameters#Options|Options]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[LeadGen Xpress:Business:Response|XML Response]]
|-
|[[LeadGen Xpress:Business:Response#Examples|Examples]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[LeadGen Xpress:Business:List/File|List/File]]
|-
|[[#File Types|File Types]]
|-
|[[#Columns in File|Columns in File]]
|}
|-
|[[LeadGen Xpress:Business:Result Codes|Business Result Codes]]
|}




Line 60: Line 8:
!File Format
!File Format
!style="border-right:0px;"|Value to Specify in URL
!style="border-right:0px;"|Value to Specify in URL
|-
|Zipped .dbf
|file=1
|-
|-
|Zipped .txt
|Zipped .txt
Line 72: Line 17:
|Zipped .xls
|Zipped .xls
|file=5
|file=5
|-
|.dbf
|file=6
|-
|-
|.txt
|.txt
Line 227: Line 169:




[[Category:LeadGen Xpress]]
[[Category:LeadGen]]
[[Category:LeadGen Xpress Business]]
[[Category:LeadGen Business]]

Latest revision as of 17:05, 12 May 2016

← LeadGen Cloud API

LeadGen Business Navigation
Introduction
Request Parameters
XML Response
List/File
Business Result Codes



File Types

File Format Value to Specify in URL
Zipped .txt file=2
Zipped .csv file=3
Zipped .xls file=5
.txt file=7
.csv file=8
.xls file=10


Columns in File

Column Max Length Description
Business 30 Business name
Contact 26 Name of contact person
Gender 1 M or F
Address 50 Mailing address
City 35 Mailing City
State 2 Mailing State
Zip 5 Mailing Zip
Plus4 4 Mailing Zip4
CART 4 Mailing Carrier Route
DPB 3 Mailing Delivery Point
SIC 6 This field contains the 6-digit SIC code for the business's primary activity (line of business). Approximately 79% of the records in the US business database have only 1 SIC Code.
SIC2 6 This field contains the 6-digit SIC code for the business's secondary activity (line of business). Approximately 23% of the records in the US business database have 2 SIC Codes.
SIC3 6 This field contains the 6-digit SIC code for the business's tertiary activity (line of business). Approximately 8% of the records in the US business database have 3 SIC Codes.
SIC4 6 This field contains the 6-digit SIC code for the business's quaternary activity (line of business). Approximately 3% of the records in the US business database have 4 SIC Codes.
EmpSize 1

This field contains an alpha code for the number of employees that work at this particular location.

  1. 1 - 4
  2. 5 - 9
  3. 10 - 19
  4. 20 - 49
  5. 50 - 99
  6. 100 - 249
  7. 250 - 499
  8. 500 - 999
  9. 1,000 - 4,999
  10. 5,000 - 9,999
  11. 10,000 +
SlsVol 1

This field contains an alpha code corresponding to the estimated sales of the business in thousands of dollars. Sales are based on this particular business location only.

  1. 1 - 499
  2. 500 - 999
  3. 1,000 - 2,499
  4. 2,500 - 4,999
  5. 5,000 - 9,999
  6. 10,000 - 19,999
  7. 20,000 - 49,999
  8. 50,000 - 99,999
  9. 100,000 - 499,999
  10. 500,000 - 999,999
  11. 1,000,000 +
Phone 10 This field contains the phone number on file for the business
fax 10 This field contains the fax number on file for the business (if in data)
NAICS 8 This field contains the 8-digit NAICS code for the business's primary activity
NAICS2 8 This field contains the 8-digit NAICS code for the business's secondary activity
NAICS3 8 This field contains the 8-digit NAICS code for the business's tertiary activity
NAICS4 8 This field contains the 8-digit NAICS code for the business's quaternary activity
NAICS5 8 This field contains the 8-digit NAICS code for the business's quinary activity
KeyExec 30 This field contains the Key Executive of the business.
NumEmp 6 This field contains the actual number of employees working at the business
EstSales 9 This field contains the estimated sales volume of the company in thousands.