SHARE
TWEET

Untitled

a guest Sep 19th, 2019 109 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.   -- The device category (mobile, tablet, desktop)
  3.   device.category,
  4.   -- The device brand name
  5.   device.mobile_brand_name,
  6.   -- The device model name
  7.   device.mobile_model_name,
  8.   -- The device marketing name
  9.   device.mobile_marketing_name,
  10.   -- The device model information retrieved directly from the operating system
  11.   device.mobile_os_hardware_model,
  12.   -- The operating system of the device
  13.   device.operating_system,
  14.   -- The OS version
  15.   device.operating_system_version,
  16.   -- IDFV (present only if IDFA is not collected)
  17.   device.vendor_id,
  18.   -- Advertising ID/IDFA
  19.   device.advertising_id,
  20.   -- The OS language
  21.   device.language,
  22.   -- The device's Limit Ad Tracking setting
  23.   device.is_limited_ad_tracking,
  24.   -- The offset from GMT in seconds
  25.   device.time_zone_offset_seconds,
  26.   -- The browser in which the user viewed content
  27.   device.browser,
  28.   -- The version of the browser in which the user viewed content
  29.   device.browser_version,
  30.   -- The browser in which the user viewed content
  31.   device.web_info.browser AS web_browser,
  32.   -- The version of the browser in which the user viewed content
  33.   device.web_info.browser_version AS web_browser_version,
  34.   -- The hostname associated with the logged event
  35.   device.web_info.hostname
  36. FROM
  37.   `firebase-orangevalley-web-app.analytics_206829311.events_*`
  38. WHERE
  39.   _table_suffix BETWEEN '20190806'
  40.   AND FORMAT_DATE('%Y%m%d',DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY))
  41. GROUP BY
  42.   1,
  43.   2,
  44.   3,
  45.   4,
  46.   5,
  47.   6,
  48.   7,
  49.   8,
  50.   9,
  51.   10,
  52.   11,
  53.   12,
  54.   13,
  55.   14,
  56.   15,
  57.   16,
  58.   17
  59. LIMIT
  60.   10
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top