CampaignItem
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 |