Share via


What Are the Marketing System Database Tables?

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

The Marketing System stores data in SQL database tables in the marketing, marketing_lists, and DirectMailer databases. By default, these database names are prefixed by the name of your site, followed by the "_" character (for example, "YourSite_marketing"). However, the user can choose different names for the databases during unpacking.

Most marketing tables are stored in the marketing database, and list-oriented tables are stored in the marketing_lists database. The DirectMailer database contains the DirectMail list manager temporary working tables and execution status information. The dml_job_errors table contains individual job execution errors.

Marketing System Database Tables

Marketing Database Tables

mktg_ad_item

mktg_basket_display

mktg_campaign

mktg_campaign_item

mktg_creative

mktg_creative_property

mktg_creative_property_value

mktg_creative_size

mktg_creative_type

mktg_customer

mktg_dm_attachment

mktg_dm_item

mktg_dm_subject

mktg_event_type

mktg_expression

mktg_expression_category

mktg_expression_depends

mktg_industry_code

mktg_order_discount

mktg_order_discount_condition

mktg_order_discount_expression

mktg_page_group

mktg_page_group_xref

mktg_performance_total

mktg_promocode

mktg_promocode_defn

mktg_promocode_generation

mktg_promocode_generation_error

mktg_promocode_history

mktg_promocode_transactions

mktg_target

mktg_version

mktg_virtual_directory

upld_chunks

upld_imports

Marketing_Lists Database Tables

mktg_lm_master

mktg_lm_master_operations

mktg_lm_operation_errors

mktg_lm_{listid}_list

DirectMailer database tables

dml_job_errors

dml_jobs

mktg_lm_{jobid}_list

See Also

Other Resources

Working with Marketing System Components

Marketing System Database Tables