mktg_campaign Table

The mktg_campaign table in the marketing database contains information about marketing campaigns.

The following table describes the columns in the mktg_campaign table.

Column name

Type

Allow null

Description

i_camp_id

int

no

The ID of this campaign.

This is the primary key.

dt_camp_start

datetime

no

The date and time that this campaign starts.

dt_camp_end

datetime

no

The date and time that this campaign ends.

u_camp_name

nvarchar(50)

no

The name of this campaign.

i_event_type_id

int

no

The type of event that controls the scheduling of this campaign.

This is a foreign key into the mktg_event_type table.

i_camp_events_sched

int

no

The number of events scheduled for this campaign.

b_camp_level_goal

bit

no

A Boolean value that indicates the level at which the goals for this campaign are set.

i_customer_id

int

yes

The ID of the customer of this campaign.

This is a foreign key into the mktg_customer table.

dt_camp_created

datetime

no

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

dt_camp_archived

datetime

yes

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

dt_camp_exported

datetime

yes

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

dt_camp_modified

datetime

yes

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

u_camp_modified_by

nvarchar(50)

yes

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

b_camp_active

bit

yes

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

u_camp_comments

nvarchar(1024)

yes

Any arbitrary comments about this campaign.

b_camp_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_event_type Table

mktg_customer Table