The cxConnect for Data Analysis data file export provides a streamlined method of integration. cxConnect for Data Analysis delivers session data to a series of flat data files in text format.
These flat data files can then be bulk-loaded into the destination database of choice, using customized versions of scripts provided by Tealeaf. Content in individual files can be filtered based on filters you specify in the task.
Note: For the Data File schema, all timestamps are in Greenwich Mean Time or the local time of the cxConnect for Data Analysis server.
To improve performance, this method uses a much more simplified schema. For session data, cxConnect for Data Analysis exports to seven different data files, each file containing a flat list of records for one database table. Each of the following session data types is exported to a separate data file.
Typically, these data files are stored in individual database tables, which enable simple and insertion into the destination database. These flat data files can be easily inserted into the destination database of your choice, by customizing and using the bulk-load scripts that are provided in the following directory:
<install_directory>\DataExtractor\Scripts
Session data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp
Note: If this field is included in the Session Data file, it is written as an extra field in each of the output files. This timestamp provides an easy means of clearing a external database of all related content based on this value. |
Session ID |
CANISTER_SESSION_ID |
Canister Session ID |
Canister server name |
CANISTER_SERVER |
Canister server name |
LSSN file name |
CANISTER_LSSN |
Canister file where session was extracted |
Remote address |
REMOTE_ADDRESS |
Remote IP address |
Session duration |
SESSION_DURATION |
Session duration (in seconds) |
Hit count |
HIT_COUNT |
Number of hits in this session |
HTTP user agent |
HTTP_USER_AGENT |
Web browser |
TLTSID |
TLTSID |
Tealeaf Session ID |
TLTUID |
TLTUID |
Tealeaf User ID |
TLTVID |
TLTVID |
Tealeaf Visitor ID |
Extract ID |
EXTRACTID |
Identifier for the Extractor task |
Tealeaf replay link |
TEALEAF_REPLAY |
Replay link |
Hit data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Hit Number |
HIT_NUMBER |
Sequence number of this hit within the session |
TLTHID |
TLTHID |
Tealeaf hit ID |
HTTP status |
HTTP_STATUS |
HTTP Status code |
HTTP secure |
HTTP_SECURE |
Indicates whether this was an HTTPS hit (secure). |
Hit duration |
HIT_DURATION |
Difference between the request and response time for a page view or hit (in milliseconds) |
Request method |
REQ_METHOD |
Examples: GET and POST |
URL |
URL |
URL string |
Referer |
REFERER |
Previous page
If the hit is an application-instrumented event, this value is |
Query string |
QUERY_STRING |
Hit query string |
Host name |
HOST_NAME |
Web server host |
Host IP |
HOST_IP |
Web server host IP |
Request time |
REQ_TIMESTAMP |
Time Stamp of first request packet |
Request end time |
REQ_END_TIMESTAMP |
Time Stamp of last request packetTime Stamp of last request packet |
Response start time |
RSP_START_TIMESTAMP |
Time Stamp of first response packet |
Response complete time |
RSP_TIMESTAMP |
Time Stamp of last response packet |
Response ack time |
RSP_ACK_TIMESTAMP |
Time Stamp of last response packet acknowledged by the browser |
Request size |
REQ_SIZE |
Size of the request (in bytes) |
Response size |
RSP_SIZE |
Size of the response (in bytes) |
Request cancel |
REQ_CANCELLED |
Possible values:
|
TTFB |
RSP_TTFB |
Time to First Byte |
TTLB |
RSP_TTLB |
Time to Last Byte |
TTLA |
RSP_TTLA |
Time to Last ACK |
Connection Speed |
CON_SPEED |
Connection speed |
Connection type |
CON_TYPE |
Connection speed text |
WS_GEN |
WS_GEN |
Web server generation time (in microseconds) |
NT_GEN |
NT_GEN |
Network generation time (in microseconds) |
RT_GEN |
RT_GEN |
Round-trip generation time (in microseconds) |
Response type |
RSP_TYPE |
Tealeaf response type |
Accept language |
ACCEPT_LANG |
Web browser accept language |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
CUI Render |
PAGE_RENDER |
Render time for the page, as extracted from client user interface events.
Data in this field requires licensing and implementation of CX UI Capture for AJAX. |
CUI Dwell |
PAGE_DWELL |
Page dwell time, as extracted from client user interface events.
Data in this field requires licensing and implementation of CX UI Capture for AJAX. |
Application data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Name |
NAME |
Application field name |
Value |
VALUE |
Application field value |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
Cookie data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Name |
NAME |
Cookie field name |
Value |
VALUE |
Cookie field value |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
URL field data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Name |
NAME |
URL field name |
Value |
VALUE |
URL field value |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
Event data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Event ID |
EVENT_ID |
Event ID |
Event text found |
TEXT_FOUND |
Event Text Found |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file |
JSON event data file
Note: Depending on how capture is configured on your system, the volume of events recorded per session can be large, which may result in a very large output file. Before performing a bulk extract through cxConnect, we recommend that you extract a single session containing UI events to assess storage requirements for larger extract operations.
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
JSON Data String |
DATA |
Maximum length of 512 000 characters |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
Dimensions data file
Data on exported dimensions is written to the Dimensions Data file.
Note: Dimension values must be values other than Tealeaf constant values.
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Hit key |
HIT_KEY |
32-character key unique to the hit |
Event ID |
EVENT_ID |
Event ID |
Group ID |
DIM_GRP_ID |
Internal identifier for the report group |
Fact ID |
FACT_ID |
Internal identifier for the recorded instance of the event and its dimensions |
Fact Value |
FACT_VALUE |
Event value that is recorded with the recorded instance of the event and its dimensions |
Dimension #1 |
DIMENSION_1 |
Value of dimension #1, if available |
Dimension #2 |
DIMENSION_2 |
Value of dimension #2, if available |
Dimension #3 |
DIMENSION_3 |
Value of dimension #3, if available |
Dimension #4 |
DIMENSION_4 |
Value of dimension #4, if available |
Dimension #5 |
DIMENSION_5 |
Value of dimension #5, if available |
Dimension #6 |
DIMENSION_6 |
Value of dimension #6, if available |
Dimension #7 |
DIMENSION_7 |
Value of dimension #7, if available |
Dimension #8 |
DIMENSION_8 |
Value of dimension #8, if available |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |
Session attribute data file
| UI Field | File Field | Description |
|---|---|---|
Session key |
SESSION_KEY |
32-character key unique to the session |
Name |
NAME |
Attribute name |
Value |
VALUE |
Attribute value |
ID |
ID |
Attribute ID |
session timestamp |
SESSION_TIMESTAMP |
Session time-date stamp is inserted in the output file if the field is included in the Session Data file. |