This article will help you learn about the fields available in the Multi-Channel Transactions view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
View Definition
This view is linked to the [drp.multi_channel_transactions] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
Field Name | Field Type | Description | Source / Calculation |
First Click Date | Dimension Group | Date of First Click | first_click_date |
Last Click Date | Dimension Group | Date of Last Click | last_click_date |
Transaction Date | Dimension Group | Date GA captured the Transaction (Order) | transaction_date |
First Click Default GA Channel | Dimension | Channel visitor first clicked through to purchase | first_click_channel_grouping |
First Click GA UTM Campaign | Dimension | Campaign Path Node visitor first clicked through to purchase | campaign_path_first_node |
First Click Modified Channel | Dimension | Channel visitor first clicked through to purchase | channel_first_click |
First Click Vendor | Dimension | Vendor visitor first clicked through to purchase | vendor_first_click |
Google Analytics: Country | Dimension | Country visitor's clicks originated from | country |
Google Analytics: Days Between First and Last Click | Dimension | Days between First Click and Last Click date to purchase | days_between |
Google Analytics: Device Category | Dimension | Device Category, i.e. Mobile, Tablet, Desktop | device_category |
Google Analytics: Number of Touches | Dimension | Number of touches grouped. i.e. A filter on this dimension can be used to return all '1,2,3...' touch orders | number_touches |
Google Analytics: Transaction ID | Dimension | Order Code passed to Google Analytics | transaction_id |
Google Analytics: User Type | Dimension | New or Returning visitor | user_type |
Last Click Default GA Channel | Dimension | Channel visitor last clicked through to purchase | last_click_channel_grouping |
Last Click GA UTM Campaign | Dimension | Campaign Path Node visitor last clicked through to purchase | campaign_path_last_node |
Last Click Modified Channel | Dimension | Channel visitor last clicked through to purchase | channel_last_click |
Last Click Vendor | Dimension | Vendor visitor last clicked through to purchase | vendor_last_click |
Average Days Between First and Last Click | Measure | Average Days between First Click and Last Click date to purchase | AVERAGE(days_between) |
Average Number of Clicks | Measure | Average Number of Clicks to Purchase | AVERAGE(number_touches) |
Average Order Value | Measure | Average Revenue from Google Analytics | AVERAGE(transaction_revenue) |
Total Number of Clicks | Measure | Total Number of Clicks | SUM(number_touches) |
Total Number of Days Between First and Last Click | Measure | Total Days between First Click and Last Click date to purchase | SUM(days_between) |
Total Orders | Measure | Number of orders | COUNT(DISTINCT(transaction_id)) |
Total Transaction Revenue | Measure | Total Revenue from the transaction | SUM(transaction_revenue) |
Explores
This view is part of the following explores:
- Multi-Channel Transactions
Transformation Code
This view is a Daasity derived table generated by the following code:
- [3410_MKT_BAS_multi_channel_transactions.sql]