View: Multi-Channel Transactions

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]

Related Resources