SharePoint reports

Analytics new Available from version 14.0.0

SharePoint reports is an additional section in Analytics (new) dedicated to the SharePoint integration. It was built to help you understand user engagement, see popular content and authors, optimize the search engine and much more.

Before you can use SharePoint reports, you need to integrate with SharePoint with help from our technical support. During the integration process, you’ll learn how to set up tracking and organize reporting. But for the need of this article, we’ll just explain some basics.

SharePoint is organized around site collections that are similar to websites. A site collection is a group of sites that have the same owner and share administrative settings. When you track SharePoint with Piwik PRO, you set each site collection as a separate website (Websites & apps). When you collect data from many site collections, it’s best to create and use meta sites for reporting. With this setting, you can see all site collections in a single view.

Note: Site collection is called Website name in Piwik PRO because it is tracked as a website (Websites & apps).

To view SharePoint reports, follow these steps:

  1. Go to Menu > Analytics (new).
  2. Navigate to SharePoint.
SharePoint reports in Piwik PRO.

SharePoint reports are grouped under four categories: site collection performance, content, social engagement and internal search. They include over thirty metrics and dimensions dedicated to the SharePoint analytics, including likes, shares, comments, user data, author data, file types and more. Let’s look at each category.

Site collection performance

Site collection performance was designed to analyze data from many SharePoint site collections. As we’ve mentioned before, to make the most use of it, you need to add meta sites that combine data from several sites.

In this section, you’ll find the following reports:

  • Engagement: It shows traffic grouped by office and department and lets you analyze user engagement by job title and user ID.
  • Content usage: It helps you understand how people use pages, files and lists across all SharePoint sites. It reports on views, openings, likes, shares and more.
  • Popular content: It shows the most trending pages grouped by SharePoint sites (Website name in Piwik PRO).
  • Internal search: It shows what was searched for in the SharePoint search engine. Reporting is grouped by SharePoint sites (Website name in Piwik PRO).
SharePoint reports in Piwik PRO.

Content

Content was created to help you analyze how pages, lists and files are used, edited and shared in SharePoint. In most sections, reporting was grouped by office, department, job title and user ID for a more detailed perspective.

In this section, you’ll find the following reports:

  • Overview: It gives you a topline view on how people use content on a single SharePoint site. 
  • Page usage: It reports on how people use, share and promote pages. It includes a section with content type that can be a site page, news page, wiki or a default type created by the SharePoint user. Reporting is also grouped by office, department, job title and user ID.
  • Page activity: It shows what changes people make with pages, for example, post, edit or delete a page. It also includes a section dedicated to tracking page shares and promotions. 
  • File usage & activity: It focuses on how people create, use, share and delete files. Reporting is grouped by file URL, file type, office, department, job title and user ID.
  • List usage & activity: Analogically to the previous report, this one shows how people create, use, edit and share lists. Reporting is grouped by list URL, list type, office, department, job title and user ID.
SharePoint reports in Piwik PRO.

Social engagement

Social engagement was made to help you monitor social interactions with pages, such as likes, comments, shares. In this report, you can find the most engaging content and most popular authors. It shows data grouped by office, department, job title and user ID for a more detailed perspective.

In this section, you’ll find the following reports:

  • Popular content: It shows which pages are popular among SharePoint users. 
  • Popular authors: It focuses on popular authors creating content on your SharePoint site.
SharePoint reports in Piwik PRO.

Internal search

Internal search was designed to help you see what people are looking for in the SharePoint search engine and how they click in search results. Reporting was grouped by keywords, categories, clicked pages, office, department, job title and user ID.

In this section, you’ll find the following reports:

  • Searches: It tells you what phrases people are using in the search engine and where they click. It also lets you see who (user ID) was looking for what.
  • Failed search: It shows you keywords that didn’t lead to clicks. In other words, people searched for something but left the page with search results.
  • Search with no result: It reports on keywords that are not bringing search results and helps you discover content that may be necessary to add to your knowledge base.
SharePoint reports in Piwik PRO.

To each SharePoint report, you can apply segments, export the report to a CSV, XML, JSON, or JSON (KV) file format, or customize the report.

SharePoint metrics

In SharePoint reports, you will find the following dedicated metrics:

  • Likes (SharePoint): The number of likes that content has received. It doesn’t include comment likes. 
  • Shares (SharePoint): The number of shares such as: Copy link or Send message.
  • Comments (SharePoint): The number of posted comments and comment replies.
  • Promotions (SharePoint): The number of page promotions such as: Add page to navigation, Post as news, Save as template.
  • Creations (SharePoint): The number of created objects. The creation is counted when a user creates a page, file, and the like.
  • Edits (SharePoint): The number of object edits. The edit is counted when a user edits a page, file, and the like.
  • Deletions (SharePoint): The number of object deletions. The deletion is counted when a user deletes a page, file, and the like.
  • File openings (SharePoint): The number of file openings. The file opening is counted when a user clicks a file in SharePoint to open it. It doesn’t include openings of attachments from list items. (See: Item attachment views) 
  • Uploads (SharePoint): The number of uploaded files.
  • Item views (SharePoint): The number of item views. The item view is counted when a user sees an item on the list by clicking on it or entering a direct URL.
  • Item attachment views (SharePoint): The number of item attachment views. The item attachment view is counted when a user views an item attachment on the list by clicking on it.
  • Item shares (SharePoint): The number of shares of items on the list.

See also the full list of metrics and dimensions dedicated to SharePoint.

Was this article helpful?

Be the first to rate this article.

Technical Support

If you have any questions, drop us a line at support_SPC@piwik_SPC.pro.

We’re happy to help!