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 SiteReportWhat time of the day is the website the busiest?
SELECT HourOfDay, PageViews, Visits FROM SiteReportWhich search engines do our users most commonly use to find us?
SELECT SearchEngine, Visits, UniqueVisitors FROM SiteReportWho is referring users to visit us?
SELECT Referrer, Visits, UniqueVisitors FROM SiteReportDo people come to stay or do they usually bounce?
SELECT Date, Bounces, BounceRate FROM SiteReportWhat 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. |