AcquisitionsFirstUserSourceMediumReport
A predefined view that retrieves Acquisitions first user source medium data.
Select
本製品 は Google Analytics API を使用して、以下のカラムと演算子で構築された WHERE 句条件を処理します：
- PropertyId は次の演算子をサポートします：=
- FirstUserGoogleAdsAdGroupName は次の演算子をサポートします：=
- Date は次の演算子をサポートします：=、>=、<=、<、>
- CurrencyCode は次の演算子をサポートします：=
例えば、次のクエリはサーバーサイドで処理されます。
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE PropertyId = 342020667
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE FirstUserGoogleAdsAdGroupName = 'Test'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date = '01/05/2023''
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE PropertyId = 342020667 AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date >= '01/01/2022' AND Date <= '01/05/2023'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date >= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date <= '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date > '01/01/2022'
SELECT * FROM AcquisitionsFirstUserSourceMediumReport WHERE Date < '01/01/2022'
CustomChannelGroups はディメンションカラムとして追加されます。CustomChannelGroup は次のようにクエリできます：
SELECT FirstUserCustomChannelGroupName, SessionDefaultChannelGrouping, KeyEvents FROM AcquisitionsFirstUserSourceMediumReport
Note： CustomChannelGroupName は参照用のみです。正確な値は追加された ChannelGroupName によって異なります。 その他のフィルタはクライアントサイドで 本製品 内部で処理されます。
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| FirstUserSource | String | True | True | The source that first acquired the user to the website or app. | |
| FirstUserMedium | String | True | True | The medium that first acquired the user to the website or app. | |
| Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
| NewUsers | Integer | False | True | The number of users who interacted with the site or launched the app for the first time. | |
| 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. | |
| EventCount | Integer | False | True | The count of events. | |
| 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 | True | The total amount of time (in seconds) the website or app was in the foreground of users |
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. |