Data Model
The CData SSIS Components for Adobe Analytics models Adobe Analytics objects as an easy-to-use SQL database, using views and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data.
Views
The Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Adobe Analytics account.
The following views are included with the application:
| View | Description |
| CalculatedMetrics | Retrieve a list of all calculated metrics defined within your Adobe Analytics environment, including custom formulas built on top of standard metrics. |
| CollectionSuites | Return the list of data collection suites configured in Adobe Analytics, which represent logical groupings of tracking data within a report suite. |
| Dimensions | List all available dimensions that can be used to segment and break down Adobe Analytics data, such as page name, device type, or campaign. |
| KeyMetrics | Display high-level engagement metrics like page views and visits for a specified time range (defaults to the past 30 days). |
| LastTouchChannel | Identify the last marketing channel attributed to each visitor during their session, based on Adobe's last-touch attribution model. |
| LastTouchChannelDetail | View detailed attributes of the last-touch marketing channel, such as referring domain, tracking code, or campaign ID. |
| Metrics | Retrieve all available standard and custom metrics that measure user behavior and site performance in Adobe Analytics. |
| Orders | Summarize the total number of purchase events recorded across all tracked orders within a specified time period (defaults to 30 days). |
| PageOccurrences | Display the number of times a page was involved in a tracked interaction or persisted as a dimension value within the selected reporting window. |
| Pages | Identify pages on your site ranked by popularity, based on views and interactions during a selected reporting period (defaults to 30 days). |
| PageViews | Show the total number of page views recorded, helping you understand overall traffic volume over a specified date range. |
| Products | Return order counts grouped by product name or SKU, allowing analysis of top-performing items sold within the last 30 days. |
| Revenue | Aggregate the total revenue generated from all completed orders within the reporting period (defaults to 30 days). |
| Segments | Retrieve the list of predefined and custom segments available in your Adobe Analytics account, including shared and curated segments. |
| SiteSections | Identify the most trafficked or highest-converting sections of your site, based on page grouping and content hierarchy. |
| TrackingCode | View which marketing or campaign tracking codes drove the most traffic to your site over a given period. |
| Units | Show the total number of individual product units purchased across all orders in the selected reporting window. |
| UniversalReport | Run a unified report that includes all configured dimensions and metrics for a broad view of user behavior and performance. |
| Users | List the users who have access to Adobe Analytics, including login details, roles, and account status. |
| Visitors | Display the total number of unique individuals who accessed your site during the reporting period (defaults to the past 30 days). |
| Visits | Show the number of individual sessions recorded during the specified date range, regardless of visitor identity. |
Stored Procedures
Stored Procedures are SQL scripts that extend beyond standard CRUD operations. They can be used to access additional capabilities of the Adobe Analytics API.