Share via


mktg_campaign_item Table

The mktg_campaign_item table in the marketing database contains information about individual campaign items.

The following table describes the columns in the mktg_campaign_item table.

Column name

Type

Allow null

Description

i_campitem_id

int

no

The ID of this campaign item.

This is the primary key.

i_creative_id

int

yes

The ID of the creative associated with this campaign item.

This is a foreign key into the mktg_creative table.

guid_campitem_type

uniqueidentifier

no

A GUID that identifies the type of this campaign item:

  • Ads: 82851F92-48D9-11D2-9C52-00C04FC29CC1

  • Discounts: 1E8A0072-48DC-11D2-9C52-00C04FC29CC1

  • Direct mail: 5CE1BDCE-48DC-11D2-9C52-00C04FC29CC1

u_campitem_name

nvarchar(50)

no

The name of this campaign item.

b_campitem_active

bit

no

A Boolean value that indicates whether this campaign item is active (approved).

dt_campitem_start

datetime

no

The date and time at which this campaign item starts.

dt_campitem_end

datetime

no

The date and time at which this campaign item ends.

i_campitem_exposure_limit

int

no

The maximum number of times to show this campaign item to a particular user.

i_camp_id

int

yes

The ID of the campaign with which this campaign item is associated.

This is a foreign key into the mktg_campaign table.

dt_campitem_created

datetime

no

The date and time at which this campaign item was created.

dt_campitem_archived

datetime

yes

The date and time at which this campaign item was archived/deleted.

dt_campitem_exported

datetime

yes

The date and time at which this campaign item was last exported to the Data Warehouse Analytics System.

dt_campitem_modified

datetime

yes

The date and time at which this campaign item was last modified.

u_campitem_modified_by

nvarchar(50)

yes

The name of the user who created or last modified this campaign item.

u_campitem_comments

nvarchar(1024)

yes

Any arbitrary comments about this campaign item.

b_campitem_deleted

bit

yes

A Boolean value that indicates whether this campaign has been archived/deleted.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables

mktg_creative Table

mktg_campaign Table