LastTouchChannelDetail
View detailed attributes of the last-touch marketing channel, such as referring domain, tracking code, or campaign ID.
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 [LastTouchChannelDetail] WHERE [StartDate] = '2025-01-01' AND [EndDate] = '2025-01-31' AND [SegmentId] = 's300012345_1234567890'
Columns
| Name | Type | IsDimension | IsMetric | DefaultDimension | DefaultMetric | Description |
| LastTouchChannelDetail | String | True | True | Specific subcategory or granular value of the last marketing channel attributed to a visitor before a conversion or significant interaction. | ||
| UniqueVisitors | Int | True | True | The number of distinct users who accessed the site during the defined reporting period, based on visitor identification mechanisms. | ||
| StartDate | String | The starting date of the reporting window used to filter data. | ||||
| EndDate | String | The ending date of the reporting window used to filter data. | ||||
| SegmentId | String | The unique identifier of a segment used to restrict the dataset to a specific audience or behavior group. |