What do the values in the 'windows' field of the Knowledge Foundation tables mean?
Environment:
All sites on the November 2011 version or more recent
Resolution:
The following Knowledge Foundation tables were added beginning with the November 2011 version of Oracle RightNow CX:
kf_action_stats - collects detailed statistics on pages and other 'clickstreams' actions
kf_answer_stats - collects detailed statistics on answers
kf_error_stats - collects statistics on errors and preceding 'clickstreams' actions
kf_escalation_sessions - collects statistics on escalations grouped by session type
kf_escalation_stats - collects statistics on escalations from various sources
kf_referrer_stats - collects statistics on referring sites and search queries
kf_sa_log -details of SmartAssistant transaction data (i.e. search text) for joining against rows in the 'clickstreams' table
kf_search_stats - collects detailed statistics on searches
kf_searches - records stemmed searches
kf_smartassistant_stats - collects statistics on SmartAssistant usage
kf_top_item_stats - collects additional statistics on answers and searches
With the exception of the 'kf_sa_logs' and 'kf_searches' tables, each of the abovementioned tables contains a 'windows' field (i.e. kf_action_stats.window) that portrays the aggregation time period. This field will contain one of the following values:
0 = hourly
1 = daily
2 = monthly
3 = yearly
The data in the Knowledge Foundation tables is aggregated from the 'clickstreams' table by the dataminer utility based on the type of activity for a given time interval per interface. For more descriptive information on how the data is aggregated, please reference Answer ID 5922: Dataminer aggregation of knowledge foundation tables