DATA LEGEND : Episode 1 : Script Kit
TYPE NUM = NUMBER | TYPE TXT = TEXT | TYPE TS = TIMESTAMP | TYPE YN = YES/NO, TRUE/FALSE, BOOLEAN
CONTACT INFO
COLUMN NAME
TYPE
DESCRIPTION
id
NUM
(Internal Use)
FName
TXT
First name entered into PII/contact block
LName
TXT
Last name entered into PII/contact block
Title
TXT
Job title entered into PII/contact block
PhoneCo
TXT
Phone number entered into PII/contact block
TXT
Email Address entered into PII/contact block
UID1
TXT
Individual's practice ID as defined in custom email link from CareCredit
PATH INFO
COLUMN NAME
TYPE
DESCRIPTION
Returned
YN
Visitor entered the same phone + email into PII/contact block and was marked as returning
Tester
YN
Visitor entered the experience via a testing link
Traffic1ID
TXT
Episode number as defined in custom email link from CareCredit
EventCode
TXT
Unique code automatically included for each event type
ACTIVITY LOG ONLY
COLUMN NAME
TYPE
DESCRIPTION
MetricSource
TXT
The type of interactive hotspot. See staging center for mapped values. One row in data per click
MetricTitle
TXT
The location of interactive hotspot. See staging center for mapped values. One row in data per click
TitleLabel
TXT
The name of interactive hotspot. See staging center for mapped values. One row in data per click
Log_created_at
TS
The time that the click was registered.
CAMPAIGN DATA
COLUMN NAME
TYPE
DESCRIPTION
OptIn1
YN
Visitor requested to be contacted by representative
OtherMemo1
TXT
What the visitor included in the "How can we help you?" field on the form
OptIn2
YN
Visitor requested to be notified of future episodes
OptIn3
YN
Visitor requested to receive a display kit
Channel1
TXT
Channel info that was in custom email link from CareCredit
Channel2
TXT
The type of link the visitor used to access the experience (DIRECTLINK, EMAIL, SOCIAL, DIRECTMAIL)
Score1
NUM
(Not In Use)
Goal1
YN
Whether or not the visitor submitted the contact form
Goal2
YN
Whether or not the visitor downloaded the script kit
Goal3
YN
Whether or not the visitor played the game in the experience
Goal4
YN
Internal Use: Request for gift card sent to distribution center
Goal5-10
YN
(Not In Use)
OtherYN1-5
YN
(Not In Use)
OtherTXT1-5
TXT
(Not In Use)
FulfillBool1
YN
Whether or not the gift card email delivered
FulfillBool2
YN
Whether or not the reminder email was delivered
DEVICE + SYSTEM INFO
COLUMN NAME
TYPE
DESCRIPTION
platform
TXT
Which operating system the visitor was using
device
TXT
Which device the visitor was using
browser
TXT
Which browser the visitor was using
version
TXT
Which version of the browser the visitor was using
created_at
TS
When the visitor first entered the experience
updated_at
TS
The last time the system added information to the record
IP
TXT
The IP address of the visitor
Mobile Accessed
YN
Whether or not the visitor was routed to the mobile experience
Desktop Accessed
YN
Whether or not the visitor was routed to the desktop/laptop experience
FULFILLMENT INFO
COLUMN NAME
TYPE
DESCRIPTION
FulfillFName
TXT
First name entered into PII/contact block
FulfillLName
TXT
Last name entered into PII/contact block
FulfillPhone1
TXT
Phone number entered into PII/contact block
FulfillEmail1
TXT
Email address entered into PII/contact block
Tester
YN
Whether or not the visitor was a tester
Approved
YN
Whether or not the visitor was approved to receive a gift
Fulfilled
YN
Whether or not the system has sent them the gift card
Username
TXT
The email address of the user that approved the record for fulfillment
Value
TXT
Dollar value of the gift card sent