What Are the Marketing System Database Tables?

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