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 containing 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. We 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. We can change the frequency of this job; see Statistics considerations

Staging environments and statistics

Typically, statistics about how customers are using the site are captured on the production environment. These statistics can be transferred from the production environment to the development or staging environment for analysis by running a series of commands, whenever the information is required. Attention: Instead of following the procedure in this topic, we can use the DownloadStatistics scheduled job to transfer your marketing and search rule statistical data from your production environment to your staging environment. 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.

Disable marketing statistics

If we are not using the marketing statistics, we can disable the collecting of these statistics. See Disable marketing statistics

Related tasks
Enable the collection of marketing statistics in Management Center
Enable the collection of statistics for search rule experiments
Scheduling the DownloadStatistics job to copy marketing and search statistics
Copying marketing statistics from the production environment
Disable marketing statistics
Manage activity statistics