Agedatabase Configuration Settings for Reports

The configuration settings described here are in the Agedatabase folder. These settings let you set the aggressiveness of the utility’s data caching and purging, and specify values used by certain opportunity tracking reports that use cached data.

The Agedatabase utility automatically runs on the server hosting your site. The utility’s main function is to perform automatic maintenance on your knowledge base (for example, aging incidents and answers). However, Agedatabase also caches report data into individual report tables to make report generation more efficient, and it purges old information that's no longer needed for reports to help maintain the efficiency of your database.

Caution: Changes made to configuration settings can greatly impact the performance and functionality of your entire site. Before you change any configuration setting, it is important that your organization understands the impact of changing the setting.

This table describes the Agedatabase configuration settings that impact reporting.

Agedatabase Utility Analytics Settings

Configuration Setting	Description
Agedatabase/Batch Processing/Miscellaneous Purging
PURGE_CS_SESSION_SUMMARY	Specifies the number of days after which clickstream session summary statistics are removed from the database. Set this value to 0 to prevent this information being removed from the database. The default value for this setting is 60. The minimum, non-zero value you can enter is 8.
PURGE_DELETE_INC_PERFORMANCE	Specifies the number of days after which incident performance statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 0.
PURGE_DELETE_KEYWORD_SEARCHES	Specifies the number of days after which keyword search statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 120.
PURGE_DELETE_QUEUE_STATS	Specifies the number of days after which queue statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 120.
PURGE_DELETE_SESSION_SUMMARY	Specifies the number of days after which session summary statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 0.
PURGE_DELETE_TM_STATS	Specifies the number of days after which Techmail statistics stored in the Techmail Filter Details (tm_filter_details) and Techmail Statistics (tm_stats) tables will be deleted. A value of 0 disables purging of these tables. The default value for this setting is 30.
PURGE_DELETE_USER_TRANS	Specifies the number of days after which login/logout sessions are removed from the user_trans table (relative to the logout time). Set this value to 0 to prevent login/logout sessions from being removed from the database. The default value for this setting is 0.
PURGE_DELETE_VOICE_STATS	Specifies the number of days after which voice statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 90. For sites with multiple interfaces, statistics are removed from all interfaces based on the interfaces’ smallest non-zero value for this setting.
PURGE_GUIDE_SESSIONS	Specifies the number of days after which guided assistance session data will be deleted. Set this value to 0 to prevent session data from being deleted. The default value for this setting is 30.
PURGE_GUIDE_STATS	Specifies the number of days after which guided assistance statistics are removed from the database. Set this value to 0 to prevent statistics from being removed from the database. The default value for this setting is 0.
PURGE_QUEUED_REPORT_DAYS	Specifies the number of days after which files that store the output from queued reports and dashboards are deleted. The default value for this setting is 7 days.
PURGE_RULE_LOG_FREQ	Specifies the number of days after which Rule Log entries are deleted. The maximum value for this setting is 180. A value of zero results in the data being deleted after 180 days. The default value for this setting is 30.
Agedatabase/Batch Processing/Opportunities
OPP_SNAPSHOTS_SCHEDULE	Specifies the day of the week that the opportunities table is cached for the current sales period(s). Values refer to the day of week, with 1 being Sunday, 2 being Monday, and so on. A value of 0 disables opportunity caching. The default value for this setting is 6 (Friday).
Agedatabase/Batch Processing/Gap Analysis
GAP_FREQUENCY	Specifies how frequently (in days) the Information Gap report is generated. The default value for this setting is 7.
GAP_TIME_PERIOD	Specifies the time period reported on in the Information Gap report. The report will analyze incidents created during the specified number of days. The default value for this setting is 7.
Agedatabase/Batch Processing/Sales Performance
SALES_TOP_PERFORMER_THRESHOLD	Specifies the quota attainment threshold as a percentage that a given salesperson should meet to be classified as a “Top Performer.” The default value for this setting is 95.
SALES_TP_METRIC_BALANCE	Specifies the relative value from 1-10 of money versus opportunity counts in reviewing a salesperson or group’s current performance. A value of 5 means they're treated equally. A value of 7 means that total monetary value of opportunities is more important than the number of opportunities. A value of 3 means that the number of opportunities is more important than the total value of those opportunities. The default value for this setting is 5.
SALES_TP_REL_VALUE_CLOSED	Specifies the relative value from 1-10 of a salesperson or group’s closed revenue in reviewing current performance. This value is relative to the other SALES_TP_REL_VALUE_* configuration settings. The default value for this setting is 5.
SALES_TP_REL_VALUE_LOST	Specifies the relative value from 1-10 of a salesperson or group’s lost revenue in reviewing current performance. This value is relative to the other SALES_TP_REL_VALUE_* configuration settings. The default value for this setting is 5.
SALES_TP_REL_VALUE_NEW_BUSINESS	Specifies the relative value from 1-10 of a salesperson or group’s closed revenue of new business in reviewing current performance. This value is relative to the other SALES_TP_REL_VALUE_* configuration settings. The default value for this setting is 5.
SALES_TP_REL_VALUE_PIPELINE	Specifies the relative value from 1-10 of a salesperson or group’s pipeline in reviewing current performance. This value is relative to the other SALES_TP_REL_VALUE_* configuration settings. The default value for this setting is 5.