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
- Select Get Data at the bottom of the left navigation pane.
2. In the Services box, select Get.
3. Select Webtrends SharePoint > 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.
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.
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.
7. The Dataset, Report, and Dashboard can be renamed in Power BI, which is useful when connecting to more than one profile.
The Webtrends content pack pulls data from the following reports:
|Report Name||Report GUID|
|Device Types: Platforms||fsq7Ddgwgh7|
|Document File Paths Interactions||2L06pOcFGh7|
|On-site Search Phrases||vloldX5JKh7|
|Site Names: Pages||XtKq9oh4Hh7|
|Referrers: Pages (Initial)||zgHIecOP0P6|
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.
Your Webtrends Profile ID can be found in the URL after you’ve selected a profile:
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:
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.
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.
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.
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.
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.
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.
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
- The correct Profile ID is being used, see the Finding Parameters for more details.
- The profile has all the required reports listed in the “What’s included” section enabled.
- The user has access to view the reports through their user permissions.