Import Campaigns Data

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

You use the Campaign data import DTS task to import campaign data. Campaign data includes advertisers, advertisement campaigns, and campaign item information. It imports campaign information such as advertisers, campaigns, and campaign data. The Campaign Data Import task should be run before you run reports that summarize campaign data.

After you run the Campaign data import task, business managers can run reports on the imported campaign data, and analyze the success of the campaigns.

Imported Data

The Campaign Import task dialog box specifies the data to be imported from your campaign database(s) by the Campaign Import DTS task.

The Campaign Import Properties Dialog Box box to detail what data is imported. After you import the campaign data, you can analyze the success of your campaigns.

The following tables list the columns extracted from the source tables in the Site_Commerce database, the transformation made, and the tables to which the data is saved in the Data Warehouse. Each of the Data Warehouse tables in the following list has a column that contains the SiteName or the SiteName identifier determined during the data transfer.

Most Data Warehouse tables also contain a SiteName column. This column, just as TableID and TableInternalFlag, is also not listed in the tables in the following sections because the SiteName is always extracted from the same location for all DTS tasks.

Source columns from the ad_item table of the Site_Marketing database

Transformation

Target columns from the AdItem table in the Data Warehouse

u_aditem_customer_order_num

Copy Column

AdItemCustomerOrderNum

i_aditem_days_of_week_mask

Copy Column

AdItemDaysOfWeekMask

i_aditem_events_scheduled

Copy Column

AdItemEventsScheduled

i_aditem_time_of_day_end

Copy Column

AdItemTimeOfDayEnd

i_aditem_time_of_day_start

Copy Column

AdItemTiemOfDayStart

i_aditem_type

Copy Column

AdItemType

i_aditem_weight

Copy Column

AdItemWeight

i_campitem_id

Copy Column

CampItemNum

i_industry_id

Copy Column

IndustryNum

i_aditem_id

Copy Column

AdItemNum

Source columns from the campaign table of the Site_Marketing database

Transformation

Target columns from the Campaign table in the Data Warehouse

b_camp_active

Copy Column

CampActive

dt_campaign_exported

Copy Column

CampaignExported

dt_campaign_modified

Copy Column

CampaignModified

u_campaign_modified_by

Copy Column

CampaignModifiedBy

dt_camp_archived

Copy Column

CampArchived

dt_camp_end

Copy Column

CampEnd

u_camp_name

Copy Column

CampName

i_camp_id

Copy Column

CampNum

dt_camp_start

Copy Column

CampStart

u_camp_comments

Copy Column

CustomerComments

i_customer_id

Copy Column

CustomerNum

Source columns from the campaign_item table of the Site_Marketing database

Transformation

Target columns from the CampaignItem table in the Data Warehouse

u_campitem_active

Copy Column

Active

dt_campitem_archived

Copy Column

ArchivedDate

i_camp_id

Copy Column

CampNum

u_campitem_comments

Copy Column

Comments

dt_campitem_end

Copy Column

EndDate

i_campitem_exposure_limit

Copy Column

ExposureLimit

u_campitem_modified_by

Copy Column

ModifiedBy

dt_campitem_modified

Copy Column

ModifiedDate

u_campitem_name

Copy Column

Name

dt_campitem_start

Copy Column

StartDate

i_campitem_id

Copy Column

CampItemNum

guid_campitem_type

Copy Column

GUIDCampItemType

dt_campitem_created

Copy Column

CreatedDate

Source columns from the Creative table of the Site_Marketing database

Transformation

Target columns from the Creative table in the Data Warehouse

i_creative_id

Copy Column

CreativeNum

dt_creative_received

Copy Column

CreativeReceived

i_creative_size_id

Copy Column

CreativeSizeNum

i_creative_type_id

Copy Column

CreativeTypeNum

Source columns from the creative_size table of the Site_Marketing database

Transformation

Target columns from the CreativeSize Report table in the Data Warehouse

i_creative_size_id

Copy Column

CreativeSizeNum

i_size_height

Copy Column

SizeHeight

u_size_name

Copy Column

SizeName

u_size_tag

Copy Column

SizeTag

i_size_width

Copy Column

SizeWidth

Source columns from the creative_type table of the Site_Marketing database

Transformation

Target creativetypes from the Report table in the Data Warehouse

u_ct_name

Copy Column

CreativeTypeName

i_creative_type_id

Copy Column

CreativeTypeNum

Source columns from the creative_type_xref table of the Site_Marketing database

