TDV Adapter for Adobe Analytics

Build 21.0.8137

SiteReport

Generate data reports regarding your website traffic.

View Specific Information

Refer to the explanation in the "Data Model" section to learn how to build optimal queries. The following are some use cases for this report:
Where is most of the traffic coming from? (country / city)

SELECT Country, City, PageViews, Visits FROM SiteReport
What time of the day is the website the busiest?
SELECT HourOfDay, PageViews, Visits FROM SiteReport
Which search engines do our users most commonly use to find us?
SELECT SearchEngine, Visits, UniqueVisitors FROM SiteReport
Who is referring users to visit us?
SELECT Referrer, Visits, UniqueVisitors FROM SiteReport
Do people come to stay or do they usually bounce?
SELECT Date, Bounces, BounceRate FROM SiteReport
What is the most viewed page?
SELECT Page, PageViews, Visits, UniqueVisitors FROM SiteReport

Columns

Name Type IsDimension IsMetric DefaultDimension Description
Date Date True True The datetime of the first log entry of a session.
HourOfDay String True The hour of day of the first log entry of a session.
Country String True Groups web traffic by the country where the client was in.
City String True Groups web traffic by the city where the client was in.
SearchEngine String True The second level domain name of the first web site (which is a search engine) that referred a visitor to the site during a session (as supplied by the visitor's browser).
Browser String True The type of user agent used by the visitor, including the version number (for example, MSIE 6.0).
OperatingSystems String True Groups web traffic by the operating system used by the client. Mobile and desktop operating systems appear on this report.
Page String True The name of each page visited during a session. Initially, each page's name is the same as the URI, but can be changed for easier interpretation.
Referrer String True The second level domain name of the web site that first referred a session to the site (as supplied by the visitor's browser).
PageViews Integer True The number of page views. A page view is a request for a defined page (access to images and other types of filtered content are not counted).
Visits Integer True The number of visits.
UniqueVisitors Integer True The number of unique visitors.
Bounces Integer True The number of bounces. A bounce is a visit that consists of a single server call.
BounceRate Integer True The percentage of visits that contain a single hit.
SinglePageVisits Integer True The number of single page visit.
TimeSpentPerVisit Integer True The average amount of time visitors interact with a specific dimension item during each visit.
TimeSpentPerVisitor Integer True The average amount of time visitors interact with a specific dimension item across the visitor's lifetime (length of their cookie).
TotalSecondsSpent Integer True Represents the total amount of time visitors interact with a specific dimension item.
Revenue Decimal True The total dollar amount for the sum of the order for each product.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartDate Datetime Use this to filter reports by the start date of the report.
EndDate Datetime Use this to filter reports by the end date of the report.
SegmentId String Use this to filter reports by a particular segment.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137