Follow

What does the visitor data export file look like?

When exporting visitor data from the Scan2Lead PORTAL an excel file named Company Name - VisitorData_YYYY.MM.DD_HH.MM.SS.xlsx is downloaded to the local download folder of your PC.

Note: The export includes all listed visitor data. In case a filter is applied, only filtered data will be exported.

Personal details:

Salutation
Title
First Name
Last Name

transferred from visitor registration or manualy captured

Company
Profession
Position

transferred from visitor registration or manualy captured
Category Visitor (default) / Exhibitor / Press / VIP automatically assigned, defined by Organizer

Contact details:

Phone / Mobile / E-Mail / Fax / Website 

transferred from visitor registration or manualy captured

Street / Zip / City / Country

transferred from visitor registration or manualy captured

Country Iso / Continent 

automatically selected through Country

Language 

transferred from visitor registration or manualy captured

Additional information:

Rating 

0 to 5, manually captured

Note 

manually added notes

OcrResult 

result of OCR business card scan

Has Attachments 

True / False (Yes / No)

Invited From You

True / False (Yes / No)

VoucherCode 

if Invited from you is True, the voucher code is displayed

Capture information: 

Manually Added 

True / False (Yes / No)

Created 

date and time of registration or manual capturing

Scanned At 

date and time of scan or manual capturing

Modified

Date and time of change

Device ID

ID of device that captured the data

Device Name 

Name of device (can be defined in Configuration - My devices)

ID 

visitor ID created through scan or manual capture, is the same when visitor is scanned a second time

Source ID 

Uniqe customer ID (depends on ticket system)

ScannID

consecutive scanning ID (when record is created)

Lead Form information: 

Each question and its answer is listed in an own column. Colours indicate answers to one question. 

Example
Follow Up Actions > meeting required

Follow Up Actions > regular contact
Follow Up Actions > send offer 
Follow Up Actions > send catalog 
Follow Up Actions > forward to  

Visitor survey information: 

If visitor survey data from registration is made available by the organizer, the information is listed. These columns are added after the lead form columns.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk