Ad Stat Daily Totals Meta Mview

view: ad_stat_daily_totals_meta_mview {
  sql_table_name: facebook.ad_stat_daily_totals_meta_mview ;;

  dimension: actionscomment {
    type: number
    sql: ${TABLE}."actions.comment" ;;
  }

  dimension: actionslike {
    type: number
    sql: ${TABLE}."actions.like" ;;
  }

  dimension: actionslikes {
    type: number
    sql: ${TABLE}."actions.likes" ;;
  }

  dimension: actionslink_click {
    type: number
    sql: ${TABLE}."actions.link_click" ;;
  }

  dimension: actionsphoto_view {
    type: number
    sql: ${TABLE}."actions.photo_view" ;;
  }

  dimension: actionspost {
    type: number
    sql: ${TABLE}."actions.post" ;;
  }

  dimension: actionspost_like {
    type: number
    sql: ${TABLE}."actions.post_like" ;;
  }

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

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

  dimension: inline_actionscomment {
    type: number
    sql: ${TABLE}."inline_actions.comment" ;;
  }

  dimension: inline_actionslike {
    type: number
    sql: ${TABLE}."inline_actions.like" ;;
  }

  dimension: inline_actionslink_click {
    type: number
    sql: ${TABLE}."inline_actions.link_click" ;;
  }

  dimension: inline_actionsphoto_view {
    type: number
    sql: ${TABLE}."inline_actions.photo_view" ;;
  }

  dimension: inline_actionspost_like {
    type: number
    sql: ${TABLE}."inline_actions.post_like" ;;
  }

  dimension: inline_actionsquestion_vote {
    type: number
    sql: ${TABLE}."inline_actions.question_vote" ;;
  }

  dimension: inline_actionsrsvp_maybe {
    type: number
    sql: ${TABLE}."inline_actions.rsvp_maybe" ;;
  }

  dimension: inline_actionsrsvp_yes {
    type: number
    sql: ${TABLE}."inline_actions.rsvp_yes" ;;
  }

  dimension: inline_actionstitle_clicks {
    type: number
    sql: ${TABLE}."inline_actions.title_clicks" ;;
  }

  dimension: inline_actionsvideo_play {
    type: number
    sql: ${TABLE}."inline_actions.video_play" ;;
  }

  dimension: newsfeed_positionnewsfeed_average_position {
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_average_position" ;;
  }

  dimension: newsfeed_positionnewsfeed_clicks {
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_clicks" ;;
  }

  dimension: newsfeed_positionnewsfeed_impressions {
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_impressions" ;;
  }

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }

  measure: total_spent {
    type: sum
    sql: ${spent} ;;
  }
}

- view: ad_stat_daily_totals_meta_mview
  sql_table_name: facebook.ad_stat_daily_totals_meta_mview
  fields:
  - dimension: actionscomment
    type: number
    sql: ${TABLE}."actions.comment"
  - dimension: actionslike
    type: number
    sql: ${TABLE}."actions.like"
  - dimension: actionslikes
    type: number
    sql: ${TABLE}."actions.likes"
  - dimension: actionslink_click
    type: number
    sql: ${TABLE}."actions.link_click"
  - dimension: actionsphoto_view
    type: number
    sql: ${TABLE}."actions.photo_view"
  - dimension: actionspost
    type: number
    sql: ${TABLE}."actions.post"
  - dimension: actionspost_like
    type: number
    sql: ${TABLE}."actions.post_like"
  - dimension: clicks
    type: number
    sql: ${TABLE}.clicks
  - dimension: impressions
    type: number
    sql: ${TABLE}.impressions
  - dimension: inline_actionscomment
    type: number
    sql: ${TABLE}."inline_actions.comment"
  - dimension: inline_actionslike
    type: number
    sql: ${TABLE}."inline_actions.like"
  - dimension: inline_actionslink_click
    type: number
    sql: ${TABLE}."inline_actions.link_click"
  - dimension: inline_actionsphoto_view
    type: number
    sql: ${TABLE}."inline_actions.photo_view"
  - dimension: inline_actionspost_like
    type: number
    sql: ${TABLE}."inline_actions.post_like"
  - dimension: inline_actionsquestion_vote
    type: number
    sql: ${TABLE}."inline_actions.question_vote"
  - dimension: inline_actionsrsvp_maybe
    type: number
    sql: ${TABLE}."inline_actions.rsvp_maybe"
  - dimension: inline_actionsrsvp_yes
    type: number
    sql: ${TABLE}."inline_actions.rsvp_yes"
  - dimension: inline_actionstitle_clicks
    type: number
    sql: ${TABLE}."inline_actions.title_clicks"
  - dimension: inline_actionsvideo_play
    type: number
    sql: ${TABLE}."inline_actions.video_play"
  - dimension: newsfeed_positionnewsfeed_average_position
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_average_position"
  - dimension: newsfeed_positionnewsfeed_clicks
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_clicks"
  - dimension: newsfeed_positionnewsfeed_impressions
    type: number
    sql: ${TABLE}."newsfeed_position.newsfeed_impressions"
  - dimension: social_clicks
    type: number
    sql: ${TABLE}.social_clicks
  - dimension: social_impressions
    type: number
    sql: ${TABLE}.social_impressions
  - dimension: social_spent
    type: number
    sql: ${TABLE}.social_spent
  - dimension: social_unique_clicks
    type: number
    sql: ${TABLE}.social_unique_clicks
  - dimension: social_unique_impressions
    type: number
    sql: ${TABLE}.social_unique_impressions
  - dimension: spent
    type: number
    sql: ${TABLE}.spent
  - dimension: unique_clicks
    type: number
    sql: ${TABLE}.unique_clicks
  - dimension: unique_impressions
    type: number
    sql: ${TABLE}.unique_impressions
  - dimension_group: stat
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.stat_date
  - measure: count
    type: count
  - measure: total_spent
    type: sum
    sql: ${spent}