Touch

view: touch {
  sql_table_name: touch ;;

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

  dimension: as_json {
    hidden: yes
    sql: ${TABLE}.as_json ;;
  }

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

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

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

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

  dimension: country_code {
    sql: CASE
  WHEN ${TABLE}.country = 'AF' THEN 'AFG'
  WHEN ${TABLE}.country = 'AX' THEN 'ALA'
  WHEN ${TABLE}.country = 'AL' THEN 'ALB'
  WHEN ${TABLE}.country = 'DZ' THEN 'DZA'
  WHEN ${TABLE}.country = 'AS' THEN 'ASM'
  WHEN ${TABLE}.country = 'AD' THEN 'AND'
  WHEN ${TABLE}.country = 'AO' THEN 'AGO'
  WHEN ${TABLE}.country = 'AI' THEN 'AIA'
  WHEN ${TABLE}.country = 'AQ' THEN 'ATA'
  WHEN ${TABLE}.country = 'AG' THEN 'ATG'
  WHEN ${TABLE}.country = 'AR' THEN 'ARG'
  WHEN ${TABLE}.country = 'AM' THEN 'ARM'
  WHEN ${TABLE}.country = 'AW' THEN 'ABW'
  WHEN ${TABLE}.country = 'AU' THEN 'AUS'
  WHEN ${TABLE}.country = 'AT' THEN 'AUT'
  WHEN ${TABLE}.country = 'AZ' THEN 'AZE'
  WHEN ${TABLE}.country = 'BS' THEN 'BHS'
  WHEN ${TABLE}.country = 'BH' THEN 'BHR'
  WHEN ${TABLE}.country = 'BD' THEN 'BGD'
  WHEN ${TABLE}.country = 'BB' THEN 'BRB'
  WHEN ${TABLE}.country = 'BY' THEN 'BLR'
  WHEN ${TABLE}.country = 'BE' THEN 'BEL'
  WHEN ${TABLE}.country = 'BZ' THEN 'BLZ'
  WHEN ${TABLE}.country = 'BJ' THEN 'BEN'
  WHEN ${TABLE}.country = 'BM' THEN 'BMU'
  WHEN ${TABLE}.country = 'BT' THEN 'BTN'
  WHEN ${TABLE}.country = 'BO' THEN 'BOL'
  WHEN ${TABLE}.country = 'BQ' THEN 'BES'
  WHEN ${TABLE}.country = 'BA' THEN 'BIH'
  WHEN ${TABLE}.country = 'BW' THEN 'BWA'
  WHEN ${TABLE}.country = 'BV' THEN 'BVT'
  WHEN ${TABLE}.country = 'BR' THEN 'BRA'
  WHEN ${TABLE}.country = 'IO' THEN 'IOT'
  WHEN ${TABLE}.country = 'BN' THEN 'BRN'
  WHEN ${TABLE}.country = 'BG' THEN 'BGR'
  WHEN ${TABLE}.country = 'BF' THEN 'BFA'
  WHEN ${TABLE}.country = 'BI' THEN 'BDI'
  WHEN ${TABLE}.country = 'KH' THEN 'KHM'
  WHEN ${TABLE}.country = 'CM' THEN 'CMR'
  WHEN ${TABLE}.country = 'CA' THEN 'CAN'
  WHEN ${TABLE}.country = 'CV' THEN 'CPV'
  WHEN ${TABLE}.country = 'KY' THEN 'CYM'
  WHEN ${TABLE}.country = 'CF' THEN 'CAF'
  WHEN ${TABLE}.country = 'TD' THEN 'TCD'
  WHEN ${TABLE}.country = 'CL' THEN 'CHL'
  WHEN ${TABLE}.country = 'CN' THEN 'CHN'
  WHEN ${TABLE}.country = 'CX' THEN 'CXR'
  WHEN ${TABLE}.country = 'CC' THEN 'CCK'
  WHEN ${TABLE}.country = 'CO' THEN 'COL'
  WHEN ${TABLE}.country = 'KM' THEN 'COM'
  WHEN ${TABLE}.country = 'CG' THEN 'COG'
  WHEN ${TABLE}.country = 'CD' THEN 'COD'
  WHEN ${TABLE}.country = 'CK' THEN 'COK'
  WHEN ${TABLE}.country = 'CR' THEN 'CRI'
  WHEN ${TABLE}.country = 'CI' THEN 'CIV'
  WHEN ${TABLE}.country = 'HR' THEN 'HRV'
  WHEN ${TABLE}.country = 'CU' THEN 'CUB'
  WHEN ${TABLE}.country = 'CW' THEN 'CUW'
  WHEN ${TABLE}.country = 'CY' THEN 'CYP'
  WHEN ${TABLE}.country = 'CZ' THEN 'CZE'
  WHEN ${TABLE}.country = 'DK' THEN 'DNK'
  WHEN ${TABLE}.country = 'DJ' THEN 'DJI'
  WHEN ${TABLE}.country = 'DM' THEN 'DMA'
  WHEN ${TABLE}.country = 'DO' THEN 'DOM'
  WHEN ${TABLE}.country = 'EC' THEN 'ECU'
  WHEN ${TABLE}.country = 'EG' THEN 'EGY'
  WHEN ${TABLE}.country = 'SV' THEN 'SLV'
  WHEN ${TABLE}.country = 'GQ' THEN 'GNQ'
  WHEN ${TABLE}.country = 'ER' THEN 'ERI'
  WHEN ${TABLE}.country = 'EE' THEN 'EST'
  WHEN ${TABLE}.country = 'ET' THEN 'ETH'
  WHEN ${TABLE}.country = 'FK' THEN 'FLK'
  WHEN ${TABLE}.country = 'FO' THEN 'FRO'
  WHEN ${TABLE}.country = 'FJ' THEN 'FJI'
  WHEN ${TABLE}.country = 'FI' THEN 'FIN'
  WHEN ${TABLE}.country = 'FR' THEN 'FRA'
  WHEN ${TABLE}.country = 'GF' THEN 'GUF'
  WHEN ${TABLE}.country = 'PF' THEN 'PYF'
  WHEN ${TABLE}.country = 'TF' THEN 'ATF'
  WHEN ${TABLE}.country = 'GA' THEN 'GAB'
  WHEN ${TABLE}.country = 'GM' THEN 'GMB'
  WHEN ${TABLE}.country = 'GE' THEN 'GEO'
  WHEN ${TABLE}.country = 'DE' THEN 'DEU'
  WHEN ${TABLE}.country = 'GH' THEN 'GHA'
  WHEN ${TABLE}.country = 'GI' THEN 'GIB'
  WHEN ${TABLE}.country = 'GR' THEN 'GRC'
  WHEN ${TABLE}.country = 'GL' THEN 'GRL'
  WHEN ${TABLE}.country = 'GD' THEN 'GRD'
  WHEN ${TABLE}.country = 'GP' THEN 'GLP'
  WHEN ${TABLE}.country = 'GU' THEN 'GUM'
  WHEN ${TABLE}.country = 'GT' THEN 'GTM'
  WHEN ${TABLE}.country = 'GG' THEN 'GGY'
  WHEN ${TABLE}.country = 'GN' THEN 'GIN'
  WHEN ${TABLE}.country = 'GW' THEN 'GNB'
  WHEN ${TABLE}.country = 'GY' THEN 'GUY'
  WHEN ${TABLE}.country = 'HT' THEN 'HTI'
  WHEN ${TABLE}.country = 'HM' THEN 'HMD'
  WHEN ${TABLE}.country = 'VA' THEN 'VAT'
  WHEN ${TABLE}.country = 'HN' THEN 'HND'
  WHEN ${TABLE}.country = 'HK' THEN 'HKG'
  WHEN ${TABLE}.country = 'HU' THEN 'HUN'
  WHEN ${TABLE}.country = 'IS' THEN 'ISL'
  WHEN ${TABLE}.country = 'IN' THEN 'IND'
  WHEN ${TABLE}.country = 'ID' THEN 'IDN'
  WHEN ${TABLE}.country = 'IR' THEN 'IRN'
  WHEN ${TABLE}.country = 'IQ' THEN 'IRQ'
  WHEN ${TABLE}.country = 'IE' THEN 'IRL'
  WHEN ${TABLE}.country = 'IM' THEN 'IMN'
  WHEN ${TABLE}.country = 'IL' THEN 'ISR'
  WHEN ${TABLE}.country = 'IT' THEN 'ITA'
  WHEN ${TABLE}.country = 'JM' THEN 'JAM'
  WHEN ${TABLE}.country = 'JP' THEN 'JPN'
  WHEN ${TABLE}.country = 'JE' THEN 'JEY'
  WHEN ${TABLE}.country = 'JO' THEN 'JOR'
  WHEN ${TABLE}.country = 'KZ' THEN 'KAZ'
  WHEN ${TABLE}.country = 'KE' THEN 'KEN'
  WHEN ${TABLE}.country = 'KI' THEN 'KIR'
  WHEN ${TABLE}.country = 'KP' THEN 'PRK'
  WHEN ${TABLE}.country = 'KR' THEN 'KOR'
  WHEN ${TABLE}.country = 'KW' THEN 'KWT'
  WHEN ${TABLE}.country = 'KG' THEN 'KGZ'
  WHEN ${TABLE}.country = 'LA' THEN 'LAO'
  WHEN ${TABLE}.country = 'LV' THEN 'LVA'
  WHEN ${TABLE}.country = 'LB' THEN 'LBN'
  WHEN ${TABLE}.country = 'LS' THEN 'LSO'
  WHEN ${TABLE}.country = 'LR' THEN 'LBR'
  WHEN ${TABLE}.country = 'LY' THEN 'LBY'
  WHEN ${TABLE}.country = 'LI' THEN 'LIE'
  WHEN ${TABLE}.country = 'LT' THEN 'LTU'
  WHEN ${TABLE}.country = 'LU' THEN 'LUX'
  WHEN ${TABLE}.country = 'MO' THEN 'MAC'
  WHEN ${TABLE}.country = 'MK' THEN 'MKD'
  WHEN ${TABLE}.country = 'MG' THEN 'MDG'
  WHEN ${TABLE}.country = 'MW' THEN 'MWI'
  WHEN ${TABLE}.country = 'MY' THEN 'MYS'
  WHEN ${TABLE}.country = 'MV' THEN 'MDV'
  WHEN ${TABLE}.country = 'ML' THEN 'MLI'
  WHEN ${TABLE}.country = 'MT' THEN 'MLT'
  WHEN ${TABLE}.country = 'MH' THEN 'MHL'
  WHEN ${TABLE}.country = 'MQ' THEN 'MTQ'
  WHEN ${TABLE}.country = 'MR' THEN 'MRT'
  WHEN ${TABLE}.country = 'MU' THEN 'MUS'
  WHEN ${TABLE}.country = 'YT' THEN 'MYT'
  WHEN ${TABLE}.country = 'MX' THEN 'MEX'
  WHEN ${TABLE}.country = 'FM' THEN 'FSM'
  WHEN ${TABLE}.country = 'MD' THEN 'MDA'
  WHEN ${TABLE}.country = 'MC' THEN 'MCO'
  WHEN ${TABLE}.country = 'MN' THEN 'MNG'
  WHEN ${TABLE}.country = 'ME' THEN 'MNE'
  WHEN ${TABLE}.country = 'MS' THEN 'MSR'
  WHEN ${TABLE}.country = 'MA' THEN 'MAR'
  WHEN ${TABLE}.country = 'MZ' THEN 'MOZ'
  WHEN ${TABLE}.country = 'MM' THEN 'MMR'
  WHEN ${TABLE}.country = 'NA' THEN 'NAM'
  WHEN ${TABLE}.country = 'NR' THEN 'NRU'
  WHEN ${TABLE}.country = 'NP' THEN 'NPL'
  WHEN ${TABLE}.country = 'NL' THEN 'NLD'
  WHEN ${TABLE}.country = 'NC' THEN 'NCL'
  WHEN ${TABLE}.country = 'NZ' THEN 'NZL'
  WHEN ${TABLE}.country = 'NI' THEN 'NIC'
  WHEN ${TABLE}.country = 'NE' THEN 'NER'
  WHEN ${TABLE}.country = 'NG' THEN 'NGA'
  WHEN ${TABLE}.country = 'NU' THEN 'NIU'
  WHEN ${TABLE}.country = 'NF' THEN 'NFK'
  WHEN ${TABLE}.country = 'MP' THEN 'MNP'
  WHEN ${TABLE}.country = 'NO' THEN 'NOR'
  WHEN ${TABLE}.country = 'OM' THEN 'OMN'
  WHEN ${TABLE}.country = 'PK' THEN 'PAK'
  WHEN ${TABLE}.country = 'PW' THEN 'PLW'
  WHEN ${TABLE}.country = 'PS' THEN 'PSE'
  WHEN ${TABLE}.country = 'PA' THEN 'PAN'
  WHEN ${TABLE}.country = 'PG' THEN 'PNG'
  WHEN ${TABLE}.country = 'PY' THEN 'PRY'
  WHEN ${TABLE}.country = 'PE' THEN 'PER'
  WHEN ${TABLE}.country = 'PH' THEN 'PHL'
  WHEN ${TABLE}.country = 'PN' THEN 'PCN'
  WHEN ${TABLE}.country = 'PL' THEN 'POL'
  WHEN ${TABLE}.country = 'PT' THEN 'PRT'
  WHEN ${TABLE}.country = 'PR' THEN 'PRI'
  WHEN ${TABLE}.country = 'QA' THEN 'QAT'
  WHEN ${TABLE}.country = 'RE' THEN 'REU'
  WHEN ${TABLE}.country = 'RO' THEN 'ROU'
  WHEN ${TABLE}.country = 'RU' THEN 'RUS'
  WHEN ${TABLE}.country = 'RW' THEN 'RWA'
  WHEN ${TABLE}.country = 'BL' THEN 'BLM'
  WHEN ${TABLE}.country = 'SH' THEN 'SHN'
  WHEN ${TABLE}.country = 'KN' THEN 'KNA'
  WHEN ${TABLE}.country = 'LC' THEN 'LCA'
  WHEN ${TABLE}.country = 'MF' THEN 'MAF'
  WHEN ${TABLE}.country = 'PM' THEN 'SPM'
  WHEN ${TABLE}.country = 'VC' THEN 'VCT'
  WHEN ${TABLE}.country = 'WS' THEN 'WSM'
  WHEN ${TABLE}.country = 'SM' THEN 'SMR'
  WHEN ${TABLE}.country = 'ST' THEN 'STP'
  WHEN ${TABLE}.country = 'SA' THEN 'SAU'
  WHEN ${TABLE}.country = 'SN' THEN 'SEN'
  WHEN ${TABLE}.country = 'RS' THEN 'SRB'
  WHEN ${TABLE}.country = 'SC' THEN 'SYC'
  WHEN ${TABLE}.country = 'SL' THEN 'SLE'
  WHEN ${TABLE}.country = 'SG' THEN 'SGP'
  WHEN ${TABLE}.country = 'SX' THEN 'SXM'
  WHEN ${TABLE}.country = 'SK' THEN 'SVK'
  WHEN ${TABLE}.country = 'SI' THEN 'SVN'
  WHEN ${TABLE}.country = 'SB' THEN 'SLB'
  WHEN ${TABLE}.country = 'SO' THEN 'SOM'
  WHEN ${TABLE}.country = 'ZA' THEN 'ZAF'
  WHEN ${TABLE}.country = 'GS' THEN 'SGS'
  WHEN ${TABLE}.country = 'SS' THEN 'SSD'
  WHEN ${TABLE}.country = 'ES' THEN 'ESP'
  WHEN ${TABLE}.country = 'LK' THEN 'LKA'
  WHEN ${TABLE}.country = 'SD' THEN 'SDN'
  WHEN ${TABLE}.country = 'SR' THEN 'SUR'
  WHEN ${TABLE}.country = 'SJ' THEN 'SJM'
  WHEN ${TABLE}.country = 'SZ' THEN 'SWZ'
  WHEN ${TABLE}.country = 'SE' THEN 'SWE'
  WHEN ${TABLE}.country = 'CH' THEN 'CHE'
  WHEN ${TABLE}.country = 'SY' THEN 'SYR'
  WHEN ${TABLE}.country = 'TW' THEN 'TWN'
  WHEN ${TABLE}.country = 'TJ' THEN 'TJK'
  WHEN ${TABLE}.country = 'TZ' THEN 'TZA'
  WHEN ${TABLE}.country = 'TH' THEN 'THA'
  WHEN ${TABLE}.country = 'TL' THEN 'TLS'
  WHEN ${TABLE}.country = 'TG' THEN 'TGO'
  WHEN ${TABLE}.country = 'TK' THEN 'TKL'
  WHEN ${TABLE}.country = 'TO' THEN 'TON'
  WHEN ${TABLE}.country = 'TT' THEN 'TTO'
  WHEN ${TABLE}.country = 'TN' THEN 'TUN'
  WHEN ${TABLE}.country = 'TR' THEN 'TUR'
  WHEN ${TABLE}.country = 'TM' THEN 'TKM'
  WHEN ${TABLE}.country = 'TC' THEN 'TCA'
  WHEN ${TABLE}.country = 'TV' THEN 'TUV'
  WHEN ${TABLE}.country = 'UG' THEN 'UGA'
  WHEN ${TABLE}.country = 'UA' THEN 'UKR'
  WHEN ${TABLE}.country = 'AE' THEN 'ARE'
  WHEN ${TABLE}.country = 'GB' THEN 'GBR'
  WHEN ${TABLE}.country = 'US' THEN 'USA'
  WHEN ${TABLE}.country = 'UM' THEN 'UMI'
  WHEN ${TABLE}.country = 'UY' THEN 'URY'
  WHEN ${TABLE}.country = 'UZ' THEN 'UZB'
  WHEN ${TABLE}.country = 'VU' THEN 'VUT'
  WHEN ${TABLE}.country = 'VE' THEN 'VEN'
  WHEN ${TABLE}.country = 'VN' THEN 'VNM'
  WHEN ${TABLE}.country = 'VG' THEN 'VGB'
  WHEN ${TABLE}.country = 'VI' THEN 'VIR'
  WHEN ${TABLE}.country = 'WF' THEN 'WLF'
  WHEN ${TABLE}.country = 'EH' THEN 'ESH'
  WHEN ${TABLE}.country = 'YE' THEN 'YEM'
  WHEN ${TABLE}.country = 'ZM' THEN 'ZMB'
  WHEN ${TABLE}.country = 'ZW' THEN 'ZWE'
ELSE NULL
END ;;
  }

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

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

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

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

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

  dimension: java_enabled {
    type: yesno
    sql: ${TABLE}.java_enabled ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, utm_name, person.id, event.count, staged_event.count]
  }

  measure: average_engagement_score {
    type: avg
    value_format: "#.00"
    sql: ${engagement_score} ;;
  }
}

