问android电商应用的弹跳率

EN

SELECT
  *
FROM (
  SELECT
    SUM(screenviews) Totals,
    date date,
    Platform,
  FROM (
    SELECT
      COUNT(hits.type) AS screenviews,
      DATE(date) AS date,
      device.operatingSystem Platform,
    FROM
      TABLE_DATE_RANGE([118356700.ga_sessions_],TIMESTAMP('2017-01-01'), TIMESTAMP (CURRENT_DATE()))
    WHERE
      hits.type IN ("APPVIEW")
      AND hits.appInfo.ScreenName IN ( "Home Storefront Screen")
      AND device.operatingSystem <> "BlackBerry"
    GROUP BY
      2,
      3 )
  GROUP BY
    2,
    3 ),
  (
  SELECT
    SUM(screenviews) Bounced,
    date1 date,
    Platform,
  FROM (
    SELECT
      COUNT(hits.type) AS screenviews,
      DATE(date) AS date1,
      device.operatingSystem Platform,
    FROM
      TABLE_DATE_RANGE([118356700.ga_sessions_],TIMESTAMP('2017-01-01'), TIMESTAMP (CURRENT_DATE()))
    WHERE
      hits.type IN ("APPVIEW")
      AND hits.appInfo.LAndingScreenName = "Home Storefront Screen"
      AND hits.appInfo.LAndingScreenName = hits.appInfo.ExitScreenName
      AND totals.screenviews = 1
      AND device.operatingSystem <> "BlackBerry"
      AND hits.isEntrance = TRUE
    GROUP BY
      2,
      3 )
  GROUP BY
    2,
    3)