Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

When syncing ONEcount with a remote system like a fulfillment database or e-commerce system on a regular basis , say every day or every week, (See FULFILLEMENT SAMPLE below), it is best to import and export both the remote system ID, and the ONEcount ID, or OCID. This will ensure new customers added by either system are handled appropriately.

...

Status Code: This for subscriber status changes (Current Subscriber, Expired, Pended Add, etc.)

Engagement Data

Engagement Data covers a broad range of activities, including banner views and clicks, e-mail opens and clicks, webinar attendance, video plays, etc. The key metric for ALL of these engagement data types is: the user who did it, the date/time of the engagement, and the engagement activity itself (open, click, view, etc.) Other data can be added to these records as well, including the name of the advertiser or banner campaign, the subject of the e-mail campaign, etc.  This data is important to each engagement and can be imported into ONEcount using DExTR.

Here are a couple of examples:

E-Mail Engagement (combined, from Eloqua)

...

ActivityDate

...

ActivityType

...

AssetId

...

AssetName

...

CampaignId

...

ContactId

...

EmailAddress

...

EmailClickedThruLink

...

EmailRecipientId

...

ExternalId

...

SmtpErrorCode

...

SmtpMessage

...

SmtpStatusCode

...

VisitorId

ContactID is an Eloqua-specific ID 

VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake

E-mail Engagement (Split Files)

email-clicks.csv:

...

ActivityDate

...

ActivityType

...

MessageID

...

MessageName

...

MessageSubject

...

ListID

...

ListName

...

OCID

...

LinkURL

...

LinkID

...

Firstclick

...

Latestclick

...

clicked

email-opens.csv

...

ActivityDate

...

ActivityType

...

MessageID

...

MessageName

...

MessageSubject

...

ListID

...

ListName

...

OCID

email-sends.csv

...

ActivityDate

...

ActivityType

...

MessageID

...

MessageName

...

MessageSubject

...

ListID

...

ListName

...

OCID

LiveIntent Data Sample:

...

Liveintentuserid

...

Advertiserid

...

Campaignid

...

Creativeid

...

Devtype

...

Emailasmdfive

...

Eventtype

...

Lineitemid

...

Liveintentdecisionid

...

Publisherid

...

Sectionid

...

Templateid

...

Timestamp

...

28427698

...

39771

...

246944

...

787604

...

PC

...

d57dccaadbba6c4ad8f143de8c571771

...

impression

...

10001043

...

66233848-4580-3d7f-92b2-beb4741e8f7

...

36479

...

253729

...

19263

...

2021-03-10

...

28422453

...

39771

...

246944

...

787604

...

PC

...

2dece7448530fdf799254a875ebe0a77

...

impression

...

10001043

...

b8c41396-b896-333d-9945-522c21174e2

...

36479

...

277132

...

19263

...

2021-03-10

...

28421392

...

39771

...

246944

...

787604

...

PC

...

a4c0388d679348e467d27391b3fd456c

...

impression

...

10001043

...

844ebc51-0a02-3783-99c8-8ac96a29bc3

...

36479

...

277132

...

19263

...

2021-03-10

...

28499279

...

39771

...

246944

...

787604

...

PC

...

96032eb8da86e394b23c2a9647477d66

...

impression

...

10001043

...

69a0d6fd-7cb3-301d-b24a-04144d9ec74

...

36479

...

253729

...

19263

...

2021-03-10

...

28421344

...

39771

...

246944

...

787604

...

PC

...

fd2d53dbe2e7aa2198c19afce5a35cc6

...

impression

...

10001043

...

75c72eca-6cf1-3144-b00c-04ca49471363

...

36479

...

253729

...

19263

...

2021-03-10

BrightCove Data Sample:

...

Contactid

...

Country

...

Createdat

...

Device

...

Id

...

Metriccode

...

Pageurl

...

Playerid

...

Timewatched

...

Updatedat

...

Utmcampaign

...

Utmmedium

...

Utmsource

...

Videoid

...

Videoname

...

Watched

...

3B07C282-170D-46C4-B8CC-AAADFD

...

United States

...

2021-02-11

...

desktop

...

309529

...

V1

...

https://preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video

...

Sy80k7Mtg

...

0

...

2021-02-11

...

5982181673007

...

What is symptomatic neurogenic orthostatic hypotension?

...

0

...

228DA837-9358-43AB-A6E6-DFSF

...

United States

...

2021-01-25

...

desktop

...

306311

...

V1

...

https://www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video

...

Sy80k7Mtg

...

1

...

2021-01-25

...

6171615690004

...

TED Risk Factors & Symptoms

...

1

...

