AcquisitionsSessionSourceMediumReport
A predefined view that retrieves Acquisitions session source medium report data.
Select
The provider uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- PropertyId supports the following operator: =
- FirstUserGoogleAdsAdGroupName supports the following operator: =
- Date supports the following operators: =, >=, <=, <, >
For example, the following queries are processed server-side:
SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE PropertyId = 342020667 SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE FirstUserGoogleAdsAdGroupName = 'Test' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date = '01/05/2023' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE PropertyId = 342020667 AND FirstUserGoogleAdsAdGroupName = 'Test' AND Date = '01/05/2023' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date >= '01/01/2022' AND <= '01/05/2023' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date >= '01/01/2022' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date <= '01/01/2022' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date > '01/01/2022' SELECT * FROM AcquisitionsSessionSourceMediumReport WHERE Date < '01/01/2022'
CustomChannelGroups are added as dimension columns. You can query customChannelGroup in the following way:
SELECT SessionCustomChannelGroupName, SessionDefaultChannelGrouping, Conversions FROM AcquisitionsSessionSourceMediumReport
NOTE: CustomChannelGroupName is for reference purposes only. The exact value depends on the channelGroupName added. The rest of the filter is executed client-side in the provider.
Columns
| Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
| SessionMedium | String | True | True | Channel that referred the user | |
| SessionSource | String | True | True | The source that initiated a session on your website or app. | |
| Date | Date | True | True | The date of the session formatted as YYYYMMDD. | |
| Sessions | Integer | False | True | The number of sessions that began on the site or app. | |
| EventsPerSession | Decimal | False | True | The average number of events per session. | |
| Conversions | Decimal | 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. | |
| EventCount | Integer | False | True | The count of events. | |
| TotalRevenue | Integer | 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 |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| PropertyId | String | Property ID value to be used when querying this table. |