Mp Page Views

view: mp_page_views {
  sql_table_name: public.mp_page_views ;;

  dimension: aa_client_ip {
    type: string
    sql: ${TABLE}.aa_client_ip ;;
  }

  dimension: aa_event {
    type: string
    sql: ${TABLE}.aa_event ;;
  }

  dimension: aa_orig_event {
    type: string
    sql: ${TABLE}.aa_orig_event ;;
  }

  dimension: aauuid {
    type: string
    sql: ${TABLE}.aauuid ;;
  }

  dimension: aauuid_orig {
    type: string
    sql: ${TABLE}.aauuid_orig ;;
  }

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

  dimension: currency {
    type: string
    sql: ${TABLE}.currency ;;
  }

  dimension: current_url {
    type: string
    sql: ${TABLE}.current_url ;;
  }

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

  dimension: donor_id {
    type: string
    sql: ${TABLE}.donor_id ;;
  }

  dimension: donor_name {
    type: string
    sql: ${TABLE}.donor_name ;;
  }

  dimension: elementid {
    type: string
    sql: ${TABLE}.elementid ;;
  }

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

  dimension: experimentvariant_ids {
    type: string
    sql: ${TABLE}.experimentvariant_ids ;;
  }

  dimension: fbid {
    type: string
    sql: ${TABLE}.fbid ;;
  }

  dimension: fuid {
    type: string
    sql: ${TABLE}.fuid ;;
  }

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

  dimension: fund_name {
    type: string
    sql: ${TABLE}.fund_name ;;
  }

  dimension: campaign_url {
    type: string
    sql: ${TABLE}.campaign_url ;;
  }

  dimension: lightboxid {
    type: string
    sql: ${TABLE}.lightboxid ;;
  }

  dimension: mp_page {
    type: string
    sql: ${TABLE}.mp_page ;;
  }

  dimension: pc_code {
    type: string
    sql: ${TABLE}.pc_code ;;
  }

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

  dimension: rcid {
    type: string
    sql: ${TABLE}.rcid ;;
  }

  dimension: referer_code {
    type: string
    sql: ${TABLE}.referer_code ;;
  }

  dimension: share_url {
    type: string
    sql: ${TABLE}.share_url ;;
  }

  dimension: url {
    type: string
    sql: ${TABLE}.url ;;
  }

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

  dimension: viewid {
    type: string
    sql: ${TABLE}.viewid ;;
  }

  dimension: viewrid {
    type: string
    sql: ${TABLE}.viewrid ;;
  }

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

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

  measure: count {
    label: "Pageviews"
    type: count
    drill_fields: [detail*]
  }

  measure: count_donations {
    label: "Donations"
    type: count_distinct
    drill_fields: [detail*]
    sql: ${donation_id} ;;
  }
}

- view: mp_page_views
  sql_table_name: public.mp_page_views
  fields:
  - dimension: aa_client_ip
    type: string
    sql: ${TABLE}.aa_client_ip
  - dimension: aa_event
    type: string
    sql: ${TABLE}.aa_event
  - dimension: aa_orig_event
    type: string
    sql: ${TABLE}.aa_orig_event
  - dimension: aauuid
    type: string
    sql: ${TABLE}.aauuid
  - dimension: aauuid_orig
    type: string
    sql: ${TABLE}.aauuid_orig
  - dimension: balance
    type: number
    sql: ${TABLE}.balance
  - dimension: currency
    type: string
    sql: ${TABLE}.currency
  - dimension: current_url
    type: string
    sql: ${TABLE}.current_url
  - dimension: donation_id
    type: int
    sql: ${TABLE}.donation_id
  - dimension: donor_id
    type: string
    sql: ${TABLE}.donor_id
  - dimension: donor_name
    type: string
    sql: ${TABLE}.donor_name
  - dimension: elementid
    type: string
    sql: ${TABLE}.elementid
  - dimension: experimentvariant_id
    type: int
    sql: ${TABLE}.experimentvariant_id
  - dimension: experimentvariant_ids
    type: string
    sql: ${TABLE}.experimentvariant_ids
  - dimension: fbid
    type: string
    sql: ${TABLE}.fbid
  - dimension: fuid
    type: string
    sql: ${TABLE}.fuid
  - dimension: fund_id
    type: int
    sql: ${TABLE}.fund_id
  - dimension: fund_name
    type: string
    sql: ${TABLE}.fund_name
  - dimension: campaign_url
    type: string
    sql: ${TABLE}.campaign_url
  - dimension: lightboxid
    type: string
    sql: ${TABLE}.lightboxid
  - dimension: mp_page
    type: string
    sql: ${TABLE}.mp_page
  - dimension: pc_code
    type: string
    sql: ${TABLE}.pc_code
  - dimension: person_id
    type: int
    sql: ${TABLE}.person_id
  - dimension: rcid
    type: string
    sql: ${TABLE}.rcid
  - dimension: referer_code
    type: string
    sql: ${TABLE}.referer_code
  - dimension: share_url
    type: string
    sql: ${TABLE}.share_url
  - dimension: url
    type: string
    sql: ${TABLE}.url
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension: viewid
    type: string
    sql: ${TABLE}.viewid
  - dimension: viewrid
    type: string
    sql: ${TABLE}.viewrid
  - dimension_group: received
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.received_at
  - dimension_group: rendered
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.rendered_at
  - measure: count
    type: count
    label: Pageviews
    drill_fields:
    - detail*
  - measure: count_donations
    type: count_distinct
    label: Donations
    drill_fields:
    - detail*
    sql: ${donation_id}