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.
Data Warehouse reports the first value encountered in the reporting period.
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.
|Request Name||Identifies the request.|
The date and granularity of the request.
Data Warehouse reporting on virtual report suites supports the alternative time zone configured on the virtual report suite.
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](/help/components/c-segmentation/seg-home.md)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.
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...|
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.