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
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]