- view: touch
  sql_table_name: touch
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: as_json
    hidden: true
    sql: ${TABLE}.as_json
  - dimension: browser
    sql: ${TABLE}.browser
  - dimension: channel_type
    sql: ${TABLE}.channel_type
  - dimension: city
    sql: ${TABLE}.city
  - dimension: country
    sql: ${TABLE}.country
  - dimension: country_code
    sql: CASE
  WHEN ${TABLE}.country = 'AF' THEN 'AFG'
  WHEN ${TABLE}.country = 'AX' THEN 'ALA'
  WHEN ${TABLE}.country = 'AL' THEN 'ALB'
  WHEN ${TABLE}.country = 'DZ' THEN 'DZA'
  WHEN ${TABLE}.country = 'AS' THEN 'ASM'
  WHEN ${TABLE}.country = 'AD' THEN 'AND'
  WHEN ${TABLE}.country = 'AO' THEN 'AGO'
  WHEN ${TABLE}.country = 'AI' THEN 'AIA'
  WHEN ${TABLE}.country = 'AQ' THEN 'ATA'
  WHEN ${TABLE}.country = 'AG' THEN 'ATG'
  WHEN ${TABLE}.country = 'AR' THEN 'ARG'
  WHEN ${TABLE}.country = 'AM' THEN 'ARM'
  WHEN ${TABLE}.country = 'AW' THEN 'ABW'
  WHEN ${TABLE}.country = 'AU' THEN 'AUS'
  WHEN ${TABLE}.country = 'AT' THEN 'AUT'
  WHEN ${TABLE}.country = 'AZ' THEN 'AZE'
  WHEN ${TABLE}.country = 'BS' THEN 'BHS'
  WHEN ${TABLE}.country = 'BH' THEN 'BHR'
  WHEN ${TABLE}.country = 'BD' THEN 'BGD'
  WHEN ${TABLE}.country = 'BB' THEN 'BRB'
  WHEN ${TABLE}.country = 'BY' THEN 'BLR'
  WHEN ${TABLE}.country = 'BE' THEN 'BEL'
  WHEN ${TABLE}.country = 'BZ' THEN 'BLZ'
  WHEN ${TABLE}.country = 'BJ' THEN 'BEN'
  WHEN ${TABLE}.country = 'BM' THEN 'BMU'
  WHEN ${TABLE}.country = 'BT' THEN 'BTN'
  WHEN ${TABLE}.country = 'BO' THEN 'BOL'
  WHEN ${TABLE}.country = 'BQ' THEN 'BES'
  WHEN ${TABLE}.country = 'BA' THEN 'BIH'
  WHEN ${TABLE}.country = 'BW' THEN 'BWA'
  WHEN ${TABLE}.country = 'BV' THEN 'BVT'
  WHEN ${TABLE}.country = 'BR' THEN 'BRA'
  WHEN ${TABLE}.country = 'IO' THEN 'IOT'
  WHEN ${TABLE}.country = 'BN' THEN 'BRN'
  WHEN ${TABLE}.country = 'BG' THEN 'BGR'
  WHEN ${TABLE}.country = 'BF' THEN 'BFA'
  WHEN ${TABLE}.country = 'BI' THEN 'BDI'
  WHEN ${TABLE}.country = 'KH' THEN 'KHM'
  WHEN ${TABLE}.country = 'CM' THEN 'CMR'
  WHEN ${TABLE}.country = 'CA' THEN 'CAN'
  WHEN ${TABLE}.country = 'CV' THEN 'CPV'
  WHEN ${TABLE}.country = 'KY' THEN 'CYM'
  WHEN ${TABLE}.country = 'CF' THEN 'CAF'
  WHEN ${TABLE}.country = 'TD' THEN 'TCD'
  WHEN ${TABLE}.country = 'CL' THEN 'CHL'
  WHEN ${TABLE}.country = 'CN' THEN 'CHN'
  WHEN ${TABLE}.country = 'CX' THEN 'CXR'
  WHEN ${TABLE}.country = 'CC' THEN 'CCK'
  WHEN ${TABLE}.country = 'CO' THEN 'COL'
  WHEN ${TABLE}.country = 'KM' THEN 'COM'
  WHEN ${TABLE}.country = 'CG' THEN 'COG'
  WHEN ${TABLE}.country = 'CD' THEN 'COD'
  WHEN ${TABLE}.country = 'CK' THEN 'COK'
  WHEN ${TABLE}.country = 'CR' THEN 'CRI'
  WHEN ${TABLE}.country = 'CI' THEN 'CIV'
  WHEN ${TABLE}.country = 'HR' THEN 'HRV'
  WHEN ${TABLE}.country = 'CU' THEN 'CUB'
  WHEN ${TABLE}.country = 'CW' THEN 'CUW'
  WHEN ${TABLE}.country = 'CY' THEN 'CYP'
  WHEN ${TABLE}.country = 'CZ' THEN 'CZE'
  WHEN ${TABLE}.country = 'DK' THEN 'DNK'
  WHEN ${TABLE}.country = 'DJ' THEN 'DJI'
  WHEN ${TABLE}.country = 'DM' THEN 'DMA'
  WHEN ${TABLE}.country = 'DO' THEN 'DOM'
  WHEN ${TABLE}.country = 'EC' THEN 'ECU'
  WHEN ${TABLE}.country = 'EG' THEN 'EGY'
  WHEN ${TABLE}.country = 'SV' THEN 'SLV'
  WHEN ${TABLE}.country = 'GQ' THEN 'GNQ'
  WHEN ${TABLE}.country = 'ER' THEN 'ERI'
  WHEN ${TABLE}.country = 'EE' THEN 'EST'
  WHEN ${TABLE}.country = 'ET' THEN 'ETH'
  WHEN ${TABLE}.country = 'FK' THEN 'FLK'
  WHEN ${TABLE}.country = 'FO' THEN 'FRO'
  WHEN ${TABLE}.country = 'FJ' THEN 'FJI'
  WHEN ${TABLE}.country = 'FI' THEN 'FIN'
  WHEN ${TABLE}.country = 'FR' THEN 'FRA'
  WHEN ${TABLE}.country = 'GF' THEN 'GUF'
  WHEN ${TABLE}.country = 'PF' THEN 'PYF'
  WHEN ${TABLE}.country = 'TF' THEN 'ATF'
  WHEN ${TABLE}.country = 'GA' THEN 'GAB'
  WHEN ${TABLE}.country = 'GM' THEN 'GMB'
  WHEN ${TABLE}.country = 'GE' THEN 'GEO'
  WHEN ${TABLE}.country = 'DE' THEN 'DEU'
  WHEN ${TABLE}.country = 'GH' THEN 'GHA'
  WHEN ${TABLE}.country = 'GI' THEN 'GIB'
  WHEN ${TABLE}.country = 'GR' THEN 'GRC'
  WHEN ${TABLE}.country = 'GL' THEN 'GRL'
  WHEN ${TABLE}.country = 'GD' THEN 'GRD'
  WHEN ${TABLE}.country = 'GP' THEN 'GLP'
  WHEN ${TABLE}.country = 'GU' THEN 'GUM'
  WHEN ${TABLE}.country = 'GT' THEN 'GTM'
  WHEN ${TABLE}.country = 'GG' THEN 'GGY'
  WHEN ${TABLE}.country = 'GN' THEN 'GIN'
  WHEN ${TABLE}.country = 'GW' THEN 'GNB'
  WHEN ${TABLE}.country = 'GY' THEN 'GUY'
  WHEN ${TABLE}.country = 'HT' THEN 'HTI'
  WHEN ${TABLE}.country = 'HM' THEN 'HMD'
  WHEN ${TABLE}.country = 'VA' THEN 'VAT'
  WHEN ${TABLE}.country = 'HN' THEN 'HND'
  WHEN ${TABLE}.country = 'HK' THEN 'HKG'
  WHEN ${TABLE}.country = 'HU' THEN 'HUN'
  WHEN ${TABLE}.country = 'IS' THEN 'ISL'
  WHEN ${TABLE}.country = 'IN' THEN 'IND'
  WHEN ${TABLE}.country = 'ID' THEN 'IDN'
  WHEN ${TABLE}.country = 'IR' THEN 'IRN'
  WHEN ${TABLE}.country = 'IQ' THEN 'IRQ'
  WHEN ${TABLE}.country = 'IE' THEN 'IRL'
  WHEN ${TABLE}.country = 'IM' THEN 'IMN'
  WHEN ${TABLE}.country = 'IL' THEN 'ISR'
  WHEN ${TABLE}.country = 'IT' THEN 'ITA'
  WHEN ${TABLE}.country = 'JM' THEN 'JAM'
  WHEN ${TABLE}.country = 'JP' THEN 'JPN'
  WHEN ${TABLE}.country = 'JE' THEN 'JEY'
  WHEN ${TABLE}.country = 'JO' THEN 'JOR'
  WHEN ${TABLE}.country = 'KZ' THEN 'KAZ'
  WHEN ${TABLE}.country = 'KE' THEN 'KEN'
  WHEN ${TABLE}.country = 'KI' THEN 'KIR'
  WHEN ${TABLE}.country = 'KP' THEN 'PRK'
  WHEN ${TABLE}.country = 'KR' THEN 'KOR'
  WHEN ${TABLE}.country = 'KW' THEN 'KWT'
  WHEN ${TABLE}.country = 'KG' THEN 'KGZ'
  WHEN ${TABLE}.country = 'LA' THEN 'LAO'
  WHEN ${TABLE}.country = 'LV' THEN 'LVA'
  WHEN ${TABLE}.country = 'LB' THEN 'LBN'
  WHEN ${TABLE}.country = 'LS' THEN 'LSO'
  WHEN ${TABLE}.country = 'LR' THEN 'LBR'
  WHEN ${TABLE}.country = 'LY' THEN 'LBY'
  WHEN ${TABLE}.country = 'LI' THEN 'LIE'
  WHEN ${TABLE}.country = 'LT' THEN 'LTU'
  WHEN ${TABLE}.country = 'LU' THEN 'LUX'
  WHEN ${TABLE}.country = 'MO' THEN 'MAC'
  WHEN ${TABLE}.country = 'MK' THEN 'MKD'
  WHEN ${TABLE}.country = 'MG' THEN 'MDG'
  WHEN ${TABLE}.country = 'MW' THEN 'MWI'
  WHEN ${TABLE}.country = 'MY' THEN 'MYS'
  WHEN ${TABLE}.country = 'MV' THEN 'MDV'
  WHEN ${TABLE}.country = 'ML' THEN 'MLI'
  WHEN ${TABLE}.country = 'MT' THEN 'MLT'
  WHEN ${TABLE}.country = 'MH' THEN 'MHL'
  WHEN ${TABLE}.country = 'MQ' THEN 'MTQ'
  WHEN ${TABLE}.country = 'MR' THEN 'MRT'
  WHEN ${TABLE}.country = 'MU' THEN 'MUS'
  WHEN ${TABLE}.country = 'YT' THEN 'MYT'
  WHEN ${TABLE}.country = 'MX' THEN 'MEX'
  WHEN ${TABLE}.country = 'FM' THEN 'FSM'
  WHEN ${TABLE}.country = 'MD' THEN 'MDA'
  WHEN ${TABLE}.country = 'MC' THEN 'MCO'
  WHEN ${TABLE}.country = 'MN' THEN 'MNG'
  WHEN ${TABLE}.country = 'ME' THEN 'MNE'
  WHEN ${TABLE}.country = 'MS' THEN 'MSR'
  WHEN ${TABLE}.country = 'MA' THEN 'MAR'
  WHEN ${TABLE}.country = 'MZ' THEN 'MOZ'
  WHEN ${TABLE}.country = 'MM' THEN 'MMR'
  WHEN ${TABLE}.country = 'NA' THEN 'NAM'
  WHEN ${TABLE}.country = 'NR' THEN 'NRU'
  WHEN ${TABLE}.country = 'NP' THEN 'NPL'
  WHEN ${TABLE}.country = 'NL' THEN 'NLD'
  WHEN ${TABLE}.country = 'NC' THEN 'NCL'
  WHEN ${TABLE}.country = 'NZ' THEN 'NZL'
  WHEN ${TABLE}.country = 'NI' THEN 'NIC'
  WHEN ${TABLE}.country = 'NE' THEN 'NER'
  WHEN ${TABLE}.country = 'NG' THEN 'NGA'
  WHEN ${TABLE}.country = 'NU' THEN 'NIU'
  WHEN ${TABLE}.country = 'NF' THEN 'NFK'
  WHEN ${TABLE}.country = 'MP' THEN 'MNP'
  WHEN ${TABLE}.country = 'NO' THEN 'NOR'
  WHEN ${TABLE}.country = 'OM' THEN 'OMN'
  WHEN ${TABLE}.country = 'PK' THEN 'PAK'
  WHEN ${TABLE}.country = 'PW' THEN 'PLW'
  WHEN ${TABLE}.country = 'PS' THEN 'PSE'
  WHEN ${TABLE}.country = 'PA' THEN 'PAN'
  WHEN ${TABLE}.country = 'PG' THEN 'PNG'
  WHEN ${TABLE}.country = 'PY' THEN 'PRY'
  WHEN ${TABLE}.country = 'PE' THEN 'PER'
  WHEN ${TABLE}.country = 'PH' THEN 'PHL'
  WHEN ${TABLE}.country = 'PN' THEN 'PCN'
  WHEN ${TABLE}.country = 'PL' THEN 'POL'
  WHEN ${TABLE}.country = 'PT' THEN 'PRT'
  WHEN ${TABLE}.country = 'PR' THEN 'PRI'
  WHEN ${TABLE}.country = 'QA' THEN 'QAT'
  WHEN ${TABLE}.country = 'RE' THEN 'REU'
  WHEN ${TABLE}.country = 'RO' THEN 'ROU'
  WHEN ${TABLE}.country = 'RU' THEN 'RUS'
  WHEN ${TABLE}.country = 'RW' THEN 'RWA'
  WHEN ${TABLE}.country = 'BL' THEN 'BLM'
  WHEN ${TABLE}.country = 'SH' THEN 'SHN'
  WHEN ${TABLE}.country = 'KN' THEN 'KNA'
  WHEN ${TABLE}.country = 'LC' THEN 'LCA'
  WHEN ${TABLE}.country = 'MF' THEN 'MAF'
  WHEN ${TABLE}.country = 'PM' THEN 'SPM'
  WHEN ${TABLE}.country = 'VC' THEN 'VCT'
  WHEN ${TABLE}.country = 'WS' THEN 'WSM'
  WHEN ${TABLE}.country = 'SM' THEN 'SMR'
  WHEN ${TABLE}.country = 'ST' THEN 'STP'
  WHEN ${TABLE}.country = 'SA' THEN 'SAU'
  WHEN ${TABLE}.country = 'SN' THEN 'SEN'
  WHEN ${TABLE}.country = 'RS' THEN 'SRB'
  WHEN ${TABLE}.country = 'SC' THEN 'SYC'
  WHEN ${TABLE}.country = 'SL' THEN 'SLE'
  WHEN ${TABLE}.country = 'SG' THEN 'SGP'
  WHEN ${TABLE}.country = 'SX' THEN 'SXM'
  WHEN ${TABLE}.country = 'SK' THEN 'SVK'
  WHEN ${TABLE}.country = 'SI' THEN 'SVN'
  WHEN ${TABLE}.country = 'SB' THEN 'SLB'
  WHEN ${TABLE}.country = 'SO' THEN 'SOM'
  WHEN ${TABLE}.country = 'ZA' THEN 'ZAF'
  WHEN ${TABLE}.country = 'GS' THEN 'SGS'
  WHEN ${TABLE}.country = 'SS' THEN 'SSD'
  WHEN ${TABLE}.country = 'ES' THEN 'ESP'
  WHEN ${TABLE}.country = 'LK' THEN 'LKA'
  WHEN ${TABLE}.country = 'SD' THEN 'SDN'
  WHEN ${TABLE}.country = 'SR' THEN 'SUR'
  WHEN ${TABLE}.country = 'SJ' THEN 'SJM'
  WHEN ${TABLE}.country = 'SZ' THEN 'SWZ'
  WHEN ${TABLE}.country = 'SE' THEN 'SWE'
  WHEN ${TABLE}.country = 'CH' THEN 'CHE'
  WHEN ${TABLE}.country = 'SY' THEN 'SYR'
  WHEN ${TABLE}.country = 'TW' THEN 'TWN'
  WHEN ${TABLE}.country = 'TJ' THEN 'TJK'
  WHEN ${TABLE}.country = 'TZ' THEN 'TZA'
  WHEN ${TABLE}.country = 'TH' THEN 'THA'
  WHEN ${TABLE}.country = 'TL' THEN 'TLS'
  WHEN ${TABLE}.country = 'TG' THEN 'TGO'
  WHEN ${TABLE}.country = 'TK' THEN 'TKL'
  WHEN ${TABLE}.country = 'TO' THEN 'TON'
  WHEN ${TABLE}.country = 'TT' THEN 'TTO'
  WHEN ${TABLE}.country = 'TN' THEN 'TUN'
  WHEN ${TABLE}.country = 'TR' THEN 'TUR'
  WHEN ${TABLE}.country = 'TM' THEN 'TKM'
  WHEN ${TABLE}.country = 'TC' THEN 'TCA'
  WHEN ${TABLE}.country = 'TV' THEN 'TUV'
  WHEN ${TABLE}.country = 'UG' THEN 'UGA'
  WHEN ${TABLE}.country = 'UA' THEN 'UKR'
  WHEN ${TABLE}.country = 'AE' THEN 'ARE'
  WHEN ${TABLE}.country = 'GB' THEN 'GBR'
  WHEN ${TABLE}.country = 'US' THEN 'USA'
  WHEN ${TABLE}.country = 'UM' THEN 'UMI'
  WHEN ${TABLE}.country = 'UY' THEN 'URY'
  WHEN ${TABLE}.country = 'UZ' THEN 'UZB'
  WHEN ${TABLE}.country = 'VU' THEN 'VUT'
  WHEN ${TABLE}.country = 'VE' THEN 'VEN'
  WHEN ${TABLE}.country = 'VN' THEN 'VNM'
  WHEN ${TABLE}.country = 'VG' THEN 'VGB'
  WHEN ${TABLE}.country = 'VI' THEN 'VIR'
  WHEN ${TABLE}.country = 'WF' THEN 'WLF'
  WHEN ${TABLE}.country = 'EH' THEN 'ESH'
  WHEN ${TABLE}.country = 'YE' THEN 'YEM'
  WHEN ${TABLE}.country = 'ZM' THEN 'ZMB'
  WHEN ${TABLE}.country = 'ZW' THEN 'ZWE'
