Share via


CampaignEvent

This class stores event information for marketing campaigns. An event for a marketing campaign includes hits on CampaignItem objects and business transactions involving CampaignItem objects.

Data Members

Data Member Name

Data Type

Default Value

Description

CNT

nvarchar(255)

Null

Records the number of Web events represented by the CampaignEvent object.

DTimeStamp

datetime

(convert(datetime,'1900-1-1 0:0:0.0',121))

None.

EX

nvarchar(255)

Null

None.

RequestIndex

smallint

Null

None.

UriKey

bigint

0

None.

UserKey

bigint

0

None.

VisitNum

binary

0

None.

CampaignItemID

binary

1

None.

DateHourID

binary

1

The identifier for the hour of the Campaign Event.

EventTypeID

binary

1

The identifier for the Campaign Event Type.

PageGroupID

binary

1

The identifier for the PageGroup.

RegisteredUserId

binary

1

The identifier for the user who is registered.

SiteID

binary

1

None.

TaskHistoryID

binary

1

None.

Class Key

No key is defined for this class. It is a dependent class.

Relations

For a description of the relation type, see Data Warehouse Classes.

Relation Name

Parent

Child

Type

CampaignItemCampaignEventRel

CampaignItem

CampaignEvent

2

DateCampaignEventTimeStamp

Date

CampaignEvent

2

EventTypeCampaignEventRel

EventType

CampaignEvent

2

LogUserCampaignEventRel

LogUser

CampaignEvent

5

PageGroupCampaignEventRel

PageGroup

CampaignEvent

2

RegisteredUserCampaignEventRel

RegisteredUser

CampaignEvent

2

SiteCampaignEvent

Site

CampaignEvent

2

TaskHistoryCampaignEvent

TaskHistory

CampaignEvent

2

UriCampaignEvent

URI

CampaignEvent

5

VisitCampaignEventRel

Visit

CampaignEvent

5

See Also

Other Resources

Data Warehouse Classes