Webtrends SharePoint PowerBI Content Pack

The Webtrends SharePoint content pack for Power BI includes a variety of out of box metrics such total page views and visits by traffic source. Visualizing your Webtrends data in Power BI starts by connecting to your Webtrends account. You can use the dashboard and reports provided, or customize them to highlight the information you care most about.  The data will be refreshed automatically once per day.

Connect to the Webtrends content pack for Power BI.

How to connect

  1. Select Get Data at the bottom of the left navigation pane.

Get Data

2. In the Services box, select Get.

Choose Service

3. Select Webtrends SharePoint > Get it now

Get it Now

4. The content pack connects to a specific Webtrends profile ID. See details on finding this in the Finding Parameters section below.

Profile ID

5. Provide your Webtrends credentials to connect using Basic Authentication. Note that the username field expects both your account and username separated by a backslash. See details on this in the Finding Parameters section below.

Credentials

6. After approving, the import process will begin automatically. When complete, a new dashboard, report and model will appear in the Navigation Pane. Select the dashboard to view your imported data.

Content Pack Preview

7. The Dataset, Report, and Dashboard can be renamed in Power BI, which is useful when connecting to more than one profile.

What’s included

The Webtrends content pack pulls data from the following reports:

Report Name Report GUID
Profile Metrics ProfileMetrics
Geo: Drilldown eWWNKPMP0P6
Browsers: Resolutions 6EQdWDnP0P6
Browsers: Versions AjzTAInP0P6
Device Types: Platforms fsq7Ddgwgh7
Document File Paths Interactions 2L06pOcFGh7
On-site Search Phrases vloldX5JKh7
Sessions: Depth gBTqJcmP0P6
Site Names: Pages XtKq9oh4Hh7
Site Pages B7afn4NP0P6
Referrers: Pages (Initial) zgHIecOP0P6

System requirements

The content pack requires access to a Webtrends profile with the correct set of reports enabled.  These reports are available as part of the default SharePoint 2013 Space through the A10 interface.  Use of other Space/Profile Types will not provide the required reports by default, and an error attempting to pull the data will occur.

Finding parameters

Your Webtrends Profile ID can be found in the URL after you’ve selected a profile:

Find Profile ID

Your credentials are the same as what you enter when you sign into Webtrends, however we expect your account and username in the same line, separated by a backslash:

Credentials Format

Data

The Webtrends for SharePoint content pack provides data from 11 reports and displays them in 3 primary ways across 7 different pages.

Month Over Month Overview

The initial Month Over Month Overview page provides a 25 month rolling trend, including the current month.  This data includes the Profile Metrics and the Geo: Drilldown reports.  The Overview Trend, Bounce Rate Trend, and Time Trend provide trended data using a Monthly period.  The Regional Overview supports drilling down from the Region to the Country, State/Province, and City, and provides aggregate numbers for the same 25 month period.  Hovering over any point in the trend graphs or bubbles on the map will provide individual numbers.

Day Over Day Overview

The Day Over Day Overview page is identical to the Month Over Month Overview page, except that it utilizes the last 90 full days (excluding today) in a Daily trend and aggregated 90 day period for the Regional Overview report.

Traffic Overview

The Traffic Overview page provides the last 90 Days in aggregate for each report.  The first graph is the Site Name Overview, which shows the data based on each Site Name.  This supports drilling into the graph to see the individual Pages for each of the Site Names.  The Referrer Overview shows the referring URLs to the profile for the last 90 Days.  This support drilling into to move from the domain to up to two sub directories deep.  The Page Views per Session report provides a view of how many sessions consist of a single Page View, two Page Views, etc.

Technology Overview

The Technology Overview page also displays data for the last 90 Days in aggregate.  The first graph provides the Device Type for visits to the site(s).  This is supports drilling into to view the Operating Systems used by each Device Type.  The Browser Overview shows the Browser for each visit, and can be drilled into to view the Browser Version in each case.  The final Screen Size Overview report lists the various screen resolutions used to view the site.

Search Overview

The Search Overview page also utilizes a 90 Day aggregate time period.  The On-site Search Overview graph provides the most used search terms, including a measurement of how often a search result was clicked on.  The Search Success Overview graph displays the number of unsuccessful searches (results were not found) vs the number of successful searches (results were found) in a format to help illustrate a ratio of unsuccessful vs successful searches.

Pages Overview

The Pages Overview page uses both a 90 Day aggregate time period.  The first Page Overview graph displays the pages organized by Page Title, and can be drilled into to view the URL of the page.  Selections in this graph update the table view with additional measures visible for the page.  The second Page Overview graph and associated table provide the same functionality, except they are limited to a 7 Day aggregated period.

Documents Overview

The Documents Overview uses a 90 Day aggregated time period and displays the top Documents utilized across the site(s).  This supports drilling based on the domain of the Document as the primary level, and the URL as the secondary level.

Troubleshooting

You may hit an issue while the content pack is loading, after you’ve provided your credentials. If you see an “Oops” message during the loading, please review the troubleshooting suggestions below. If you’re still having issues please file a support ticket at https://support.powerbi.com

  1. The correct Profile ID is being used, see the Finding Parameters for more details.
  2. The profile has all the required reports listed in the “What’s included” section enabled.
  3. The user has access to view the reports through their user permissions.