1EFC18BF-E9A4-44D9-849F-FDSFS

...

United States

...

2021-01-29

...

desktop

...

307009

...

V1

...

https://preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video

...

Sy80k7Mtg

...

1

...

2021-01-29

...

6171615690003

...

TED Risk Factors & Symptoms

...

1

...

228DA837-9358-43AB-A6E6-DFASFDASF

...

United States

...

2021-02-12

...

desktop

...

309633

...

V1

...

https://preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi

...

Sy80k7Mtg

...

0

...

2021-02-12

...

6171632240005

...

TED Pathophysiology

...

0

...

5835554F-9B8A-4BA2-BB31-FDSAF

...

United States

...

2021-02-09

...

desktop

...

309052

...

V1

...

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

...

Sy80k7Mtg

...

40

...

2021-02-09

...

cardiology educationlab

...

email

...

selligent

...

6185538439007

...

Chapter 5 — NORTHERA Safety Results

...

19

...

5835554F-9B8A-4BA2-BB31-68C51F5632F7

...

United States

...

2021-02-09

...

desktop

...

309058

...

V1

...

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

...

Sy80k7Mtg

...

10

...

2021-02-09

...

cardiology educationlab

...

email

...

selligent

...

6185538439004

...

Chapter 5 — NORTHERA Safety Results

...

5

...

5835554F-9B8A-4BA2-BB31-68C51F5632F7

...

United States

...

2021-02-09

...

desktop

...

309064

...

V1

...

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

...

Sy80k7Mtg

...

30

...

2021-02-09

...

cardiology educationlab

...

email

...

selligent

...

6185538439008

...

Chapter 5 — NORTHERA Safety Results

...

14

ContactID is a GUID assigned by the Customer's Internal Data Warehouse

Raw Web Impressions

...

VisitContactId

...

EventTime

...

PlatformViewed

...

RefererID

...

SessionId

...

SiteName

...

Url

...

59DA834C-803E-4C14-9C49-FDSA

...

2021-03-09 01:35:12

...

mobile

...

2407411196308715909161529690620210309

...

www.CUSTOMER.com

...

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression

...

D0717BB2-CCDB-4DBE-ADD6-REWQREQW

...

2021-03-06 01:43:53

...

tablet

...

2419995085411609985161503823320210306

...

www.CUSTOMER.com

...

http://www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis

...

1AFE97E9-9931-4427-9C4E-VZCXVZ

...

2021-02-22 11:04:20

...

tablet

...

3663669472315156695161403488520210222

...

www.CUSTOMER.com

...

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis

...

59DA834C-803E-4C14-9C49-YHDGT

...

2021-03-09 01:35:14

...

mobile

...

2407411196308715909161529690620210309

...

wwwCUSTOMER.com

...

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression

...

31C5F8C6-3EFF-4DE7-A899-JGVMHGY

...

2021-02-25 05:11:38

...

mobile

...

8233752448896666794161427278020210225

...

www.CUSTOMER.com

...

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d

...

68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA

...

2021-03-15 09:57:00

...

desktop

...

www.CUSTOMER.com

...

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~contactid~

VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse

Fulfillment Sample: Advantage/Omeda/PCS/CDS

PUBCDE

CUSTNUMB

OCID

CRCSTS

FIRST

LAST

COMPANY

ADD1

ADD2

CITY

ZIPCDE

STATE

ADRCDE

KEYCDE

QUALSRC

EMAIL

CTMDTE

FINDTE

PHONE

LISTIND

County

COUNTRY

AAI

404304

33675

E

FRED

SMITH


57 CHURCH ST


ROXBURY

67831704

CT

M

TREN68B

5F


20161205

20190101

8005551234

NONACTIVE

LITCHFIELD

USA

AIB

445771


Q

JOSEPH

JONES

JONES & CO

7632 WILDCAT PIKE


NEW BLOOMINGTON

433419532

OH

M

E3CC1220

5F

JMBUCKOHIO@AOL.COM

20201201

20231201

9546783214

QUAL

MARION

USA

AXW


3324

G

MARK

ROBERTS

TRF Inc.

5201 WOODWARD AVE


DETROIT

482024093

MI

M

RRT6GT

1A


20201207

20210401


PAID

WAYNE

USA

PUBCODE maps to Package TERM


Engagement Data

Engagement Data covers a broad range of activities, including banner views and clicks, e-mail opens and clicks, webinar attendance, video plays, etc. The key metric for ALL of these engagement data types is: the user who did it, the date/time of the engagement, and the engagement activity itself (open, click, view, etc.) Other data can be added to these records as well, including the name of the advertiser or banner campaign, the subject of the e-mail campaign, etc.  This data is important to each engagement and can be imported into ONEcount using DExTR.

