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

Email

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