Log Company Accounts

view: log_company_accounts {
  label: "Log"
  sql_table_name: public.perf_log_company_{{ _access_filters["log_company_accounts.account_id"] }} ;;

  dimension: account_id {
    hidden: yes
    sql: ${TABLE}.accountid ;;
  }

  dimension: table {
    type: yesno
    hidden: yes
    sql: 1=1 ;;
  }

  dimension: ad_id {
    type: int
    hidden: yes
    sql: ${TABLE}.adid ;;
  }

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

  dimension: browser_id {
    type: int
    hidden: yes
    sql: ${TABLE}.browserid ;;
  }

  dimension: campaign_id {
    type: int
    hidden: yes
    sql: ${TABLE}.campaignid ;;
  }

  dimension: placement_id {
    type: int
    hidden: yes
    sql: ${TABLE}.placementid ;;
  }

  dimension: video_impressions {
    type: int
    hidden: yes
    sql: ${TABLE}.videoimpressions ;;
  }

  dimension: blocked_impressions {
    type: int
    hidden: yes
    sql: ${TABLE}.blockedimpressions ;;
  }

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

  dimension: interactions {
    type: int
    hidden: yes
    sql: ${TABLE}.interactions ;;
  }

  dimension: clicks {
    type: int
    hidden: yes
    sql: ${TABLE}.clicks ;;
  }

  measure: count {
    type: count
  }

  measure: total_clicks {
    type: sum
    sql: ${clicks} ;;
  }

  measure: total_video_impressions {
    type: sum
    sql: ${video_impressions} ;;
  }

  measure: total_impressions {
    type: sum
    sql: ${impressions} ;;
  }

  measure: total_interactions {
    type: sum
    sql: ${interactions} ;;
  }

  measure: total_blocked_impressions {
    type: sum
    sql: ${blocked_impressions} ;;
  }
}

- view: log_company_accounts
  label: Log
  sql_table_name: 'public.perf_log_company_{{ _access_filters["log_company_accounts.account_id"] }}'
  fields:
  - dimension: account_id
    hidden: true
    sql: ${TABLE}.accountid
  - dimension: table
    type: yesno
    hidden: true
    sql: 1=1
  - dimension: ad_id
    type: int
    hidden: true
    sql: ${TABLE}.adid
  - dimension: advertiser_id
    type: int
    hidden: true
    sql: ${TABLE}.advertiserid
  - dimension: browser_id
    type: int
    hidden: true
    sql: ${TABLE}.browserid
  - dimension: campaign_id
    type: int
    hidden: true
    sql: ${TABLE}.campaignid
  - dimension: placement_id
    type: int
    hidden: true
    sql: ${TABLE}.placementid
  - dimension: video_impressions
    type: int
    hidden: true
    sql: ${TABLE}.videoimpressions
  - dimension: blocked_impressions
    type: int
    hidden: true
    sql: ${TABLE}.blockedimpressions
  - dimension: impressions
    type: int
    hidden: true
    sql: ${TABLE}.impressions
  - dimension: interactions
    type: int
    hidden: true
    sql: ${TABLE}.interactions
  - dimension: clicks
    type: int
    hidden: true
    sql: ${TABLE}.clicks
  - measure: count
    type: count
  - measure: total_clicks
    type: sum
    sql: ${clicks}
  - measure: total_video_impressions
    type: sum
    sql: ${video_impressions}
  - measure: total_impressions
    type: sum
    sql: ${impressions}
  - measure: total_interactions
    type: sum
    sql: ${interactions}
  - measure: total_blocked_impressions
    type: sum
    sql: ${blocked_impressions}