LastTouchChannel
Identify the last marketing channel attributed to each visitor during their session, based on Adobe's last-touch attribution model.
This predefined report view is based on the corresponding Adobe Analytics template. By default, the report covers the last 30 days. To customize the date range, specify StartDate and EndDate in the WHERE clause. If only StartDate is provided, EndDate defaults to today. If only EndDate is provided, StartDate defaults to two years before the specified EndDate.
You can also filter the report by segment using the SegmentId column in the WHERE clause. For instance, an example query might be:
SELECT * FROM [LastTouchChannel] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | DefaultMetric | Description |
| LastTouchChannel | String | True | True | The most recent marketing channel attributed to a visitor before a conversion or key interaction, based on Adobe Analytics attribution rules. | ||
| UniqueVisitors | Int | True | True | The count of distinct users who visited the site during the selected date range, based on browser cookies or visitor IDs. | ||
| StartDate | String | The start date for the reporting period used to filter and return relevant data. | ||||
| EndDate | String | The end date for the reporting period used to filter and return relevant data. | ||||
| SegmentId | String | The ID of a user-defined or system-defined segment used to limit the report data to specific audience criteria. |