How does the visitor data export file look like?

How 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


Captured 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 scanned)

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 > regulat contact
Follow Up Actions > send offer 
Follow Up Actions > send catalog 
Follow Up Actions > forward to  

Visitor survery 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.

    • Related Articles

    • How can I export my visitor data?

      To download your visitor data login with your credentials at the Scan2Lead PORTAL select menu Visitor Data and select Visitor Data Click the Button Export to Excel to download the list of displayed visitors Once the download has finished you will ...

    • How can I export visitor data from the Scan2Lead STATION?

      You do not have an export functionality at the Scan2Lead STATION, as all solutions for capturing visitor data synchronize the captured data to the central online portal Scan2lead PORTAL The Scan2Lead PORTAL is the central administrative site for ...

    • What options do I have to capture visitor data at my booth?

      Scan2Lead offers 3 different solutions to capture data from visitors at your booth. 1. Scan2Lead SMART With the Scan2Lead SMART app on your smartphone or tablet (Apple and Android), simply hold the camera of your smartphone/tablet up to the barcode ...

    • How can I filter visitor data?

      In order to use the filter functions please visit Scan2Lead PORTAL and select 'Visitor Data' - 'Visitor Data' to find the filter symbols underneath the menu bar. You have 6 different filters to use:  Quality of visitor data received    Lead Form - ...

    • What is the visitor survey?

      If visitor survey data, answered by the visitor during the registration process, is made available by the organizer, the information is listed when editing a visitor in the Scan2Lead PORTAL. As soon as you export the visitor data, these columns are ...