Payment Transactions

view: payment_transactions {
  sql_table_name: payment_transactions ;;

  dimension: braintree_authorization {
  }

  dimension: braintree_merchant_id {
  }

  dimension: corp_balance_after_in_cents {
    type: int
  }

  dimension: corp_balance_before_in_cents {
    type: int
  }

  dimension: corp_balance_in_cents {
    type: int
  }

  dimension: corp_balance_type {
  }

  dimension: corp_braintree_authorization {
  }

  dimension: corp_external_in_cents {
    type: int
  }

  dimension: corp_external_type {
  }

  dimension: corp_state {
  }

  dimension: corp_total_in_cents {
    type: int
  }

  dimension: country_code {
  }

  dimension: creator_type {
  }

  dimension: currency_code {
  }

  dimension: discount_in_cents {
    type: int
  }

  dimension: total_discount_in_cents {
    type: sum
    sql: ${discount_in_cents} ;;
  }

  dimension: discount_name {
  }

  dimension: from_balance_after_in_cents {
    type: int
  }

  dimension: from_balance_before_in_cents {
    type: int
  }

  dimension: from_balance_in_cents {
    type: int
  }

  dimension: from_balance_type {
  }

  dimension: from_external_in_cents {
    type: int
  }

  dimension: from_external_type {
  }

  dimension: from_id {
    type: int
  }

  dimension: from_state {
  }

  dimension: from_total_in_cents {
    type: int
  }

  dimension: geography_id {
    type: int
  }

  dimension: id {
    type: int
  }

  dimension: local_id {
  }

  dimension: local_type {
  }

  dimension: marketplace {
  }

  dimension: owner_fee_in_cents {
    type: int
  }

  dimension: payment_merchant_id {
    type: int
  }

  dimension: payment_method_id {
    type: int
  }

  dimension: promotion_in_cents {
    type: int
  }

  dimension: total_promotion_in_cents {
    type: sum
    sql: ${promotion_in_cents} ;;
  }

  dimension: promotion_name {
  }

  dimension: refunded_id {
    type: int
  }

  dimension: reimbursement_in_cents {
    type: int
  }

  dimension: total_reimbursement_in_cents {
    type: sum
    sql: ${reimbursement_in_cents} ;;
  }

  dimension: service_fee_in_cents {
    type: int
  }

  dimension: tip_in_cents {
    type: int
  }

  dimension: total_tip_in_cents {
    type: sum
    sql: ${tip_in_cents} ;;
  }

  dimension: to_balance_after_in_cents {
    type: int
  }

  dimension: to_balance_before_in_cents {
    type: int
  }

  dimension: to_balance_in_cents {
    type: int
  }

  dimension: to_balance_type {
  }

  dimension: to_external_in_cents {
    type: int
  }

  dimension: to_external_type {
  }

  dimension: to_id {
    type: int
  }

  dimension: to_state {
  }

  dimension: to_total_in_cents {
    type: int
  }

  dimension: work_item_id {
    type: int
  }

  dimension_group: corp_pending_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.corp_pending_state_at ;;
  }

  dimension_group: corp_settled_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.corp_settled_state_at ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: from_pending_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.from_pending_state_at ;;
  }

  dimension_group: from_settled_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.from_settled_state_at ;;
  }

  dimension_group: refunded {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.refunded_at ;;
  }

  dimension_group: to_pending_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.to_pending_state_at ;;
  }

  dimension_group: to_settled_state {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.to_settled_state_at ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.updated_at ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }

  measure: from_balance_in_cents_total {
    type: sum
    sql: from_balance_in_cents ;;
  }

  measure: total_service_fee_in_cents {
    type: sum
    sql: ${service_fee_in_cents} ;;
  }

  measure: worker_fee_in_cents {
    type: int
  }

  measure: total_worker_fee_in_cents {
    type: sum
    sql: ${worker_fee_in_cents} ;;
  }

  measure: gross_bookings_in_cents {
    type: int
    sql: ( ${TABLE}.service_fee_in_cents + ${TABLE}.worker_fee_in_cents + ${TABLE}.reimbursement_in_cents + ${TABLE}.tip_in_cents ) ;;
  }

  measure: total_gross_bookings_in_cents {
    type: sum
    sql: ${gross_bookings_in_cents} ;;
  }

  measure: total_corp_external_total_in_cents {
    type: sum
    sql: ${corp_external_in_cents} ;;
  }

  measure: total_corp_total_in_cents {
    type: sum
    sql: ${corp_total_in_cents} ;;
  }

  measure: deliveries_adjustment_in_cents {
    sql: CASE WHEN (${TABLE}.marketplace = 'managed_deliveries') THEN ${TABLE}.worker_fee_in_cents ELSE 0 END ;;
  }

  measure: total_deliveries_adjustment_in_cents {
    type: sum
    sql: ${deliveries_adjustment_in_cents} ;;
  }
}

