Campaign
This class defines the business process involved in running a marketing campaign for an advertiser. The Campaign class associates a customer (the advertiser) with a set of CampaignItem objects (advertisements, discounts, direct mailings, or related sell items). A Campaign object is associated with an EventType object, which describes the marketing event.
A Customer object may have multiple Campaign objects associated with it; this represents multiple advertising campaigns for the customer over time. A Campaign may contain multiple sets of content items (CampaignItem objects). Each set of content items, in turn, may have multiple items (for example, AdItem objects), and may target multiple user groups. Finally, 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 relations between classes.
Data Members
Data Member Name |
Data Type |
Default Value |
Description |
|---|---|---|---|
CampActive |
smallint |
Null |
None. |
CampaignExported |
datetime |
Null |
Records when the Campaign object was exported. |
CampaignInternalFlag |
smallint |
0 |
None. |
CampaignModified |
datetime |
Null |
Records when the Campaign object was last modified. |
CampaignModifiedBy |
nvarchar(255) |
Null |
Stores who last modified the Campaign object. |
CampArchived |
datetime |
Null |
Records when the Campaign object was archived. |
CampEnd |
datetime |
Null |
Records when the Campaign object was discontinued. |
CampEventsSched |
int |
Null |
Stores the number of campaign events scheduled for the Campaign object. |
CampLevelGoal |
smallint |
Null |
None. |
CampName |
nvarchar(255) |
Null |
Stores the name of the Campaign object. |
CampNum |
int |
0 |
Stores the unique key for the Campaign object. Key member. |
CampStart |
datetime |
Null |
Records when the Campaign object became active. |
CustomerComments |
nvarchar(255) |
Null |
Stores any comments made by the customer associated with the Campaign object. |
SiteName |
nvarchar(255) |
Null |
Stores the name of the site associated with the Campaign object. Key member. |
CustomerID |
binary |
1 |
None. |
EventTypeID |
binary |
1 |
None. |
Class Key
CampaignKey is composed of the following data members:
CampNum + SiteName.
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation Name |
Parent |
Child |
Type |
|---|---|---|---|
CampaignCustomer |
Customer |
Campaign |
2 |
CampaignEventType |
EventType |
Campaign |
2 |
CampaignItemCampaign |
Campaign |
CampaignItem |
2 |