ELSE NULL
END
  - dimension: customer_id
    type: int
    sql: ${TABLE}.customer_id
  - dimension: customer_site_id
    type: int
    hidden: true
    sql: ${TABLE}.customer_site_id
  - dimension: dma_code
    type: int
    hidden: true
    sql: ${TABLE}.dma_code
  - dimension: engagement_score
    type: int
    sql: ${TABLE}.engagement_score
  - dimension: identifier
    sql: ${TABLE}.identifier
  - dimension: java_enabled
    type: yesno
    sql: ${TABLE}.java_enabled
  - dimension: latitude
    sql: ${TABLE}.latitude
  - dimension: longitude
    sql: ${TABLE}.longitude
  - dimension: number_of_page_views
    type: int
    sql: ${TABLE}.number_of_page_views
  - dimension: operating_system
    sql: ${TABLE}.operating_system
  - dimension: person_id
    type: int
    sql: ${TABLE}.person_id
  - dimension: person_identifier_id
    type: int
    hidden: true
    sql: ${TABLE}.person_identifier_id
  - dimension: platform
    sql: ${TABLE}.platform
  - dimension: postal_code
    sql: ${TABLE}.postal_code
  - dimension: referrer
    sql: ${TABLE}.referrer
  - dimension: referrer_domain
    sql: ${TABLE}.referrer_domain
  - dimension: region
    sql: ${TABLE}.region
  - dimension: search_engine
    sql: ${TABLE}.search_engine
  - dimension: search_terms
    sql: ${TABLE}.search_terms
  - dimension: touch_duration
    type: int
    sql: ${TABLE}.touch_duration
  - dimension: url
    sql: ${TABLE}.url
  - dimension: url_domain
    sql: ${TABLE}.url_domain
  - dimension: user_agent_string
    sql: ${TABLE}.user_agent_string
  - dimension: utm_content
    sql: ${TABLE}.utm_content
  - dimension: utm_medium
    sql: ${TABLE}.utm_medium
  - dimension: utm_name
    sql: ${TABLE}.utm_name
  - dimension: utm_referrer
    sql: ${TABLE}.utm_referrer
  - dimension: utm_terms
    sql: ${TABLE}.utm_terms
  - dimension: visitor_ip
    sql: ${TABLE}.visitor_ip
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_modified_date
  - dimension_group: touch
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.touch_date
  - measure: count
    type: count
    drill_fields:
    - id
    - utm_name
    - person.id
    - event.count
    - staged_event.count
  - measure: average_engagement_score
    type: avg
    value_format: '#.00'
    sql: ${engagement_score}