使用 Power BI 连接到 Adobe AnalyticsConnect to Adobe Analytics with Power BI

通过 Power BI 连接到 Adobe Analytics 首先会连接到你的 Adobe Analytics 市场营销云帐户。Connecting to Adobe Analytics through Power BI starts by connecting to your Adobe Analytics Marketing Cloud account. 你将获得一个带 Power BI 仪表板和一组 Power BI 报表的应用,这些报表会提供网站流量和用户维度的相关见解。You get an app with a Power BI dashboard and a set of Power BI reports that provide insights about your site traffic and user dimensions. 此数据每天自动刷新一次。The data is refreshed automatically once per day. 可以与仪表板和报表进行交互,但不能保存更改。You can interact with the dashboard and reports, but you can't save changes.

连接到 Adobe Analytics,或阅读有关使用 Power BI 进行 Adobe Analytics 集成的详细信息。Connect to Adobe Analytics or read more about the Adobe Analytics integration with Power BI.

如何连接How to connect

  1. 选择左侧导航窗格中的“应用”,然后选择右上角的“获取应用”。Select Apps in the left navigation pane > select Get apps in the upper-right corner.

    “获取应用”图标

  2. 在 AppSource 中,选择“应用”选项卡,然后搜索所需的服务。In AppSource, select the Apps tab, and search for the service you want.

    AppSource 中的“应用”选项卡

  1. 选择Adobe Analytics > 获取Select Adobe Analytics > Get.

  2. Power BI 连接到特定 Adobe Analytics 公司和报表套件 ID(而不是报表套件名称)。Power BI connects to a specific Adobe Analytics Company and Report Suite ID (not the Report Suite name). 请参阅下面有关查找这些参数的详细信息。See details on finding those parameters below.

  3. 对于身份验证方法,选择oAuth2>登录For Authentication Method, select oAuth2 > Sign In. 出现提示时,输入 Adobe Analytics 凭据。When prompted, enter your Adobe Analytics credentials.

  4. 单击接受以允许 Power BI 访问你的 Adobe Analytics 数据。Click Accept to allow Power BI to access your Adobe Analytics data.

  5. 在你批准后,导入过程会自动开始。After you approve, the import process begins automatically.

查看 Adobe Analytics 仪表板和报表View the Adobe Analytics dashboard and reports

导入完成后,新的应用将显示在“应用”页上。When the import is complete, the new app will appear on the Apps page.

  1. 选择左侧导航窗格中的“应用”,然后选择应用。Select Apps in the left navigation pane > select the app.

    左侧导航窗格中的“应用”

  2. 可以通过在问答框中键入来提出问题,或单击磁贴打开基础报表。You can ask a question by typing in the Q&A box, or click a tile to open the underlying report.
  ![Adobe Analytics dashboard](media/service-connect-to-adobe-analytics/dashboard.png)

下一步?What now?

  • 在仪表板顶部,尝试在“问答”框中提问Try asking a question in the Q&A box at the top of the dashboard.
  • 选择磁贴以打开基础报表。Select a tile to open the underlying report.
  • 可以筛选和突出显示报表中的数据,但不能保存所做的更改。You can filter and highlight the data in the report, but you can't save your changes.
  • 计划每日刷新数据集。Your dataset is scheduled to refreshed daily. 可以更改刷新计划或根据需要使用“立即刷新”来尝试刷新。You can change the refresh schedule or try refreshing it on demand using Refresh Now.

包含的内容What's included

Power BI 使用 Adobe Analytics 报表 API 为以下表定义和运行报表:Power BI uses the Adobe Analytics Report API to define and run reports for the following tables:

