The Adobe Analytics integration for MBI uses the Analytics 2.0 Reporting API.
To ensure you obtain the data you expect, you can first build a report in the Adobe Analytics Workspace with your desired metrics and dimensions. This allows you to check for compatibility and availability of data.
One table per connected report suite – called
<ID> is a unique ID generated by MBI – will be created in your Data Warehouse.
The schema of this table is composed of the metrics and dimensions you selected in the integration setup process. Several additional columns are also be generated by MBI, for identification purposes.
For example, if you selected the following metric and dimension during setup:
The table would contain these columns:
||This column is the primary key.|
||MBI unique identifier. This column is created by MBI.|
||This column contains the last time the data row was updated. It is created by MBI.|
||Start date of included data for the row.
||End date of included data for the row.
||Selected metric: The total number of page views for the identified time period.|
||Selected dimension: Individual page names with tracked views.|
Control which of the selected metrics and dimensions have data available in your MBI table by using the sync or unsync options in the
Data Warehouse page. Columns not currently being synced appear in gray. If you stop syncing a column, you can begin syncing it again later.
This section outlines limitations of the Adobe Analytics integration for MBI.
||As with other third-party integrations, the Adobe Analytics integration pulls a limited amount of historical data and then continues to keep data updated. The historical period is configured to 2 weeks.|
||Some combinations of metrics and dimensions contain no data. If such a combination is selected for replication, MBI excludes the column from the replicated table. To avoid selecting such a combination, you can first create a report in the Adobe Analytics Workspace to verify you will get the data you expect.|
||Re-authorization of the Adobe Analytics integration is currently required every two weeks. To re-authorize, go to the Edit page for the integration and click Re-Authorize with Adobe Analytics.|
||Adobe Analytics provides metric data for one dimension at a time. If you select multiple dimensions during setup, each row in your MBI table will contain a single dimension value and nulls for each other dimension.|