- view: payment_transactions
  sql_table_name: payment_transactions
  fields:
  - dimension: braintree_authorization
  - dimension: braintree_merchant_id
  - dimension: corp_balance_after_in_cents
    type: int
  - dimension: corp_balance_before_in_cents
    type: int
  - dimension: corp_balance_in_cents
    type: int
  - dimension: corp_balance_type
  - dimension: corp_braintree_authorization
  - dimension: corp_external_in_cents
    type: int
  - dimension: corp_external_type
  - dimension: corp_state
  - dimension: corp_total_in_cents
    type: int
  - dimension: country_code
  - dimension: creator_type
  - dimension: currency_code
  - dimension: discount_in_cents
    type: int
  - dimension: total_discount_in_cents
    type: sum
    sql: ${discount_in_cents}
  - dimension: discount_name
  - dimension: from_balance_after_in_cents
    type: int
  - dimension: from_balance_before_in_cents
    type: int
  - dimension: from_balance_in_cents
    type: int
  - dimension: from_balance_type
  - dimension: from_external_in_cents
    type: int
  - dimension: from_external_type
  - dimension: from_id
    type: int
  - dimension: from_state
  - dimension: from_total_in_cents
    type: int
  - dimension: geography_id
    type: int
  - dimension: id
    type: int
  - dimension: local_id
  - dimension: local_type
  - dimension: marketplace
  - dimension: owner_fee_in_cents
    type: int
  - dimension: payment_merchant_id
    type: int
  - dimension: payment_method_id
    type: int
  - dimension: promotion_in_cents
    type: int
  - dimension: total_promotion_in_cents
    type: sum
    sql: ${promotion_in_cents}
  - dimension: promotion_name
  - dimension: refunded_id
    type: int
  - dimension: reimbursement_in_cents
    type: int
  - dimension: total_reimbursement_in_cents
    type: sum
    sql: ${reimbursement_in_cents}
  - dimension: service_fee_in_cents
    type: int
  - dimension: tip_in_cents
    type: int
  - dimension: total_tip_in_cents
    type: sum
    sql: ${tip_in_cents}
  - dimension: to_balance_after_in_cents
    type: int
  - dimension: to_balance_before_in_cents
    type: int
  - dimension: to_balance_in_cents
    type: int
  - dimension: to_balance_type
  - dimension: to_external_in_cents
    type: int
  - dimension: to_external_type
  - dimension: to_id
    type: int
  - dimension: to_state
  - dimension: to_total_in_cents
    type: int
  - dimension: work_item_id
    type: int
  - dimension_group: corp_pending_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.corp_pending_state_at
  - dimension_group: corp_settled_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.corp_settled_state_at
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: from_pending_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.from_pending_state_at
  - dimension_group: from_settled_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.from_settled_state_at
  - dimension_group: refunded
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.refunded_at
  - dimension_group: to_pending_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.to_pending_state_at
  - dimension_group: to_settled_state
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.to_settled_state_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count_distinct
    sql: ${id}
  - measure: from_balance_in_cents_total
    type: sum
    sql: from_balance_in_cents
  - measure: total_service_fee_in_cents
    type: sum
    sql: ${service_fee_in_cents}
  - measure: worker_fee_in_cents
    type: int
  - measure: total_worker_fee_in_cents
    type: sum
    sql: ${worker_fee_in_cents}
  - measure: gross_bookings_in_cents
    type: int
    sql: ( ${TABLE}.service_fee_in_cents + ${TABLE}.worker_fee_in_cents + ${TABLE}.reimbursement_in_cents + ${TABLE}.tip_in_cents )
  - measure: total_gross_bookings_in_cents
    type: sum
    sql: ${gross_bookings_in_cents}
  - measure: total_corp_external_total_in_cents
    type: sum
    sql: ${corp_external_in_cents}
  - measure: total_corp_total_in_cents
    type: sum
    sql: ${corp_total_in_cents}
  - measure: deliveries_adjustment_in_cents
    sql: CASE WHEN (${TABLE}.marketplace = 'managed_deliveries') THEN ${TABLE}.worker_fee_in_cents ELSE 0 END
  - measure: total_deliveries_adjustment_in_cents
    type: sum
    sql: ${deliveries_adjustment_in_cents}