Acquisitions
A base view that retrieves Acquisitions data.
View-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 KeyEvents, NewUsers FROM Acquisitions
CustomChannelGroups are added as dimension columns. You can query CustomChannelGroup in the following way:
SELECT SessionCustomChannelGroupName, FirstGroupCustomChannelGroupName, SessionDefaultChannelGrouping, KeyEvents FROM Acquisitions
NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends 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. For details, see 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. | ||
| FirstUserGoogleAdsCreativeId | 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. | ||
| SessionDefaultChannelGroup | 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. | ||
| 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. | |
| 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 | Decimal | False | True | The sum of revenue from purchases, subscriptions, and advertising. | |
| TotalUsers | Integer | False | True | The total number of users. | |
| UserEngagementDuration | Bigint | 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). |
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. |
| 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. |