ODBC Driver for Adobe Analytics

Build 25.0.9434

Pages

Identify pages on your site ranked by popularity, based on views and interactions during a selected reporting period (defaults to 30 days).

This predefined report view is based on the corresponding Adobe Analytics template. By default, the report covers the last 30 days. To customize the date range, specify StartDate and EndDate in the WHERE clause. If only StartDate is provided, EndDate defaults to today. If only EndDate is provided, StartDate defaults to two years before the specified EndDate.

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

SELECT * FROM [Pages] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'

Columns

Name Type IsDimension IsMetric DefaultDimension DefaultMetric Description
Page String True True The names of pages on your site.
PageViews Int True True Shows the number of times a given dimension item was set or persisted on a page. It is one of the most common and basic metrics in reports.
StartDate String Specifies the beginning of the reporting period.
EndDate String Specifies the end of the reporting period.
SegmentId String Specifies the ID of a predefined or custom segment to filter the report data.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434