Dfp Data

view: dfp_data {
  label: "DFP Data"
  sql_table_name: revenue.dfp_data ;;

  dimension: advertiser_id {
    type: int
    sql: ${TABLE}.advertiser_id ;;
  }

  dimension: advertiser_name {
    sql: ${TABLE}.advertiser_name ;;
  }

  dimension: cpm {
    type: number
    value_format: "$#,##0.00"
    sql: ${TABLE}.cpm ;;
  }

  dimension: creative_size {
    sql: ${TABLE}.creative_size ;;
  }

  dimension: device {
    sql: ${TABLE}.device ;;
  }

  dimension: impressions {
    type: int
    sql: ${TABLE}.impressions ;;
  }

  dimension: line_item_cost_per_unit {
    type: number
    sql: ${TABLE}.line_item_cost_per_unit ;;
  }

  dimension: line_item_cost_type {
    sql: ${TABLE}.line_item_cost_type ;;
  }

  dimension: line_item_id {
    type: int
    sql: ${TABLE}.line_item_id ;;
  }

  dimension: line_item_name {
    sql: ${TABLE}.line_item_name ;;
  }

  dimension: line_item_type {
    sql: ${TABLE}.line_item_type ;;
  }

  dimension: order_id {
    type: int
    sql: ${TABLE}.order_id ;;
  }

  dimension: order_name {
    sql: ${TABLE}.order_name ;;
  }

  dimension: salesperson_id {
    type: int
    sql: ${TABLE}.salesperson_id ;;
  }

  dimension: salesperson_name {
    sql: ${TABLE}.salesperson_name ;;
  }

  dimension: section {
    sql: ${TABLE}.section ;;
  }

  dimension: site_name {
    sql: ${TABLE}.site_name ;;
  }

  dimension: subsection {
    sql: ${TABLE}.subsection ;;
  }

  dimension: united_states {
    type: yesno
    sql: ${TABLE}.united_states = true ;;
  }

  dimension_group: dt {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.dt ;;
  }

  measure: revenue {
    type: sum
    value_format: "$#,##0.00"
    sql: ${TABLE}.revenue ;;
  }

  measure: total_line_item_impressions {
    type: sum
    drill_fields: [site_name, salesperson_name, advertiser_name, order_name, line_item_name]
    sql: ${TABLE}.total_line_item_impressions ;;
  }
}

- view: dfp_data
  label: DFP Data
  sql_table_name: revenue.dfp_data
  fields:
  - dimension: advertiser_id
    type: int
    sql: ${TABLE}.advertiser_id
  - dimension: advertiser_name
    sql: ${TABLE}.advertiser_name
  - dimension: cpm
    type: number
    value_format: '$#,##0.00'
    sql: ${TABLE}.cpm
  - dimension: creative_size
    sql: ${TABLE}.creative_size
  - dimension: device
    sql: ${TABLE}.device
  - dimension: impressions
    type: int
    sql: ${TABLE}.impressions
  - dimension: line_item_cost_per_unit
    type: number
    sql: ${TABLE}.line_item_cost_per_unit
  - dimension: line_item_cost_type
    sql: ${TABLE}.line_item_cost_type
  - dimension: line_item_id
    type: int
    sql: ${TABLE}.line_item_id
  - dimension: line_item_name
    sql: ${TABLE}.line_item_name
  - dimension: line_item_type
    sql: ${TABLE}.line_item_type
  - dimension: order_id
    type: int
    sql: ${TABLE}.order_id
  - dimension: order_name
    sql: ${TABLE}.order_name
  - dimension: salesperson_id
    type: int
    sql: ${TABLE}.salesperson_id
  - dimension: salesperson_name
    sql: ${TABLE}.salesperson_name
  - dimension: section
    sql: ${TABLE}.section
  - dimension: site_name
    sql: ${TABLE}.site_name
  - dimension: subsection
    sql: ${TABLE}.subsection
  - dimension: united_states
    type: yesno
    sql: ${TABLE}.united_states = true
  - dimension_group: dt
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.dt
  - measure: revenue
    type: sum
    value_format: '$#,##0.00'
    sql: ${TABLE}.revenue
  - measure: total_line_item_impressions
    type: sum
    drill_fields:
    - site_name
    - salesperson_name
    - advertiser_name
    - order_name
    - line_item_name
    sql: ${TABLE}.total_line_item_impressions