Share via


CampaignItem

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

This class represents the content included in a marketing campaign (a Campaign object) and a scheduled advertisement (a Creative object). The content is represented by one or more of the following objects: AdItem, DmItem, or OrderDiscount (PCR).

A CampaignItem object may belong to a specific type of campaign item, specified by a link to a CampaignItemTypes object.

Finally, the content items may be part of a Web page presenting multiple groups of custom content. A PageGroupXRef object cross-references the CampaignItem object with the page or pages that contain the items.

A CampaignItem object can have multiple content items (for example, AdItem objects), and can target multiple user groups. A Web page may contain multiple content items, and a content item may be included in multiple, distinct pages. All these possibilities are represented through the one-to-many relationships between classes.

Data Members

Data Member Name

Data Type

Default Value

Description

Active

smallint

Null

Records if the CampaignItem object is active.

ArchivedDate

datetime

Null

Records when the CampaignItem object was archived.

CampaignItemInternalFlag

smallint

0

None.

CampItemNum

int

0

Stores the unique key for the CampaignItem object. Key member.

Comments

nvarchar(255)

Null

Records any comments regarding the objects.

EndDate

datetime

Null

Records when the CampaignItem object was discontinued.

ExportedDate

datetime

Null

Records when the CampaignItem object was exported.

ExposureLimit

int

Null

None.

ModifiedBy

nvarchar(255)

Null

Records who last modified the CampaignItem object.

ModifiedDate

datetime

Null

Records when the CampaignItem object was last modified.

Name

nvarchar(255)

Null

Stores the name of the CampaignItem object.

SiteName

nvarchar(255)

Unknown

Records the name of the site associated with the CampaignItem object. Key member.

StartDate

datetime

Null

Records when the CampaignItem object was started.

CampaignID

bininary

1

Identifier for the campaign.

CampaignItemTypesID

binary

1

None.

CreativeID

binary

1

None.

Class Key

CampaignItemKey is composed of the following data members:

   CampItemNum + SiteName.

Relations

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

Relation Name

Parent

Child

Type

AdItemCampaignItem

CampaignItem

AdItem

2

CampaignItemCampaign

Campaign

CampaignItem

2

CampaignItemCampaignEventRel

CampaignItem

CampaignEvent

2

CampaignItemCampaignItemTypes

CampaignItemTypes

CampaignItem

2

CampaignItemCreative

Creative

CampaignItem

2

CampaignItemPageGroupXrefRel

CampaignItem

PageGroupXref

2

CampaignItemTargetGroupXrefRel

CampaignItem

TargetGroupXref

2

DmItemCampaignItem

CampaignItem

DmItem

2

OrderDiscountCampaignItem

CampaignItem

OrderDiscount

2

See Also

Other Resources

Data Warehouse Classes