Schema for advanced viewability users

ActiveView

adh.google_ads_active_views
query_id record
query_id.time_usec int Time in microseconds.
query_id.server_ip int The processing server.
query_id.process_id int The processing process.
view_id record
view_id.time_usec int Time in microseconds.
view_id.server_ip int The processing server.
view_id.process_id int The processing process.
view_type string Type of view (delayed or ActiveView).
active_view record
active_view.view_state int Whether the view is valid, invalid, measurable or viewed.
active_view.time_until_view_msec int Time from page load until creative was viewed, in milliseconds.
active_view.max_consecutive_view_msec int Longest time video was viewed, in milliseconds.
active_view.cumulative_view_msec int Total cumulative time video was viewed, in milliseconds.
active_view.max_onscreen_pct int Max percentage video was ever onscreen.
active_view.audio_volume float Player volume at each video conversion event.
active_view.audible_since_start boolean True if the ad was audible from start.
active_view.audible_time int Longest time video was audible, in seconds.
active_view.total_onscreen_time int How long in total the impression is viewed (in milliseconds) for at least x of its area. Can be one of:
  • View_time_msec_pct100
  • View_time_msec_pct75
  • View_time_msec_pct50
  • View_time_msec_pct30
  • View_time_msec_pct0
active_view.max_consecutive_onscreen_time int The maximal consecutive time on-screen (in milliseconds) for at least x of area. Can be one of:
  • View_time_msec_pct100
  • View_time_msec_pct75
  • View_time_msec_pct50
  • View_time_msec_pct30
  • View_time_msec_pct0
active_view.onscreen_coverage float Onscreen coverage of each video (0 to 1.0).
active_view.active_view_data int Numerical value of active view data.
active_view.activeview_cost float Advertiser cost when impression becomes viewable (only applies to Cost Per Mille Active View [CPMAV] bidding)
active_view.cost_usd
active_view.request_properties A bit-mask containing technical details about the impressions related to viewability measurement.
active_view.gm_measurable_version If this impression is measurable and if the value of this field is >= 2, then this impression is measurable for the groupm viewability criteria.
active_view.cumulative_state int Cumulative state of video ad at the time the event is sent.
active_view.user_id string Raw user ID.
active_view.is_in_rdid_project boolean True if this event is also in the _rdid table. Used for deduplication of events.

Conversions

adh.google_ads_active_views
active_view record
active_view.view_state int Whether the view is valid, invalid, measurable or viewed.
active_view.audio_volume float Player volume at each video conversion event.
active_view.onscreen_coverage float Onscreen coverage of each video (0 to 1.0).
active_view.active_view_data int Numerical value of active view data.
active_view.request_properties A bit-mask containing technical details about the impressions related to viewability measurement.
active_view.gm_measurable_version If this impression is measurable and if the value of this field is >= 2, then this impression is measurable for the groupm viewability criteria.
active_view.cumulative_state int Cumulative state of video ad at the time the event is sent.

Supported metrics

As of July, 2019, quartile metrics are unsupported. The outage is temporary and Ads Data Hub will resume support for these metrics by Q4 2019. Although the use of these metrics won't cause your queries to fail, it will change their final value, as the signals used to calculate these metrics are reported as null.