Run a unified report that includes all configured dimensions and metrics for a broad view of user behavior and performance.

View Specific Information

Select

This view includes every available dimension and metric. To create a valid custom Adobe Analytics report, ensure your SELECT query includes at least one metric column along with any desired subset of dimension columns from the list.

To define the reporting period, specify the StartDate and EndDate in your WHERE clause. If no dates are specified, the report defaults to a period starting from two years ago up to today. If only a StartDate is provided, the EndDate defaults to today, and if only an EndDate is provided, the StartDate defaults to two years ago from the specified EndDate.

You can also filter the report to a specific segment by including the SegmentId column in the WHERE clause. For instance, an example query might be:

SELECT [Time Spent on Page - Bucketed], [Browser], [Browser Height - Bucketed], [Browser Type], [Average Page Depth], [Average Time Spent on Site (seconds)], [Bot Occurrences], [Bot Page Views], [Bounce Rate] FROM [UniversalReport] 
WHERE [StartDate] = '2023-01-01' AND [EndDate] = '2023-01-31' AND [SegmentId] = 's300012345_1234567890'

This approach enables you to generate a tailored report by choosing the specific columns and applying the necessary date range and segment filters directly in your query.

Default Dimension

Date is the default dimension for this report as well, so the query:

    SELECT * FROM [UniversalReport]

will become:

    SELECT Date, {all the metrics here} FROM [UniversalReport]

Default Metric

Occurrences is the default metric for this report if no valid metric is specified in the query, so the query:

    SELECT Date FROM [UniversalReport]

will become:

    SELECT Date, Occurrences FROM [UniversalReport]

Columns