Process Stats

{"InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"none","IsDeniedAccess":false,"AppName":null,"IsAppDisabled":false}

{"IsVertical":false,"DisplayHomeLink":true,"HomeLinkText":"","HomeLinkURL":"","VerticalBarBehavior":"Default","NavCompulsoryLinkPosition":false,"SaveExpandedNavItems":false,"SetHorizontalNavTabsActive":false,"Title":"Global Horizontal Nav","InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"","IsDeniedAccess":false,"AppName":"Nav Editor","IsAppDisabled":false}

{"ShowBreadcrumb":true,"IsDateTitleVisible":false,"IsBreadcrumbDateVisible":false,"ShowBookmarkIcon":false,"BookmarkIconURL":"","ShowComments":false,"IncludeCommentHyperLink":true,"ShowStructureLink":false,"StructureLinkUrl":"/applications/SiteContent.aspx","ShowUserProfileDetails":false,"ShowMyContentDetails":true,"ShowSearch":false,"UserProfileBreadcrumbBarOption":null,"ShowPublish":false,"ShowLibrary":false,"ManageCMSLink":"/applications/SiteContent.aspx?index","ManageFilesLink":"/applications/SiteContent.aspx?index","LinkSecurityEnabled":false,"ReadAccessToPublish":true,"DenyAccessToPublish":false,"ReadAccessToLibrary":true,"DenyAccessToLibrary":false,"ExternalLinkForPublish":false,"ExternalLinkForLibrary":false,"MyContentBreadcrumbBarOption":{"IsMyFormsVisible":false,"IsMyEventsVisible":false,"IsMyPagesVisible":true,"IsMustReadVisible":false,"IsMyFilesVisible":true,"IsMyContentVisible":false,"IsAssignNotificationsVisible":false,"IsManageMyNotificationsLinkVisible":false,"IsAnonymous":true,"InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"","IsDeniedAccess":false,"AppName":null,"IsAppDisabled":false},"InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"","IsDeniedAccess":false,"AppName":null,"IsAppDisabled":false}

{"BreadcrumbEntities":[{"breadcrumbEntityLink":"Home","breadcrumbEntityLinkURL":"/","breadcrumbEntityType":"","breadcrumbEntityLinkPartial":"","isCustomCrumb":true},{"breadcrumbEntityLink":"Apps","breadcrumbEntityLinkURL":"/applications/","breadcrumbEntityType":"IntranetDASHBOARD.Core.Subsite, Core","breadcrumbEntityLinkPartial":"","isCustomCrumb":false},{"breadcrumbEntityLink":"iD CMS","breadcrumbEntityLinkURL":"/applications/sitecontent.aspx","breadcrumbEntityType":"IntranetDASHBOARD.idWiki.WikiCategory, WIKI","breadcrumbEntityLinkPartial":"","isCustomCrumb":false},{"breadcrumbEntityLink":"Statistics Reporter","breadcrumbEntityLinkURL":"/applications/statistics_reporter/","breadcrumbEntityType":"IntranetDASHBOARD.idWiki.WikiCategory, WIKI","breadcrumbEntityLinkPartial":"","isCustomCrumb":false},{"breadcrumbEntityLink":"Process Stats","breadcrumbEntityLinkURL":"/applications/statistics_reporter/ProcessStats.html/","breadcrumbEntityType":"IntranetDASHBOARD.idWiki.WikiPage, WIKI","breadcrumbEntityLinkPartial":"","isCustomCrumb":false}],"DateToBeDisplayedAs":"Tuesday, 16 April","BreadcrumbDate":"","DateTitleURL":"","ApplicationName":[],"UserManagerDetails":"","CommentsText":"Comments","NumberOfComments":0,"UserProfileBreadcrumbBarOutput":null,"MyContentBreadcrumbBarOutput":{"MyForms":"","MyFormsURL":"","MyEvents":"","MyEventsURL":"","MustRead":"","MustReadURL":"","ManageMyNotificationsLink":"","ManageMyNotificationsLinkURL":"/applications/Notifications/default.aspx#jqTabs-3","MyContentURL":"","MyPagesURL":"/applications/mypages.aspx","MyFilesURL":"/applications/myfiles.aspx","UsersFullName":"Anonymous "}}

{"IsVertical":true,"DisplayHomeLink":true,"HomeLinkText":"iD Applications","HomeLinkURL":"/applications","VerticalBarBehavior":"Default","NavCompulsoryLinkPosition":false,"SaveExpandedNavItems":false,"SetHorizontalNavTabsActive":false,"Title":"Applications V Nav","InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"","IsDeniedAccess":false,"AppName":"Nav Editor","IsAppDisabled":false}

{"IsVertical":true,"DisplayHomeLink":true,"HomeLinkText":"System Admin","HomeLinkURL":"/systemadmin","VerticalBarBehavior":"Default","NavCompulsoryLinkPosition":false,"SaveExpandedNavItems":false,"SetHorizontalNavTabsActive":false,"Title":"System Admin V Nav","InSiteHeader":false,"IsEmptyControl":false,"ComponentEditMode":"","IsDeniedAccess":false,"AppName":"Nav Editor","IsAppDisabled":false}

Statistics Reporter

Process Stats

Topics

Processing statistics

Advanced statistics processing

Information on Statistics Reporter
Search reporting

Please, login to The Admin to complete the following steps.

Processing statistics

Select Process Stats from the Statistics Reporter menu
Select the Process tab
Select the Processing Type: Automatically or Manually
To Manually process statistics:

- Select Manually under the Process Stats heading

- Click Start, the Current Status will change to Running
To Automatically process statistics:

- Select Automatically under the Process Stats heading

- Select the day(s) you would like the processor to run
(Note: multiple days can be selected by holding CTRL and clicking the desired days)

- Select the date you would like the processor to begin running automatically

- Select the time of day the processor should run (in UTC or GMT time)

- Click Apply to save while remaining on the current page, click OK to save and return to the Statistics Reporter menu

- The statistics will now be processed automatically on the selected day(s), at the selected time, from the selected date
All data processed can be viewed by selecting the View link under the Processing Log File heading. The log file can also be deleted by selecting Clear File
The subsite administrator can be sent an email each time the statistics are processed. To enable this, select Email Notification
Click Apply to save while remaining on the current page, click OK to save and return to the Statistics Reporter menu

^Back To Top

Advanced statistics processing

Select Process Stats from the Statistics Reporter menu
Select the Advanced tab
- Clear old stats until:
  
  When Clear is selected, all statistics older than the selected date will be deleted.
  This is useful for reducing the size of the log tables and freeing up hard disk space.
- Clear stats from:
  
  When Clear is selected, all statistics newer than the selected date will be deleted.
  This is useful for reducing the size of the log tables and freeing up hard disk space.
- Update stats:
  
  When Update has selected all statistics logged on the selected date will be re-processed.
  This is useful for updating recent statistics data without having to re-process all data.
- Reprocess stats for a period:
  
  When Re-Process is selected, all statistics logged in between the selected dates will be updated.
  This is useful for updating recent statistics data without having to re-process all data.

^Back To Top

Information on Statistics Reporter

This page provides general information (properties) about all logged statistics
Select Process Stats from the Statistics Reporter menu
Select the Information tab
The information will be displayed, to reduce the size of the log tables, please see advanced statistics processing

^Back To Top

Search Reporting

Your IT team can run SQL queries to find out what search terms your users have been entering into the Search Bar. This reporting is not contained within the Statistics Reporter Admin menu but can be accessed in 3 ways depending on your requirements.

To run the queries below, please contact your IT department.

Overall list of search terms and counts the number of times they've been searched

SELECT COUNT(Q.SearchQuery) + COUNT((Q.CacheHits -1)) AS TimesSearched, Q.SearchQuery
FROM [Search].[SearchLog] L
INNER JOIN [Search].[SearchQuery] Q
ON L.SearchQueryID = Q.SearchQueryId
GROUP BY Q.SearchQuery
ORDER BY TimesSearched desc
See what terms have been searched for between two dates

SELECT Q.SearchQuery, Q.CacheHits -1, L.SearchTime FROM [Search].[SearchLog] L
INNER JOIN [Search].[SearchQuery] Q
ON L.SearchQueryID = Q.SearchQueryId
WHERE L.SearchTime >= '2012-01-01'
AND L.SearchTime <= '2012-12-30'
Find the number of times a certain term has been searched for

SELECT COUNT(Q.SearchQuery) + COUNT((Q.CacheHits -1)) AS TimesSearched, Q.SearchQuery
FROM [Search].[SearchLog] L
INNER JOIN [Search].[SearchQuery] Q
ON L.SearchQueryID = Q.SearchQueryId
WHERE Q.SearchQuery = '<Search Term Here>'
GROUP BY Q.SearchQuery
ORDER BY TimesSearched desc

Back to Statistics Reporter

Back to Apps

^Back To Top

iD Help refers to iD 8

Viewing: {SubsiteLink}

{UsersFullName}

{Profile Name}

Show older comments

Show newer comments

{Profile Name}

{Profile Name}

Show older comments

Show newer comments

{Title}
in {Category}

{Title}
in {SubCategory}

{Title}
in {Calendar name}

{Title}
in {Room}

{Title}
in {Folder name}

{Title}

{Title}
in {Application Name}

{Title}
in {Subsite iD CMS}

{Title}
in {Subsite iD CMS}

{Title}
in {iD CMS Folder}

Share this component
Share Name	*
Add this component to current template Note: You must save the page to Live for this to take effect

Viewing: {SubsiteLink}

{UsersFullName}

{Profile Name}

Show older comments

Show newer comments

{Profile Name}

{Profile Name}

Show older comments

Show newer comments

{Title} in {Category}

{Title} in {SubCategory}

{Title} in {Calendar name}

{Title} in {Room}

{Title} in {Folder name}

{Title}

{Title} in {Application Name}

{Title} in {Subsite iD CMS}

{Title} in {Subsite iD CMS}

{Title} in {iD CMS Folder}

{Title}
in {Category}

{Title}
in {SubCategory}

{Title}
in {Calendar name}

{Title}
in {Room}

{Title}
in {Folder name}

{Title}
in {Application Name}

{Title}
in {Subsite iD CMS}

{Title}
in {Subsite iD CMS}

{Title}
in {iD CMS Folder}