Ad Event

view: ad_event {
  sql_table_name: {% table_date_range date_filter sanitized_table_ad_event %} ;;

  dimension: head_user_id {
    type: string
    sql: ${TABLE}.headUserId ;;
  }

  dimension: head_xid {
    type: string
    sql: ${TABLE}.headXId ;;
  }

  dimension: head_user_ip {
    type: string
    sql: ${TABLE}.headUserIP ;;
  }

  dimension: head_request_id {
    type: string
    sql: ${TABLE}.headRequestId ;;
  }

  dimension: associated_advertiser_id {
    type: int
    sql: ${TABLE}.headAdvertiserId ;;
  }

  dimension: associated_campaign_id {
    type: int
    sql: ${TABLE}.headCampaignId ;;
  }

  dimension: associated_campaign_slot_id {
    type: int
    sql: ${TABLE}.headCampaignSlotId ;;
  }

  dimension: head_creative_id {
    type: string
    sql: ${TABLE}.headCreativeId ;;
  }

  dimension: event_source {
    type: string
    sql: ${TABLE}.eventSource ;;
  }

  dimension: event_type {
    type: string
    sql: ${TABLE}.eventType ;;
  }

  dimension: event_ad_requested {
    type: yesno
    sql: ${TABLE}.eventAdRequested ;;
  }

  dimension: event_ad_responded {
    type: yesno
    sql: ${TABLE}.eventAdResponded ;;
  }

  dimension: event_ad_viewed {
    type: yesno
    sql: ${TABLE}.eventAdViewed ;;
  }

  dimension: event_frame_viewed {
    type: yesno
    sql: ${TABLE}.eventFrameViewed ;;
  }

  dimension: event_frame_clicked {
    type: yesno
    sql: ${TABLE}.eventFrameClicked ;;
  }

  dimension: event_frame_engaged {
    type: yesno
    sql: ${TABLE}.eventFrameEngaged ;;
  }

  dimension: offer_id {
    type: int
    sql: ${TABLE}.offerId ;;
  }

  dimension: offer_position {
    type: int
    sql: ${TABLE}.offerPosition ;;
  }

  dimension: offer_query {
    type: string
    sql: ${TABLE}.offerQuery ;;
  }

  dimension: offer_total_number {
    type: int
    sql: ${TABLE}.offerTotalNumber ;;
  }

  dimension: offer_link_type {
    type: string
    sql: ${TABLE}.offerLinkType ;;
  }

  dimension: offer_link_area {
    type: string
    sql: ${TABLE}.offerLinkArea ;;
  }

  dimension: offer_user_intent {
    type: string
    sql: ${TABLE}.offerUserIntent ;;
  }

  dimension: media_dsp_id {
    type: string
    sql: ${TABLE}.mediaDspId ;;
  }

  dimension: media_dmp_ids {
    type: string
    sql: ${TABLE}.mediaDmpIds ;;
  }

  dimension: media_user_id {
    type: string
    sql: ${TABLE}.mediaUserId ;;
  }

  dimension: media_device_id {
    type: string
    sql: ${TABLE}.mediaDeviceId ;;
  }

  dimension: media_device_type {
    type: string
    sql: ${TABLE}.mediaDeviceType ;;
  }

  dimension: media_auction_id {
    type: string
    sql: ${TABLE}.mediaAuctionId ;;
  }

  dimension: media_paid_price {
    type: number
    sql: ${TABLE}.mediaPaidPrice ;;
  }

  dimension: media_bid_price {
    type: string
    sql: ${TABLE}.mediaBidPrice ;;
  }

  dimension: media_bid_strategy {
    type: string
    sql: ${TABLE}.mediaBidStrategy ;;
  }

  dimension: media_exchange_id {
    type: string
    sql: ${TABLE}.mediaExchangeId ;;
  }

  dimension: media_publisher_id {
    type: string
    sql: ${TABLE}.mediaPublisherId ;;
  }

  dimension: media_site_id {
    type: string
    sql: ${TABLE}.mediaSiteId ;;
  }

  dimension: media_inventory_class {
    type: string
    sql: ${TABLE}.mediaInventoryClass ;;
  }

  dimension: media_domain {
    type: string
    sql: ${TABLE}.mediaDomain ;;
  }

  dimension: media_domain_child {
    type: string
    sql: ${TABLE}.mediaDomainChild ;;
  }

  dimension: media_request_referer {
    type: string
    sql: ${TABLE}.mediaRequestReferer ;;
  }

  dimension: media_referer {
    type: string
    sql: ${TABLE}.mediaReferer ;;
  }

  dimension: related_related_media_advertiser_id {
    type: string
    sql: ${TABLE}.mediaAdvertiserId ;;
  }

  dimension: media_line_item_id {
    type: string
    sql: ${TABLE}.mediaLineItemId ;;
  }

  dimension: related_media_campaign_id {
    type: string
    sql: ${TABLE}.mediaCampaignId ;;
  }

  dimension: related_media_advertiser_freq {
    type: string
    sql: ${TABLE}.mediaAdvertiserFreq ;;
  }

  dimension: media_session_freq {
    type: int
    sql: ${TABLE}.mediaSessionFreq ;;
  }

  dimension: related_ad_server_campaign_id {
    type: string
    sql: ${TABLE}.adServerCampaignId ;;
  }

  dimension: ad_server_placement_id {
    type: string
    sql: ${TABLE}.adServerPlacementId ;;
  }

  dimension: ad_server_site_id {
    type: string
    sql: ${TABLE}.adServerSiteId ;;
  }

  dimension: geo_country {
    type: string
    sql: ${TABLE}.geoCountry ;;
  }

  dimension: geo_region {
    type: string
    sql: ${TABLE}.geoRegion ;;
  }

  dimension: geo_dma {
    type: string
    sql: ${TABLE}.geoDma ;;
  }

  dimension: geo_city {
    type: string
    sql: ${TABLE}.geoCity ;;
  }

  dimension: geo_postal_code {
    type: string
    sql: ${TABLE}.geoPostalCode ;;
  }

  dimension: geo_latitude {
    type: number
    sql: ${TABLE}.geoLatitude ;;
  }

  dimension: geo_longitude {
    type: number
    sql: ${TABLE}.geoLongitude ;;
  }

  dimension: device_os {
    type: string
    sql: ${TABLE}.deviceOs ;;
  }

  dimension: device_os_version {
    type: string
    sql: ${TABLE}.deviceOsVersion ;;
  }

  dimension: device_browser {
    type: string
    sql: ${TABLE}.deviceBrowser ;;
  }

  dimension: device_browser_version {
    type: string
    sql: ${TABLE}.deviceBrowserVersion ;;
  }

  dimension: device_user_agent {
    type: string
    sql: ${TABLE}.deviceUserAgent ;;
  }

  dimension: timestamp_local {
    type: string
    sql: ${TABLE}.timestampLocal ;;
  }

  dimension: user_meta_keys {
    type: string
    sql: ${TABLE}.userMetaKeys ;;
  }

  dimension: user_segment {
    type: string
    sql: ${TABLE}.userSegment ;;
  }

  dimension: user_request_parameters {
    type: string
    sql: ${TABLE}.userRequestParameters ;;
  }

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}