Here are a couple of examples:

E-Mail Engagement (combined, from Eloqua)

ActivityDate

ActivityType

AssetId

AssetName

CampaignId

ContactId

EmailAddress

EmailClickedThruLink

EmailRecipientId

ExternalId

SmtpErrorCode

SmtpMessage

SmtpStatusCode

VisitorId











































ContactID is an Eloqua-specific ID 

VisitorID is a custom field in the e-mail system containing the user's GUID from the customer's internal data lake

E-mail Engagement (Split Files)

email-clicks.csv:

ActivityDate

ActivityType

MessageID

MessageName

MessageSubject

ListID

ListName

OCID

LinkURL

LinkID

Firstclick

Latestclick

clicked














email-opens.csv

ActivityDate

ActivityType

MessageID

MessageName

MessageSubject

ListID

ListName

OCID









email-sends.csv

ActivityDate

ActivityType

MessageID

MessageName

MessageSubject

ListID

ListName

OCID










LiveIntent Data Sample:

Liveintentuserid

Advertiserid

Campaignid

Creativeid

Devtype

Emailasmdfive

Eventtype

Lineitemid

Liveintentdecisionid

Publisherid

Sectionid

Templateid

Timestamp

28427698

39771

246944

787604

PC

d57dccaadbba6c4ad8f143de8c571771

impression

10001043

66233848-4580-3d7f-92b2-beb4741e8f7

36479

253729

19263

2021-03-10

28422453

39771

246944

787604

PC

2dece7448530fdf799254a875ebe0a77

impression

10001043

b8c41396-b896-333d-9945-522c21174e2

36479

277132

19263

2021-03-10

28421392

39771

246944

787604

PC

a4c0388d679348e467d27391b3fd456c

impression

10001043

844ebc51-0a02-3783-99c8-8ac96a29bc3

36479

277132

19263

2021-03-10

28499279

39771

246944

787604

PC

96032eb8da86e394b23c2a9647477d66

impression

10001043

69a0d6fd-7cb3-301d-b24a-04144d9ec74

36479

253729

19263

2021-03-10

28421344

39771

246944

787604

PC

fd2d53dbe2e7aa2198c19afce5a35cc6

impression

10001043

75c72eca-6cf1-3144-b00c-04ca49471363

36479

253729

19263

2021-03-10


BrightCove Data Sample:

Contactid

Country

Createdat

Device

Id

Metriccode

Pageurl

Playerid

Timewatched

Updatedat

Utmcampaign

Utmmedium

Utmsource

Videoid

Videoname

Watched

3B07C282-170D-46C4-B8CC-AAADFD

United States

2021-02-11

desktop

309529

V1

https://preview.CUSTOMER.com/education-lab/2019/01_january/treatment-considerations-for-symptomatic-neurogenic-orthostatic-hypotension/video

Sy80k7Mtg

0

2021-02-11




5982181673007

What is symptomatic neurogenic orthostatic hypotension?

0

228DA837-9358-43AB-A6E6-DFSF

United States

2021-01-25

desktop

306311

V1

https://www.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video

Sy80k7Mtg

1

2021-01-25




6171615690004

TED Risk Factors & Symptoms

1

1EFC18BF-E9A4-44D9-849F-FDSFS

United States

2021-01-29

desktop

307009

V1

https://preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video

Sy80k7Mtg

1

2021-01-29




6171615690003

TED Risk Factors & Symptoms

1

228DA837-9358-43AB-A6E6-DFASFDASF

United States

2021-02-12

desktop

309633

V1

https://preview.CUSTOMER.com/education-lab/2020/07_july/in-the-treatment-of-ted-its-time-for-tepezza/video#isi

Sy80k7Mtg

0

2021-02-12




6171632240005

TED Pathophysiology

0

5835554F-9B8A-4BA2-BB31-FDSAF

United States

2021-02-09

desktop

309052

V1

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

Sy80k7Mtg

40

2021-02-09

cardiology educationlab

email

selligent

6185538439007

Chapter 5 — NORTHERA Safety Results

19

5835554F-9B8A-4BA2-BB31-68C51F5632F7

United States

2021-02-09

desktop

309058

V1

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

Sy80k7Mtg

10

2021-02-09

cardiology educationlab

email

selligent

6185538439004

Chapter 5 — NORTHERA Safety Results

5

5835554F-9B8A-4BA2-BB31-68C51F5632F7

United States

2021-02-09

desktop

309064

V1