Transformation

Target columns from the CreativeTypeXref table in the Data Warehouse

guid_campitem_type

Copy Column

CampaignItemTypesID

i_creative_type_id

Copy Column

CreativeTypeID

Source columns from the Customer table of the Site_Marketing database

Transformation

Target columns from the Customer table in the Data Warehouse

u_customer_address

Copy Column

Address

dt_customer_archived

Copy Column

Archived

u_customer_comments

Copy Column

Comments

u_customer_contact

Copy Column

Contact

i_customer_id

Copy Column

CustomerNum

dt_customer_created

Copy Column

Created

u_customer_email

Copy Column

Email

dt_customer_exported

Copy Column

Exported

u_customer_fax

Copy Column

Fax

dt_customer_modified

Copy Column

Modified

u_customer_modifiedby

Copy Column

ModifiedBy

u_customer_name

Copy Column

Name

u_customer_password

Copy Column

PassWord

u_customer_phone

Copy Column

Phone

u_customer_url

Copy Column

URL

u_customer_username

Copy Column

UserName

i_industry_id

Copy Column

IndustryNum

Source columns from the dm_item table of the Site_Marketing database

Transformation

Target columns from the DmItem table in the Data Warehouse

u_dmitem_attachment

Copy Column

DmItemAttachment

l_dmitem_defformat

Copy Column

DmItemDefformat

u_dmitem_desc

Copy Column

DmItemDesc

u_dmitem_from

Copy Column

DmItemFrom

i_dmitem_id

Copy Column

DmItemNum

b_dmitem_personalized

Copy Column

DmItemPersonalized

u_dmitem_replyto

Copy Column

DmItemReplyTo

u_dmitem_scheduleid

Copy Column

DmItmeScheduleId

u_dmitem_source

Copy Column

DmItemSource

u_dmitem_subj

Copy Column

DmItemSubj

i_dmitem_userflags

Copy Column

DmItemUserFlags

g_dmitem_listid

Copy Column

GUIDDmItemListId

g_dmitem_optout

Copy Column

GUIDDmItemOptout

g_dmitem_testlistid

Copy Column

GUIDDmItemTestListId

i_campitem_id

Copy Column

CampaignItemNum

Source columns from the event_type table of the Site_Marketing database

Transformation

Target columns from the EventType table in the Data Warehouse

u_event_description

Copy Column

EventDescription

u_event_name

Copy Column

EventName

Source columns from the industry_code table of the Site_Marketing database

Transformation

Target columns from the IndustryCode table in the Data Warehouse

u_industry_code

Copy Column

IndustryCode

i_industry_id

Copy Column

IndustryNum

Source columns from the order_discount table of the Site_Marketing database

Transformation

Target columns from the OrderDiscount table in the Data Warehouse

i_disc_award_expr

Copy Column

DiscAwardExpr

i_disc_award_max

Copy Column

DiscAwardMax

b_disc_click_required

Copy Column

DiscClickRequired

b_disc_disjoin_cond_award

Copy Column

DiscDisjointCondAward

i_disc_limit

Copy Column

DiscLimit

i_disc_id

Copy Column

DiscNum

i_disc_offer_type

Copy Column

DiscOfferType

mny_disc_offer_value

Copy Column

DiscOfferValue

b_disc_order_level_discount

Copy Column

DiscOrderLevelDiscount

i_disc_rank

Copy Column

DiscRank

u_disc_special_offer_type

Copy Column

DiscSpecialOfferType

i_disc_template

Copy Column

DiscTemplate

i_campitem_id

Copy Column

CampaignItemID

Source columns from the page_group table of the Site_Marketing database

Transformation

Target columns from the PageGroup table in the Data Warehouse

u_pg_description

Copy Column

PgDescription

i_pg_id

Copy Column

PgNum

u_pg_tag

Copy Column

PgTag

Source columns from the page_group_xref table of the Site_Marketing database

Transformation

Target columns from the PageGroupXref table in the Data Warehouse

i_campitem_id

Copy Column

CampaignItemID

i_pg_id

Copy Column

PgNum

Source columns from the target table of the Site_Marketing database

Transformation

Target columns from the Target table in the Data Warehouse

i_target_action

Copy Column

TargetAction

i_target_expr_id

Copy Column

TargetExprId

i_target_id

Copy Column

TargetNum

How to Run the Campaign Data Import DTS Task

See Also

Other Resources

What Data Does DTS Import into the Data Warehouse?