- view: ad_event
  sql_table_name: '{% table_date_range date_filter sanitized_table_ad_event %}'
  fields:
  - dimension: head_user_id
    type: string
    sql: ${TABLE}.headUserId
  - dimension: head_xid
    type: string
    sql: ${TABLE}.headXId
  - dimension: head_user_ip
    type: string
    sql: ${TABLE}.headUserIP
  - dimension: head_request_id
    type: string
    sql: ${TABLE}.headRequestId
  - dimension: associated_advertiser_id
    type: int
    sql: ${TABLE}.headAdvertiserId
  - dimension: associated_campaign_id
    type: int
    sql: ${TABLE}.headCampaignId
  - dimension: associated_campaign_slot_id
    type: int
    sql: ${TABLE}.headCampaignSlotId
  - dimension: head_creative_id
    type: string
    sql: ${TABLE}.headCreativeId
  - dimension: event_source
    type: string
    sql: ${TABLE}.eventSource
  - dimension: event_type
    type: string
    sql: ${TABLE}.eventType
  - dimension: event_ad_requested
    type: yesno
    sql: ${TABLE}.eventAdRequested
  - dimension: event_ad_responded
    type: yesno
    sql: ${TABLE}.eventAdResponded
  - dimension: event_ad_viewed
    type: yesno
    sql: ${TABLE}.eventAdViewed
  - dimension: event_frame_viewed
    type: yesno
    sql: ${TABLE}.eventFrameViewed
  - dimension: event_frame_clicked
    type: yesno
    sql: ${TABLE}.eventFrameClicked
  - dimension: event_frame_engaged
    type: yesno
    sql: ${TABLE}.eventFrameEngaged
  - dimension: offer_id
    type: int
    sql: ${TABLE}.offerId
  - dimension: offer_position
    type: int
    sql: ${TABLE}.offerPosition
  - dimension: offer_query
    type: string
    sql: ${TABLE}.offerQuery
  - dimension: offer_total_number
    type: int
    sql: ${TABLE}.offerTotalNumber
  - dimension: offer_link_type
    type: string
    sql: ${TABLE}.offerLinkType
  - dimension: offer_link_area
    type: string
    sql: ${TABLE}.offerLinkArea
  - dimension: offer_user_intent
    type: string
    sql: ${TABLE}.offerUserIntent
  - dimension: media_dsp_id
    type: string
    sql: ${TABLE}.mediaDspId
  - dimension: media_dmp_ids
    type: string
    sql: ${TABLE}.mediaDmpIds
  - dimension: media_user_id
    type: string
    sql: ${TABLE}.mediaUserId
  - dimension: media_device_id
    type: string
    sql: ${TABLE}.mediaDeviceId
  - dimension: media_device_type
    type: string
    sql: ${TABLE}.mediaDeviceType
  - dimension: media_auction_id
    type: string
    sql: ${TABLE}.mediaAuctionId
  - dimension: media_paid_price
    type: number
    sql: ${TABLE}.mediaPaidPrice
  - dimension: media_bid_price
    type: string
    sql: ${TABLE}.mediaBidPrice
  - dimension: media_bid_strategy
    type: string
    sql: ${TABLE}.mediaBidStrategy
  - dimension: media_exchange_id
    type: string
    sql: ${TABLE}.mediaExchangeId
  - dimension: media_publisher_id
    type: string
    sql: ${TABLE}.mediaPublisherId
  - dimension: media_site_id
    type: string
    sql: ${TABLE}.mediaSiteId
  - dimension: media_inventory_class
    type: string
    sql: ${TABLE}.mediaInventoryClass
  - dimension: media_domain
    type: string
    sql: ${TABLE}.mediaDomain
  - dimension: media_domain_child
    type: string
    sql: ${TABLE}.mediaDomainChild
  - dimension: media_request_referer
    type: string
    sql: ${TABLE}.mediaRequestReferer
  - dimension: media_referer
    type: string
    sql: ${TABLE}.mediaReferer
  - dimension: related_related_media_advertiser_id
    type: string
    sql: ${TABLE}.mediaAdvertiserId
  - dimension: media_line_item_id
    type: string
    sql: ${TABLE}.mediaLineItemId
  - dimension: related_media_campaign_id
    type: string
    sql: ${TABLE}.mediaCampaignId
  - dimension: related_media_advertiser_freq
    type: string
    sql: ${TABLE}.mediaAdvertiserFreq
  - dimension: media_session_freq
    type: int
    sql: ${TABLE}.mediaSessionFreq
  - dimension: related_ad_server_campaign_id
    type: string
    sql: ${TABLE}.adServerCampaignId
  - dimension: ad_server_placement_id
    type: string
    sql: ${TABLE}.adServerPlacementId
  - dimension: ad_server_site_id
    type: string
    sql: ${TABLE}.adServerSiteId
  - dimension: geo_country
    type: string
    sql: ${TABLE}.geoCountry
  - dimension: geo_region
    type: string
    sql: ${TABLE}.geoRegion
  - dimension: geo_dma
    type: string
    sql: ${TABLE}.geoDma
  - dimension: geo_city
    type: string
    sql: ${TABLE}.geoCity
  - dimension: geo_postal_code
    type: string
    sql: ${TABLE}.geoPostalCode
  - dimension: geo_latitude
    type: number
    sql: ${TABLE}.geoLatitude
  - dimension: geo_longitude
    type: number
    sql: ${TABLE}.geoLongitude
  - dimension: device_os
    type: string
    sql: ${TABLE}.deviceOs
  - dimension: device_os_version
    type: string
    sql: ${TABLE}.deviceOsVersion
  - dimension: device_browser
    type: string
    sql: ${TABLE}.deviceBrowser
  - dimension: device_browser_version
    type: string
    sql: ${TABLE}.deviceBrowserVersion
  - dimension: device_user_agent
    type: string
    sql: ${TABLE}.deviceUserAgent
  - dimension: timestamp_local
    type: string
    sql: ${TABLE}.timestampLocal
  - dimension: user_meta_keys
    type: string
    sql: ${TABLE}.userMetaKeys
  - dimension: user_segment
    type: string
    sql: ${TABLE}.userSegment
  - dimension: user_request_parameters
    type: string
    sql: ${TABLE}.userRequestParameters
  - dimension_group: timestamp_server
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.timestampServer
  - measure: count
    type: count
    drill_fields:
    - detail*