Connect to Adobe Analytics with Power BI

Connecting to Adobe Analytics through Power BI starts by connecting to your Adobe Analytics Marketing Cloud account. 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.

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.

    Get apps icon

  2. In AppSource, select the Apps tab, and search for the service you want.

    Apps tab in AppSource

  1. Select Adobe Analytics > Get.

  2. 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. For Authentication Method, select oAuth2 > Sign In. When prompted, enter your Adobe Analytics credentials.

  4. Click Accept to allow Power BI to access your Adobe Analytics data.

  5. After you approve, the import process begins automatically.

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.

    Apps in the left navigation pane

  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 uses the Adobe Analytics Report API to define and run reports for the following tables:

Table Name Column Details
Products elements= "product" (top 25)
metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
Browsers elements= "browser" (top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews"
Pages elements= "page" (top 25)
metrics="cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "visits", "uniquevisitors", "pageviews", "bounces", "bouncerate", "totaltimespent"
JavaScript Enabled elements= "javascriptenabled”, “browser” (top 25)
Mobile OS elements= "mobileos"(top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "checkouts", "revenue", "units", "pageviews"
Search Engines Keywords elements= "searchengine" "searchenginekeyword"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
Search Engine to Products elements= "searchengine", "product"
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)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
Geocountry Pages elements= "geocountry" (Top 20), "page"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units", "pageviews"
Geocountry Product elements= "geocountry" (Top 20), "product"
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
Country and Region Lookup elements= "geocountry" (Top 200)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
Language elements= "language", "browser" (Top 25)
metrics="bounces", "bouncerate", "visitors", "visits", "uniquevisitors", "totaltimespent", "pageviews", "cartadditions", "cartremovals", "checkouts", "carts", "cartviews"
Search Engines Look Up elements= "searchengine" (top 100)
metrics="bounces", "bouncerate", "visitors", "visits", "entries", "uniquevisitors", "totaltimespent", "cartadditions", "cartremovals", "carts", "cartviews", "checkouts", "revenue", "units"
Browser Lookup elements= "browser" (top 25)

System requirements

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.

Report Suite ID

The Suite ID is created when the Report Suite is created. You can contact your administrator to identify the ID value. Note that this is not the Report Suite name.

From Adobe documentation:

Troubleshooting

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. 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. 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". 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. 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