Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →
New Adobe Analytics Views
Adobe Analytics is a top choice for real-time analytics in marketing data. By using Adobe Analytics, organizations can gain insight into their complete customer journey and help their team deliver effective and personalized content. When combined with the CData Drivers & Connectors, users can easily get the data they need to gather detailed insights.
As of Version: 24.0.9190 of the CData Adobe Analytics Drivers, the following new report views have been added to the data model:
- UniversalReport: A universal report that includes every available dimension and metric.
- Predefined Report Views: A variety of common reports with predefined dimensions and metrics.
This feature for the CData Adobe Analytics Drivers was added in the July 2025 driver release and allows Adobe Analytics users to dynamically query prebuilt reports of their Adobe Analytics data. In this article, we review the different types of report views available through the CData Adobe Analytics Drivers and explore examples for querying the newly exposed report views.
Why go beyond Adobe Analytics' UI?
While Adobe Analytics is powerful for quick insights and dashboard building, it can become limited when combining Adobe Analytics data with other systems or when trying to create more advanced analytics. When using the CData Drivers & Connectors for Adobe Analytics, you can unlock a deeper and more flexible approach to your reporting. Here are some ways how:
- Unified Data Analysis: Consolidate data from sources like ERP platforms, CRMs, and advertising platforms for a comprehensive view of key metrics.
- Laser-Targeted Decision Making: Access unified data to gain insights and make targeted decisions to improve campaigns.
- Custom Dashboards and Reports: Use BI tools like Tableau or Power BI to create interactive dashboards for better data visualization.
- Scalable Data Management: Store Adobe Analytics data in relational databases or data warehouses for in-depth analyses and accurate forecasting.
With the help of no-code tools like the CData Driver for Adobe Analytics and CData Sync, you can connect to live Adobe Analytics data, ingest the data into a database or data warehouse, or analyze the data directly in the BI tool of your choice.
Types of report views
The CData Adobe Analytics Driver and Connectors expose four types of report views listed below that each provide different ways to access report data:
UniversalReport view
The new UniversalReport view consolidates all available dimensions and metrics into a single view. This allows users to dynamically construct queries that select a specific combination of dimensions and metrics without being locked into a predefined report format. This report view is ideal for building reports from scratch according to your specific needs for analysis.
Predefined report views
The predefined report views come with a prebuilt combination of dimensions and metrics that are commonly used for specific reporting purposes. These views provided a simple way to query popular report views as-is.
These include the following reports: KeyMetrics, LastTouchChannel, LastTouchChannelDetail, Orders, PageOccurrences, Pages, PageViews, Products, Revenue, SiteSections, TrackingCode, Units, Visitors, and Visits.
Custom reports
Whenever you build and save a prebuilt report in your Adobe Analytics instance, the CData Adobe Analytics Driver dynamically retrieves its metadata and exposes it as a new view in the table listing. This allows you to query your saved Adobe reports directly using standard SQL, just like another table or view in the data model.
This feature allows teams to take full advantage of Adobe's user-friendly visual report builder while ensuring consistency across your UI and SQL-based reporting.
CreateReport stored procedure
The CreateReport stored procedure provides an easy way to generate new view definitions with a custom combination of Dimensions and Metrics. Calling the stored procedure will create a new schema file that you can query like any other view.
The stored procedure takes a view name, a comma-separated list of metric names, a comma-separated list of metric IDs, a comma-separated list of dimension names, a comma-separated list of dimension IDs, and an output folder as inputs. Below is an example of calling the CreateReport stored procedure:
EXEC CreateReport Dimensions = 'Country, City', Metrics = 'PageViews, Visits', TableName = 'MyCustomReport'
Read more about these reports in the CData Adobe Analytics Documentation page.
Example implementation
Using the UniversalReport
When querying the UniversalReport view, Date is the default dimension for this report, and Occurrences is the default metric for this report if no valid metric or dimension is specified. So, the query below:
SELECT * FROM [UniversalReport]
will be translated to:
SELECT Date, Occurrences FROM [UniversalReport]
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'
Using the predefined reports
By default, the new predefined reports cover the last 30 days when queried. To customize the date range, you can 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.
Additionally, you can filter the report by segment using the SegmentId column in the WHERE clause. For instance, an example query might be:
SELECT * FROM [KeyMetrics] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Conclusion
Adobe Analytics is a powerful tool for analyzing marketing data, and when combined with CData Drivers and Connectors, you can seamlessly integrate Adobe Analytics data into your workflows for deeper analysis and better data-driven decision making.
Get started with a free trial of any of our CData Adobe Analytics Drivers and Connectors today to unlock the full potential of your Adobe Analytics data!
