DocumentationCommerceCommerce Intelligence User Guide

Expected Adobe Analytics Data

Last update: Tue Jul 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

The Adobe Analytics integration for Adobe Commerce Intelligence uses the Analytics 2.0 Reporting API.

INFO
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 report-suite-<ID> (where <ID> is a unique ID generated by Commerce Intelligence) is created in your Data Warehouse.

The schema of this table is composed of the metrics and dimensions that you selected in the integration setup process. Several additional columns are also generated by Commerce Intelligence, for identification purposes.

For example, if you selected the following metric and dimension during setup:

  • Metric: Page views
  • Dimension: Page

The table would contain these columns:

Column Name
Description
_id
This column is the primary key.
_item_hash
Commerce Intelligence unique identifier. This column is created by Commerce Intelligence.
_updated_at
This column contains the last time that the data row was updated. It is created by Commerce Intelligence.
start_date
Start date of included data for the row. start_date is always 00:00 of the same day within one row.
end_date
End date of included data for the row. end_date is always 23:59 of the same day within one row.
page_views
Selected metric: The total number of page views for the identified time period.
page
Selected dimension: Individual page names with tracked views.

Control which of the selected metrics and dimensions have data available in your Commerce Intelligence 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.

Current Limitations

This section outlines limitations of the Adobe Analytics integration for Commerce Intelligence.

Limitation
Description
Historical data period
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.
Empty component combinations
Some combinations of metrics and dimensions contain no data. If such a combination is selected for replication, Commerce Intelligence 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 get the data you expect.
Re-authorization cadence
Reauthorization of the Adobe Analytics integration is required every two weeks. To reauthorize, go to the Edit page for the integration and click Re-Authorize with Adobe Analytics.
One dimension per row
Adobe Analytics provides metric data for one dimension at a time. If you select multiple dimensions during setup, each row in your Commerce Intelligence table contains a single dimension value and nulls for each other dimension.
recommendation-more-help
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc