Marketing statistics: storage and update frequency

For Management Center campaigns, activities, and experiments, statistics are gathered and stored in a series of WebSphere Commerce database tables on the production server.

Statistics for marketing activities and e-Marketing Spots

These statistics are gathered and stored in the tables automatically and do not require specific components to be enabled. In the Management Center Marketing tool, business users can view these statistics by opening the activity or e-Marketing Spot.

Database tables that contain marketing statistics
Table name	Type of marketing statistics
DMEMSPOTSTATS	This table gathers statistics for an e-Marketing Spot used in an activity. This table records the number of times the server displays content in the e-Marketing Spot for a specific activity. The table also records the number of times that a customer clicks the content.
DMELESTATS	This table gathers statistics for each element in an activity flow, that is, the triggers, targets and actions. It records the number of times a customer reaches each element in a specific activity.

Statistics for marketing experiments

To gather these statistics, a Site Administrator must enable two components: ExperimentEvaluationEventListener and OrderSubmissionEvent. In the Management Center Marketing tool, business users can view statistics for marketing experiments on a Statistics tab for the activity that contains the experiment.

Database tables that contain marketing experiment statistics
Table name	Type of marketing statistics
DMEXPSTATS	This table gathers statistics for test elements in activities that contain marketing experiments. Statistical data for each test element includes views, view orders, view revenue, clicks, click orders, and click revenue.

Frequency of statistical updates

To gather marketing statistics (excluding revenue statistics for experiments), the server uses the SaveMarketingStatistics scheduled job. By default, this job runs every 15 minutes. You can change the frequency of this job; see Scheduling the SaveMarketingStatistics job.

To gather revenue statistics for experiments, the server uses the RaiseECEvent scheduled job. By default, this job runs every 5 minutes. You can change the frequency of this job; see Statistics considerations

Staging servers and statistics

Typically, statistics about how customers are using your site are captured on the production server. These statistics can be transferred from the production server to the development or staging server for analysis by running a series of commands, whenever the information is required. See Copying marketing statistics from the production server

Attention: Instead of following the procedure in this topic, you can use the DownloadStatistics scheduled job to transfer your marketing and search rule statistical data from your production server to your staging server. For more information, see Scheduling the DownloadStatistics job to copy marketing and search statistics.

Clearing marketing statistics

Marketing statistics accumulate over time. The only way to clear and reset marketing statistics is to manually delete the database records from the applicable database table (DMEMSPOTSTATS, DMELESTATS, and DMEXPSTATS). Before you delete the database records, run the SaveMarketingStatistics scheduled job; see Scheduling the SaveMarketingStatistics job.

Disabling marketing statistics

If you are not using the marketing statistics, you can disable the collecting of these statistics. For more information, see Disabling marketing statistics