Data Warehouse overview

Data Warehouse refers to the copy of Analytics data for storage and custom reports, which you can run by filtering the data. You can request reports to display advanced data relationships from raw data based on your unique questions. Data warehouse reports are emailed or sent via FTP, and may take up to 72 hours to process. Processing time depends on the complexity of the query and the amount of data requested.

Adobe enables Data Warehouse for administrator-level users only, for specific report suites. (It can be enabled for global and child report suites, but not for rollup report suites.) The administrator can create a group that has access to Data Warehouse, and then associate non-administrator level users to that group.

Data Warehouse automatically zips any file that exceeds 1 MB in size. The maximum email attachment size is 10 MB.

Data Warehouse can process an unlimited number of rows in a single request for individual scheduled and downloaded reports.

NOTE

Data Warehouse reports the first value encountered in the reporting period.

IMPORTANT

When segmenting on classified values, Analysis Workspace and Data Warehouse treat ‘unspecified’ values differently. ‘Unspecified’ in Workspace refers to values that are not classified, whereas ‘Unspecified’ in Data Warehouse refers to values that you classified as “Unspecified”.

Data Warehouse Requests Descriptions

This table describes the fields and options on the Data Warehouse Request tab.

Element Description
Request Name Identifies the request.
Reporting Date

The date and granularity of the request.

  • Custom: A date range you configure in the calendar.
  • Preset: A preset range. The preset range is relative to the report date.
  • Granularity: The time granularity. Valid values are None, Hour, Day, Week, Month, Quarter, and Year.

Data Warehouse reporting on virtual report suites supports the alternative time zone configured on the virtual report suite.

Available Segments

Lets you select the part of the visitor population you want to examine and generate complex segments. You can load pre-configured segments, create new segments, and store segment components in a library to use in building additional segments.

You can now stack segments. When selecting multiple segments, the preview area, the Request Manager, and the Request Detail popup show a comma-separated list of names (e.g., Segment1, Segment2).

See the Segmentation Guide for more information.

Note: You cannot include both a segment filter and a breakdown on the same segment, in the same Data Warehouse report. Doing so will result in an error.

Breakdowns

Lets you categorize data using breakdowns. Segments and breakdowns differ in that a segment filters data out of a data set, while a breakdown compartmentalizes data across all valid values for the breakdown.

You can also break down a report by one or more segments. However, you cannot include both a segment filter and a breakdown on the same segment, in the same Data Warehouse report. Doing so will result in an error.

For example, use segments to remove a gender from the data set, and use a breakdown to see data separated by gender.

When a Data Warehouse request is submitted with multiple multi-value dimensions (e.g., various Mobile Reports), an exponential number of rows can be generated from a single hit. The number of rows that can be output from a single hit is capped at 100 (previously 1,000).

Metrics Lets you add metrics that you want to report on.
Metrics Sort Provides ranked breakdown reports, sorted by descending metric value, similar to what is displayed in the Reports & Analytics user interface, Data Workbench, etc. More...
Schedule Delivery

Lets you schedule requests for automatic delivery at selected intervals, or as a one-time report. If you use the default format, the report arrives in an email as a .csv file.

To add the date range, include %R in the filename. This value represents the date values requested in the report. For example, if you request data from May 1, 2013 through May 7, 2013, the %R shows a filename including the date range of 20130501 - 20130507.

Business.Adobe.com resources

Docs links
Flow Analysis Customer Journey Analytics Advertising Analytics Real Time Data Cohort Analysis Web Analytics

On this page