View: Order Channel

This article will help you learn about the fields available in the Order Channel view, the field types, descriptions and how the fields are calculated

Key Topics

List as bullet points the key topics outlined in this article

View Definition

This view is linked to the [drp.order_channel] 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
Channel Source Dimension Source of the Attribution Channel channel_source
Daasity Attribution Channel Dimension The channel from the best ranking source (Default is Influencer, Discount Code, GA) attribution_channel
Daasity Attribution:  Vendor Dimension The vendor from the best ranking source (Default is Influencer, Discount Code, GA) attribution_vendor
Daasity Attribution: Enquire Channel Dimension Order Channel According to Enquire Survey Response CASE WHEN channel_source = 'Enquire Labs' THEN attribution_channel ELSE NULL END
First Click: Modified First Click Channel Dimension First click channel from multichannel funnel and channel mapping ga_fc_channel
First Click: Modified First Click Vendor Dimension First click vendor from multichannel funnel and channel mapping ga_fc_vendor
Google Analytics: Device Type Dimension Desktop, tablet or mobile device_category
Google Analytics: GA Last Click Channel Dimension Channel coming directly from GA ga_default_lc_channel
Google Analytics: User Type Dimension User Type (New or Returning) from Google Analytics user_type
Google Analytics: UTM Campaign Dimension UTM Campaign from GA utm_campaign
Google Analytics: UTM Medium Dimension UTM Medium from GA utm_medium
Google Analytics: UTM Source Dimension UTM Source from GA utm_source
Last Click: Modified Last Click Channel Dimension Channel derived from logic in the channel mapping BSD ga_lc_channel
Last Click: Modified Last Click Vendor Dimension Vendor derived from logic in the channel mapping BSD ga_lc_vendor

Explores

This view is part of the following explores:

  • Order & Order Line Revenue
  • Transactional Sales Report

Transformation Code

This view is a Daasity derived table generated by the following code:

  • [3280_BAS_OST_order_business_unit.sql]

Related Resources