https://www.CUSTOMER.com/education-lab/2020/06_june/droxidopa-for-the-treatment-of-symptomatic-noh/video?utm_source=selligent&utm_medium=email&utm_campaign=cardiology educationlab&autostart=1&playlistVideoId=6185538439001&M_BT=4838969175605

Sy80k7Mtg

30

2021-02-09

cardiology educationlab

email

selligent

6185538439008

Chapter 5 — NORTHERA Safety Results

14

ContactID is a GUID assigned by the Customer's Internal Data Warehouse


Raw Web Impressions

VisitContactId

EventTime

PlatformViewed

RefererID

SessionId

SiteName

Url

59DA834C-803E-4C14-9C49-FDSA

2021-03-09 01:35:12

mobile


2407411196308715909161529690620210309

www.CUSTOMER.com

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression

D0717BB2-CCDB-4DBE-ADD6-REWQREQW

2021-03-06 01:43:53

tablet


2419995085411609985161503823320210306

www.CUSTOMER.com

http://www.hCUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis

1AFE97E9-9931-4427-9C4E-VZCXVZ

2021-02-22 11:04:20

tablet


3663669472315156695161403488520210222

www.CUSTOMER.com

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/inflammation-and-fibrosis

59DA834C-803E-4C14-9C49-YHDGT

2021-03-09 01:35:14

mobile


2407411196308715909161529690620210309

wwwCUSTOMER.com

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/drivers-of-ckd-progression

31C5F8C6-3EFF-4DE7-A899-JGVMHGY

2021-02-25 05:11:38

mobile


8233752448896666794161427278020210225

www.CUSTOMER.com

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d

68E8551F-AD4E-4AAF-B4E6-RTSDFSAFA

2021-03-15 09:57:00

desktop



www.CUSTOMER.com

http://www.CUSTOMER.com/endocrinology/education-lab/ckd-knowledge-challenge/interactive/scope-of-ckd-in-t2d?ecp=~contactid~

VisitContactID is a GUID assigned by the Customer's Internal Data Warehouse


Swapcard (Webinar/Virtual Event Platform)

Title

Start date

Format

Topics

Group

Email

First

Last

Title

Company

Is COVID-19 FOR REAL?

2-11-21 12:55 PM

PRE_RECORDED

Other, Human Health, Policy, Business

Premium Members

ryan@2XXX.com

Ryan

Brown


2XXX Group

BREAKING NEWS SESSION: Extreme 

2-17-21 1:15 PM

PRE_RECORDED


Premium Members

ryan@2XXX.com

Ryan

Brown


2XXX Group


Trade Show Registration Data

Event Series

Event Edition

Source System

Reg Number

First Name

Last Name

Title

Company 1

Address 1

Address 2

City

State

Zip Code

Country

Phone Number

Fax Number

Email Address

Internet Address 2

Phone Area Code

Phone Number Only

Reg Code

Membership Flag

Member ID

Reg Code 3

Text 1

Credential

Amount Paid

Amount Refunded

Reg Code 2

Source Code

Link Reg ID

Business type:  Check all that apply.

Age range

Primary business

Is this your first time to attend the Expo?

Please keep me up-to-date with the latest events and services

I would like to hear from  directly about products and services

What is your gender?

Buying decisions

Job function

Primary Market

What is your job title/function?

What is your company's primary media type?

Products/services

Do you want to receive a free subscription to PVV Magazine?

Do you want to receive a free subscription to RXY Magazine?

Sales Volume

Do you want to receive a free subscription to our e-newsletter?

What services does your company provide?

Annual Trade Show

EXPO 2022

CSI

1100339

Fred

Jones

Owner

Jones Construction Ent.

690 E Highway 90

690 e HWY 90

Tampa

FL

32425


1  8505551001


fred@myaddress.com

officemgr@notmyaddress.com

850

5471001

Conference Attendee

Y

412351




396


Super Pass


1100002

Contractor

51-60

Contractor

No

Yes


Male

Yes

Owner/CEO/President/Executive

Both



This, That, A little of the other, Something Else

Yes

Yes

$1,000,000-$4,999,999

Yes

Roofing, Pool Repair, Driveway Sealing, Electrical Contracting


















































Annual Trade Show

EXPO 2022

CSI

1100005

Jim

Nordstrom

Spouse

Nordstrom Chain, LLC

690 E Highway 90


Miami

FL

33736


1  8502588247


jimnordstrom@something.com


850

3998247

Attendee Expo Only

N





66


Expo Only


1100002

No Response

41-50

Spouse/Guest

Yes

Yes


Male

No Response

Spouse/Guest




Rope, Twine, Chain

No

No

No Response

No

No Response [DB ONLY]