使用 Power BI 连接到 WebtrendsConnect to Webtrends with Power BI

适用于 Power BI 的 Webtrends 内容包包括各种现成指标,如(按流量源)网页浏览总数和访问总数。The Webtrends content pack for Power BI includes a variety of out of box metrics such total page views and visits by traffic source. 首先通过连接到 Webtrends 帐户将 Power BI 中的 Webtrends 数据可视化。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.

连接到适用于 Power BI 的 Webtrends 内容包。Connect to the Webtrends content pack for Power BI.

连接方式How to connect

  1. 选择左侧导航窗格底部的获取数据Select Get Data at the bottom of the left navigation pane.

  2. 服务框中,选择获取In the Services box, select Get.

  3. 选择 Webtrends > 获取Select Webtrends > Get.

  4. 此内容包会连接到特定的 Webtrends 配置文件 ID。The content pack connects to a specific Webtrends profile ID. 请参阅下面有关查找此参数的详细信息。See details on finding this parameter below.

  5. 提供 Webtrends 凭据进行连接。Provide your Webtrends credentials to connect. 请注意,用户名字段应该为帐户和用户名。Note that the username field expects your account and username. 请参阅以下详细信息See details 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.

下一步?What now?

包含的内容What's included

Webtrends 内容包从下列报表中提取数据:The Webtrends content pack pulls data from the following reports:

报表名称Report Name 报表 IDReport ID
关键指标Key Metrics
网站搜索On-Site Searches 34awBVEP0P634awBVEP0P6
退出页面Exit Pages 7FshY8eP0P67FshY8eP0P6
下一页Next Pages CTd5rpeP0P6CTd5rpeP0P6
上一页Previous Pages aSdOeaUgnP6aSdOeaUgnP6
网站页面Site Pages oOEWQj3sUo6oOEWQj3sUo6
网站广告点击率Onsite Ads Clickthroughs 41df19b6d9f41df19b6d9f
城市Cities aUuHskcP0P6aUuHskcP0P6
国家/地区Countries JHWXJNcP0P6JHWXJNcP0P6
访问者Visitors xPcmTDDP0P6xPcmTDDP0P6
访问持续时间Visit Duration U5KAyqdP0P6U5KAyqdP0P6
搜索短语Search Phrases IKYEDxIP0P6IKYEDxIP0P6
流量源Traffic Sources JmttAoIP0P6JmttAoIP0P6
搜索引擎Search Engines yGz3gAGP0P6yGz3gAGP0P6
进入页Entry Pages i6LrkNVRUo6i6LrkNVRUo6

备注

对于 SharePoint 配置文件,指标名称可能与 Webtrends 用户界面中显示的稍有不同。For SharePoint profiles, the metric names may be a little different than what's show in the Webtrends UI. 执行下列映射以保持 SharePoint 和 Web 配置文件之间的一致性:The following mapping is done to maintain consistency between SharePoint and Web profiles:

- <span data-ttu-id="af18b-161">会话数 = 访问数</span><span class="sxs-lookup"><span data-stu-id="af18b-161">Sessions = Visits</span></span>  
- <span data-ttu-id="af18b-162">新用户数 = 新访问者数</span><span class="sxs-lookup"><span data-stu-id="af18b-162">New Users = New Visitors</span></span>  
- <span data-ttu-id="af18b-163">每个会话的查看数 = 每次访问的页面浏览数</span><span class="sxs-lookup"><span data-stu-id="af18b-163">Views per Session = Page Views per Visit</span></span>  
- <span data-ttu-id="af18b-164">平均每日用户持续时间 = 每个访问者访问该站点的平均时间</span><span class="sxs-lookup"><span data-stu-id="af18b-164">Avg Daily User Duration = Avg Time on Site per Visitor</span></span>  

系统要求System requirements

此内容包需要具有对 Webtrends 配置文件的访问权限,且已启用正确的报表集The content pack requires access to a Webtrends profile with the correct set of reports enabled.

查找参数Finding parameters

选择配置文件后,你可以在 URL 中找到你的 Webtrends 配置文件 ID:Your Webtrends Profile ID can be found in the URL after you've selected a profile:

你的凭据将与登录到 Webtrends 时输入的凭据相同,但是帐户和用户名应该在同一行,用反斜杠分隔: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:

故障排除Troubleshooting

提供凭据后,加载此内容包时可能会遇到问题。You may hit an issue while the content pack is loading, after you've provided your credentials. 如果在加载期间看到“糟糕”消息,请查看以下故障排除建议。If you see the "Oops" message during the loading, please review the troubleshooting suggestions below. 如果仍遇到问题,请在 https://support.powerbi.com 提交支持票证If you're still having issues please file a support ticket at https://support.powerbi.com

  1. 正在使用正确的配置文件 ID,有关详细信息,请参阅查找参数The correct Profile ID is being used, see the Finding Parameters for more details.
  2. 具有访问权限的用户已在“包含的内容”部分列出The user has access to the reports listed in the "What's included" section

后续步骤Next steps

Power BI 入门Get started with Power BI

Power BI - 基本概念Power BI - Basic Concepts