Campaigns

view: campaigns {
  sql_table_name: public.campaigns ;;

  dimension: campaign_idea_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.campaign_idea_id ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}

- view: campaigns
  sql_table_name: public.campaigns
  fields:
  - dimension: campaign_idea_id
    type: int
    primary_key: true
    sql: ${TABLE}.campaign_idea_id
  - dimension: branded_community
    type: number
    sql: ${TABLE}.branded_community
  - dimension: campaign_members_count
    type: int
    sql: ${TABLE}.campaign_members_count
  - dimension: future_cause
    type: number
    sql: ${TABLE}.future_cause
  - dimension: hwm_data
    sql: ${TABLE}.hwm_data
  - dimension: hwm_field
    sql: ${TABLE}.hwm_field
  - dimension: id
    type: int
    sql: ${TABLE}.id
  - dimension: joinable
    type: number
    sql: ${TABLE}.joinable
  - dimension: major_cause
    type: number
    sql: ${TABLE}.major_cause
  - dimension: meta_description
    sql: ${TABLE}.meta_description
  - dimension: meta_keywords
    sql: ${TABLE}.meta_keywords
  - dimension: meta_title
    sql: ${TABLE}.meta_title
  - dimension: name
    sql: ${TABLE}.name
  - dimension: nonprofit_amount_raised
    type: int
    sql: ${TABLE}.nonprofit_amount_raised
  - dimension: parent_id
    type: int
    sql: ${TABLE}.parent_id
  - dimension: photo_id
    type: int
    sql: ${TABLE}.photo_id
  - dimension: politician_amount_raised
    type: int
    sql: ${TABLE}.politician_amount_raised
  - dimension: primer
    sql: ${TABLE}.primer
  - dimension: published_posts
    type: number
    sql: ${TABLE}.published_posts
  - dimension: recent_rank
    type: int
    sql: ${TABLE}.recent_rank
  - dimension: slide_photo_id
    type: int
    sql: ${TABLE}.slide_photo_id
  - dimension: url
    sql: ${TABLE}.url
  - dimension: viewing_records_count
    type: int
    sql: ${TABLE}.viewing_records_count
  - dimension: wordpress_blog_id
    type: int
    sql: ${TABLE}.wordpress_blog_id
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: deleted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.deleted_at
  - dimension_group: extracted_at_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.extracted_at_utc
  - dimension_group: last_activity
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_activity_date
  - dimension_group: last_cache_update
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_cache_update
  - measure: count
    type: count