What Are the Marketing System Database Tables?

  • Article

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