Appendix B.  ATG Campaign Optimizer Database Tables

The ATG Campaign Optimizer database schema includes several types of tables. These tables are divided into two sections:

ATG Campaign Optimizer Core Tables

ATG Campaign Optimizer for Commerce Database Tables

ATG Campaign Optimizer tables include the following:

Type of Table

Description

Table Names

CAF Tables

Holds data used to describe asset registries.

???TITLE??????TITLE??????TITLE???caf_registry
???TITLE??????TITLE??????TITLE???caf_reg_folder
???TITLE??????TITLE??????TITLE???caf_reg_rootfolder
???TITLE??????TITLE??????TITLE???caf_reg_asset
???TITLE??????TITLE??????TITLE???caf_reg_repasset
???TITLE??????TITLE??????TITLE???caf_reg_pathasset

Markers Table

Holds marker data that ties users to tests.

???TITLE??????TITLE??????TITLE???abt_markers

Metrics Tables

Holds event data (also called log data) produced from tests.

???TITLE??????TITLE??????TITLE???abl_page_visit
???TITLE??????TITLE??????TITLE???abl_started
???TITLE??????TITLE??????TITLE???abl_ended
???TITLE??????TITLE??????TITLE???abl_user_group
???TITLE??????TITLE??????TITLE???abl_content_viewed
???TITLE??????TITLE??????TITLE???abl_session

Preview Table

Holds data that describes test previews.

???TITLE??????TITLE??????TITLE???abt_preview

Reporting Tables

Holds data used to generate reports.

???TITLE??????TITLE??????TITLE???abr_control
???TITLE??????TITLE??????TITLE???abr_report
???TITLE??????TITLE??????TITLE???abr_report_group

Test Definition Tables

Holds data that describes tests.

???TITLE??????TITLE??????TITLE???abt_test
???TITLE??????TITLE??????TITLE???abt_group
???TITLE??????TITLE??????TITLE???abt_element
???TITLE??????TITLE??????TITLE???abt_test_group
???TITLE??????TITLE??????TITLE???abt_group_elem
???TITLE??????TITLE??????TITLE???abt_elem_page
???TITLE??????TITLE??????TITLE???abt_elem_pg_frag
???TITLE??????TITLE??????TITLE???abt_elem_rep_slot
???TITLE??????TITLE??????TITLE???abt_elrs_item

Tracking Table

Holds data that describes the progress of tests.

???TITLE??????TITLE??????TITLE???abt_track

ATG Campaign Optimizer for Commerce adds have the following additional tables:

Type of Table

Description

Table Names

Metrics Tables (Commerce)

Holds event data (also called log data) produced from tests.

???TITLE??????TITLE??????TITLE??????TITLE???abl_item_added
???TITLE??????TITLE??????TITLE??????TITLE???abl_order_submit
???TITLE??????TITLE??????TITLE??????TITLE???abl_order_abandon
???TITLE??????TITLE??????TITLE??????TITLE???abl_trnsnt_abandon

Reporting Tables (Commerce)

Holds data used to generate reports.

???TITLE??????TITLE??????TITLE??????TITLE???abr_dcs_rpt_group

Test Definition Tables (Commerce)

Holds data that describes tests.

???TITLE??????TITLE??????TITLE??????TITLE???abt_elem_ctgy_tmp
???TITLE??????TITLE??????TITLE??????TITLE???abt_elct_ctgs
???TITLE??????TITLE??????TITLE??????TITLE???abt_elem_prod_tmp
???TITLE??????TITLE??????TITLE??????TITLE???abt_elpt_prds
???TITLE??????TITLE??????TITLE??????TITLE???abt_elpt_ctgs
???TITLE??????TITLE??????TITLE??????TITLE???abt_elem_promo