Acquisitions
A base view that retrieves Acquisitions data.
Table Specific Information
Select
Retrieves data for Acquisitions report. At least one metric must be specified in the query. In the query you can also specify up to 9 dimensions.
The following is an example query:
SELECT Conversions, NewUsers FROM Acquisitions
CustomChannelGroups are added as dimension columns. We can query customChannelGroup in the following way:
SELECT SessionCustomChannelGroupName, FirstGroupCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM Acquisitions
NOTE: CustomChannelGroupName is for reference purpose only. The exact value will depend on the channelGroupName added.
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. | ||
| FirstUserGoogleAdsAdGroupName | String | True | The Ad Group Name in Google Ads that first acquired the user. | ||
| FirstUserGoogleAdsAdNetworkType | String | True | The advertising network that first acquired the user. | ||
| FirstUserCampaignName | String | True | Name of the marketing campaign that first acquired the user. | ||
| FirstUserCreativeId | String | True | The campaign creative ID that first acquired the users. | ||
| FirstUserMedium | String | True | True | The medium that first acquired the user to the website or app. | |
| FirstUserSource | String | True | The source that first acquired the user to the website or app. | ||
| SessionCampaignName | String | True | Campaign that referred the user's session. | ||
| SessionDefaultChannelGrouping | String | True | Channel groupings are rule-based definitions of your traffic sources. These default system definitions reflect Analytics' current view of what constitutes each channel. | ||
| SessionMedium | String | True | Channel that referred the user's session. | ||
| SessionSource | String | True | The source that initiated a session on your website or app. | ||
| EventName | String | True | The name of the event. | ||
| 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 | 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. | ||
| UnifiedScreenClass | String | True | The page title (web) or screen class (app) on which the event was logged. | ||
| PagePath | String | True | The portion of the URL between the hostname and query string for web. | ||
| Conversions | Integer | False | True | The count of conversion 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. | |
| EventsPerSession | Decimal | False | True | The average number of events per session. | |
| NewUsers | Integer | False | True | The number of users who interacted with the site or launched the app for the first time. | |
| Sessions | Integer | False | True | The number of sessions that began on the site or app. | |
| TotalRevenue | Integer | False | True | The sum of revenue from purchases, subscriptions, and advertising. | |
| TotalUsers | Integer | False | True | The total number of users. | |
| UserEngagementDuration | Integer | False | False | The total amount of time (in seconds) the website or app was in the foreground of users device. | |
| ScreenPageViews | Integer | False | False | The number of app screens or web pages the users viewed. Repeated views of a single page or screen are counted. | |
| EventCountPerUser | Decimal | False | False | Average number of events triggered by each user. | |
| SessionsPerUser | Decimal | False | False | The average number of sessions per user (Sessions divided by Active 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). | |||
| Dimensions | String | A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions. | |||
| Metrics | String | A comma-separated list of metrics to retrieve in addition to the columns defined in the schema. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |