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 |
|
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 |
Related Sections
How to Run the Campaign Data Import DTS Task