mktg_ad_item Table
The mktg_ad_item table in the marketing database contains information about the various ads being displayed on your Commerce Server Core Systems Web site.
The following table describes the columns in the mktg_ad_item table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_aditem_id |
int |
no |
The ID of the ad. This is the primary key. It is used internally by the Marketing System and is not used to retrieve ads. Ads are retrieved using the associated campaign item ID. |
i_industry_id |
int |
yes |
The industry code associated with the ad. This is a foreign key into the mktg_industry_code table. |
i_aditem_type |
smallint |
no |
The type of the ad. |
i_aditem_days_of_week_mask |
smallint |
no |
A bit flag that contains bits representing each day of the week. |
i_aditem_time_of_day_start |
smallint |
no |
The hour of the day (0-23) at which the ad should start to run. |
i_aditem_time_of_day_end |
smallint |
no |
The hour of the day (0-23) at which the ad should stop running. |
i_aditem_events_scheduled |
int |
yes |
For paid ads, the number of events scheduled. |
i_aditem_customer_order_num |
nvarchar(50) |
yes |
To be written. |
i_aditem_weight |
int |
yes |
For house ads, the relative weight of this ad. |
i_campitem_id |
int |
no |
The campaign item ID of this ad. This is a foreign key into the mktg_campaign_item table. This ID is used to uniquely identify this ad in the Marketing System. |
i_aditem_prev_served |
int |
yes |
Performance data for this ad before the most recent checkpoint. |
i_aditem_eff_start |
datetime |
yes |
The date and time of the last checkpoint, if applicable. |