EngagementContentGroupReport
Retrieves Engagement Content Group Report data.
Select
The 本製品 uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- ContentGroup supports the following operator: =
- Date supports the following operators: =,>=,<=,<,>
For example, the following queries are processed server-side:
SELECT * FROM EngagementContentGroupReport WHERE PropertyId = 342020667 SELECT * FROM EngagementContentGroupReport WHERE ContentGroup = 'CData Test' SELECT * FROM EngagementContentGroupReport WHERE Date = '01/05/2023' SELECT * FROM EngagementContentGroupReport WHERE PropertyId = 342020667 AND ContentGroup = 'CData Test' and Date = '01/05/2023' SELECT * FROM EngagementContentGroupReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM EngagementContentGroupReport WHERE Date >= '01/01/2022' SELECT * FROM EngagementContentGroupReport WHERE Date <= '01/01/2022' SELECT * FROM EngagementContentGroupReport WHERE Date > '01/01/2022' SELECT * FROM EngagementContentGroupReport WHERE Date < '01/01/2022'The rest of the filter is executed client-side in the 本製品.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
ContentGroup | String | True | True | A category that applies to items of published content. | |
Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
Conversions | Integer | False | True | The count of conversion events. | |
EventCount | Integer | False | True | The count of events. | |
NewUsers | Integer | False | True | The number of users who interacted with the site or launched the app for the first time. | |
ScreenPageViews | Integer | False | True | The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted. | |
TotalRevenue | Integer | False | True | The sum of revenue from purchases, subscriptions, and advertising. | |
TotalUsers | Integer | False | True | The number of distinct users who visited the site or app. | |
UserEngagementDuration | Integer | False | True | The total amount of time (in seconds) the website or app was in the foreground of users device. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PropertyId | String | Property ID value to be used when querying this table. |