表名Table Name 列详细信息Column Details
产品Products elements= "product" (top 25)elements= "product" (top 25)
metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
浏览器Browsers elements= "browser" (top 25)elements= "browser" (top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews"
页面Pages elements= "page" (top 25)elements= "page" (top 25)
metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "visits", "uniquevisitors", "pageviews", "bounces", "bouncerate", "totaltimespent"metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "visits", "uniquevisitors", "pageviews", "bounces", "bouncerate", "totaltimespent"
JavaScript 已启用JavaScript Enabled elements= "javascriptenabled”, “browser” (top 25)elements= "javascriptenabled”, “browser” (top 25)
移动 OSMobile OS elements= "mobileos"(top 25)elements= "mobileos"(top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "checkouts", "revenue", "units", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "checkouts", "revenue", "units", "pageviews"
搜索引擎关键字Search Engines Keywords elements= "searchengine" "searchenginekeyword"elements= "searchengine" "searchenginekeyword"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
搜索引擎到产品Search Engine to Products elements= "searchengine", "product"elements= "searchengine", "product"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
引用页面Referring Pages elements= "referrer" (top 15), “page" (top 10)elements= "referrer" (top 15), “page" (top 10)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
Geocountry 页面Geocountry Pages elements= "geocountry" (Top 20), "page"elements= "geocountry" (Top 20), "page"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
Geocountry 产品Geocountry Product elements= "geocountry" (Top 20), "product"elements= "geocountry" (Top 20), "product"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
国家和地区查找Country and Region Lookup elements= "geocountry" (Top 200)elements= "geocountry" (Top 200)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
语言Language elements= "language", "browser" (Top 25)elements= "language", "browser" (Top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews", "cartadditions", "cartremovals", "checkouts", "carts", "cartviews"metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews", "cartadditions", "cartremovals", "checkouts", "carts", "cartviews"
搜索引擎查找Search Engines Look Up elements= "searchengine" (top 100)elements= "searchengine" (top 100)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
浏览器查找Browser Lookup elements= "browser" (top 25)elements= "browser" (top 25)

系统要求System requirements

需要可以访问 Adobe Analytics,包括可以按如下所述访问正确参数。Access to Adobe Analytics is required, including access to the correct parameters as described below.

查找参数Finding parameters

公司Company

登录之后,可以在帐户右上角找到公司值。The Company value can be found in the top right of your account once you're signed in. 该值区分大小写并且需要注意间距。The value is case and spacing sensitive. 请完全按照帐户中显示的内容输入。Enter it exactly as you see in your account.

报表套件 IDReport Suite ID

创建报表套件时会创建套件 ID。The Suite ID is created when the Report Suite is created. 可以与管理员联系以确定 ID 值。You can contact your administrator to identify the ID value. 请注意,这不是报表套件名称。Note that this is not the Report Suite name.

来自 Adobe 文档From Adobe documentation:

故障排除Troubleshooting

如果你在提供凭据之后看到指示你没有权限的错误,请向管理员确认你有权访问 Adobe Analytics API。If you're seeing an error after providing your credentials indicating you do not have permissions, please confirm with your admin that you have access to the Adobe Analytics API. 还需确认提供的 Adobe ID 链接到市场营销云组织(关联到 Adobe Analytics 公司)。Also confirm the Adobe ID provided is linked to your Marketing Cloud Organization (associated to an Adobe Analytics company).

如果你在遇到错误之前已成功通过凭据屏幕,则可能是报表完成花费的时间太长。If you've successfully passed the credentials screen before encountering an error, it's possible the reports are taking too long to complete. 常见错误形式如下:“未能从 Adobe Analytics 报表获取数据。内容包括"引用方,页面",大致持续时间为 xx 秒”A common error is in the form *"Failed to get data from the Adobe Analytics report. Contents included "referrer, page", approximate duration was xx seconds". 请查看“包含的内容”部分,并与 Adobe 实例的大小进行比较。Please review the "What's included" section and compare to the size of your Adobe instance. 遗憾的是,目前尚无法解决此超时问题。Unfortunately there isn't a way to work around this timeout today. 但我们正考虑进行更新以支持较大实例,请在 https://ideas.powerbi.com 向我们的 Power BI 团队提供反馈However, we're considering updates to better support larger instances, please provide feedback to the Power BI team at https://ideas.powerbi.com

后续步骤Next steps