Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |