When you use the menu item Action ► Publish Reporting Data in SAS^® Customer Intelligence Studio, SAS Marketing Automation publishes reporting information to the Common Data Model. When you manually publish data in this way for a scheduled, recurring campaign, SAS Marketing Automation might write an extra observation to the following two tables:

• CI_PACKAGE_X_TREATMENT
• CI_CELL_PACKAGE_TREATMENT_CNT

The following scenario describes the steps that lead to the problem in further detail:

1. A scheduled recurring campaign is executed at least once.
2. A treatment for an associated package is modified.
3. The campaign is manually published. The act of publishing manually writes future occurrence records to the tables CI_PACKAGE_X_TREATMENT and CI_CELL_PACKAGE_TREATMENT_CNT.
4. The treatment is modified for a second time.
5. The recurring campaign is executed again.

After the final step, above, the CI_PACKAGE_X_TREATMENT and CI_CELL_PACKAGE_TREATMENT_CNT tables have two sets of records for the latest campaign occurrence. The records written by the manual publish step and the records written when the campaign is re-executed are both present in the two tables mentioned above. Both sets of records that are written for this occurrence have counts associated with them. It is impossible to determine which treatment was associated with the package at the time that the occurrence was actually executed.

Operating System and Release Information