Campaigns Database Tables

Article
11/12/2009

The Marketing tables are found in the database referred to by the Campaigns site resource. For detailed information about securing these database tables, see Securing the Campaigns Database.

Ee825052.note(en-US,CS.20).gif Note

Do not modify these tables for any reason. They are described here for reference.

Table name	Description
`Ad_item`	Represents scheduled advertising content for a Web page, contains data members describing when the advertisement runs and codes linking the advertisement to the products it represents.
`Campaign`	Defines the business process involved in running a marketing campaign for an advertiser.
`Campaign_item`	Represents the content included in a marketing campaign and/or a scheduled advertisement.
`Campaign_item_types`	Describes the types of campaign items available in the marketing system.
`Campaigns_version`	Contains schema versioning information. If custom campaign item types are created, they should be registered here.
`Creative`	Contains information about how to display an advertisement or discount.
`Creative_property`	Describes the substitution strings contained in each creative type, with one entry per substitution string per creative type.
`Creative_property_value`	Contains values for creative properties.
`Creative_size`	Describes the size of the slot required to display a given creative on a page.
`Creative_type`	Contains formatting information describing how to display the creative.
`Creative_type_xref`	Determines which creative types (templates) are available for each type of campaign item.
`Customer`	Defines a customer who uses advertising through a Commerce Server 2002 Web site.
`Dm_item`	Describes scheduled direct mailing items such as address and format information.
`Event_type`	Categorizes marketing events.
`Industry_code`	Contains attributes that allow the selection algorithm to prevent showing two ads from the same industry and from different customers on the same page.
`Order_discount`	Represents discounted sale items. The class contains data members describing the items and conditions of the sale.
`Order_discount_expression`	Identifies the eligibility requirement expressions for discounts.
`Order_discount_misc`	For internal Business Desk use only.
`Page_group`	Represents a group of custom content items used on a Web page for a marketing campaign.
`Page_group_xref`	Cross-references custom Web page content with the Web page or logical set of Web pages that contains the content.
`Performance_total`	Records aggregate counts of events such as clicks and requests for each campaign item.
`Target`	Defines a target for marketing and custom Web content, such as a particular type of user.
`Target_group`	Defines a group of targets for marketing and custom Web content.
`Target_group_xref`	Cross-references a target group with the custom content for the target group.

Campaigns Database Tables

See Also

Additional resources