Transaction table

The following describes each of the columns in the Transaction Business View table.

The Transaction Business View table columns

Column Name Type Description
 customer_hub_id  TEXT  Unique Hub customer ID.
 order_hub_id  TEXT  Unique Hub order ID/event ID.
 order_id  TEXT  Customer order ID.
 order_date  TIMESTAMP  Order date.
 order_payment_method  TEXT  Payment method.
 order_shipping_method  TEXT  Shipping method.
 order_total  DOUBLE  Total order value.
 order_revenue  DOUBLE  Order revenue.
 order_shipping  DOUBLE  Shipping cost.
 order_tax  DOUBLE  Tax cost.
 order_discount  DOUBLE  Discount value.
 order_currency  TEXT  Currency type.
 order_exchange_rate  DOUBLE  Order exchange rate.
 generated_line_id  INT  Order line IDs, generated by Hub.
 order_line_id  TEXT  Line item ID.
 order_line_type  TEXT  Line type: Sale or return.
 order_line_quantity  BIGINT  Number of items.  
 order_line_subtotal  DOUBLE  Order line item value.
 order_line_discount  DOUBLE  Order line item discount.
 order_line_tax  DOUBLE  Tax cost for the line item.
 order_line_coupon  TEXT  Coupon value for the line item.
 product_id  TEXT  Product ID.
 product_sku  TEXT  SKU number.
 product_name  TEXT  Product name.
 product_price  DOUBLE  Product price.
 unique_line_id  TEXT  Unique Hub order line ID/event ID.
 kpi_clv_ref_id  BIGINT  Identifies when the CLV algorithm ran.
 kpi_clv_predicted_cluster  TEXT  Predicted customer CLV cluster value at the time of the event.
 kpi_clv_churn_prob  DOUBLE  Customer churn probability value at the time of the event.
 kpi_clv_current_cluster  TEXT  Customer CLV cluster value at the time of the event.
 kpi_clv_predicted_expense  DOUBLE  Predicted customer expenditure value at the time of the event.
 kpi_engagement_fixed_ref_id  BIGINT  Identifies when the fixed email engagement algorithm ran.
 kpi_engagement_fixed_cluster  TEXT  Customer fixed email engagement cluster value at the time of the event.
 kpi_engagement_moving_average_ref_id  BIGINT  Identifies when the moving average email engagement algorithm ran.
 kpi_engagement_moving_average_cluster  TEXT  Customer moving average email engagement cluster value at the time of the event.

 

 

Previous page: Digital table| Next page:  Analytics Getting Started Guide