ScreenPageViews
A base view that retrieves ScreenPage data
View-Specific Information
Select
Retrieves data for ScreenPageViews reports. At least one metric must be specified in the query. This endpoint uses the real-time report API endpoint to get more up-to-date data than the standard reporting endpoint. The real-time reporting API supports a maximum of four dimensions compared to nine for the standard report API.
The following is an example query:
SELECT ScreenPageViews, EventName FROM ScreenPageViews;
Since PagePath and PlatTitle dimensions are not available in the runRealReport endpoint, use the connection property ReportType = reports to leverage the result with these dimensions.
Note: The Google Analytics Realtime API (runRealtimeReport) does not support pagination. All available data is returned in a single request, up to the API maximum of 250,000 rows. If a LIMIT clause is specified, the driver will request only that many rows. If the total data exceeds the request limit, only the first batch of rows will be returned. To enable full pagination support, set the connection property ReportType=Reports, which switches to the standard runReport endpoint.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| AppVersion | String | True | The application's versionName (Android) or short bundle version (iOS) | ||
| City | String | True | The city from which the user activity originated | ||
| Country | String | True | The country from which the user activity originated | ||
| DeviceCategory | String | True | The type of device: Desktop, Tablet, or Mobile | ||
| Platform | String | True | The platform on which your app or website ran | ||
| AudienceName | String | True | The given name of an Audience | ||
| UnifiedScreenName | String | True | The page title (web) or screen name (app) on which the event was logged | ||
| EventName | String | True | True | The name of the event | |
| PagePath | String | True | The portion of the URL between the hostname and query string for web. This works when connection property ReportType=reports;. | ||
| PageTitle | String | True | The web page titles used on your site. This works when connection property ReportType=reports; | ||
| AudienceId | Long | True | The numeric identifier of an Audience. | ||
| AudienceResourceName | String | True | The resource name of this audience. | ||
| CityId | Integer | True | The geographic ID of the city from which the user activity originated, derived from their IP address. | ||
| CountryId | String | True | The geographic ID of the country from which the user activity originated, derived from their IP address. | ||
| MinutesAgo | Integer | True | The number of minutes ago that an event was collected. 00 is the current minute, and 01 means the previous minute. | ||
| StreamId | Long | True | The numeric data stream identifier for your app or website. | ||
| StreamName | String | True | The data stream name for your app or website. | ||
| ScreenPageViews | String | False | True | The number of app screens or web pages your users viewed. Repeated views of a single page or screen are counted. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table |