WITH

period AS
(SELECT "20180401" as start, "20180431" as finish),

ses AS (
SELECT clientId, geoNetwork.country
FROM `dokdbroker.OWOXBI_Streaming.session_streaming_*`
WHERE _TABLE_SUFFIX BETWEEN (SELECT start FROM period) AND (SELECT finish FROM period)
  AND clientId IS NOT null
)

SELECT
  *,
  (SELECT LPAD(start, 6) FROM period) as month
FROM (
  SELECT
    COUNT (DISTINCT clientId),
    IF (clientId IN (SELECT clientId FROM ses WHERE country = "Ukraine")
      OR clientId NOT IN (SELECT clientId FROM ses), "Ukraine or NA", "abroad") AS country
  FROM
    `dokdbroker.OWOXBI_Streaming.streaming_*`
  WHERE
    _TABLE_SUFFIX BETWEEN (SELECT start FROM period) AND (SELECT finish FROM period)
    AND (SELECT value FROM UNNEST(customDimensions) WHERE index = 3) IN ("Value", "Action")
  GROUP BY
    country
)
-- WHERE NOT EXISTS
--   (SELECT 1 FROM download.ValueClients_KPI
--    WHERE month = (SELECT LPAD(start, 6) FROM period))