Demographics
A base view that retrieves Demographics data.
ビュー固有の情報
Select
Demographics レポートのデータを取得します。クエリには少なくとも 1 つの指標を指定する必要があります。また、クエリには最大 9 つのディメンションを指定できます。
次にクエリの例を示します。
SELECT KeyEvents, TotalRevenue FROM Demographics
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| Date | Date | True | The date of the session formatted as YYYYMMDD. | ||
| Year | Integer | True | The year of the session. A four-digit year from 2005 to the current year. | ||
| Month | Integer | True | The month of the session. An integer from 01 to 12. | ||
| Week | Integer | True | The week of the session. A number from 01 to 53. Each week starts on Sunday. | ||
| Day | Integer | True | The day of the month. A number from 01 to 31. | ||
| DayOfWeekName | String | True | The day of the week in English. This dimension has values of Sunday, Monday, etc. | ||
| IsoWeek | Integer | True | ISO week number, where each week starts on Monday. Example values include 01, 02, 53. | ||
| IsoYear | Integer | True | The ISO year of the event.Example values include 2022 2023. | ||
| IsoYearIsoWeek | Integer | True | The combined values of isoWeek and isoYear. Example values include 201652 and 201701. | ||
| YearMonth | Integer | True | The combined values of year and month. Example values include 202212 or 202301. | ||
| YearWeek | Integer | True | The combined values of year and week. Example values include 202253 or 202301. | ||
| Hour | Integer | True | An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time. | ||
| BrandingInterest | String | True | Interests demonstrated by users who are higher in the shopping funnel. Users can be counted in multiple interest categories. | ||
| Country | String | True | True | Country from which user activity originated. | |
| City | String | True | City from which user activity originated. | ||
| Language | String | True | Language setting for the device from which activity originated. | ||
| UserAgeBracket | String | True | User age brackets. | ||
| UserGender | String | True | User gender. | ||
| Region | String | True | Geographic region from which activity originated. | ||
| KeyEvents | Decimal | False | True | The count of key events. | |
| EngagementRate | Decimal | False | True | The percentage of engaged sessions. | |
| EngagedSessions | Integer | False | True | The number of sessions that lasted longer than 10 seconds, or had a conversion event, or had 2 or more screen views. | |
| EngagedSessionsPerUser | Decimal | False | True | Average number of engaged sessions per user. | |
| 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. | |
| TotalRevenue | Decimal | False | True | The sum of revenue from purchases, subscriptions, and advertising. | |
| TotalUsers | Integer | False | True | The total number of users. | |
| StartDate | String | Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). | |||
| EndDate | String | End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo). |
Pseudocolumns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるデータを詳細に制御することができます。
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |
| CurrencyCode | String | A currency code in ISO4217 format, such as AED, USD, JPY. If the field is empty, the report uses the property's default currency. |