title: Results within Bigquery do not remain the same as in GA4
body: <p>I'm inside BigQuery performing the query below to see how many users I had from August 1st to August 14th, but the number is not matching what GA4 presents me.</p>
  <pre class="lang-sql prettyprint-override"><code>with event AS (
    SELECT
      user_id,
      event_name,
      PARSE_DATE('%Y%m%d',
        event_date) AS event_date,
      TIMESTAMP_MICROS(event_timestamp) AS event_timestamp,
      ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY TIMESTAMP_MICROS(event_timestamp) DESC) AS rn,
      
    FROM
      `events_*`
    WHERE
     event_name= 'push_received')
     
  SELECT  COUNT ( DISTINCT user_id)
  FROM
    event
  WHERE
  event_date &gt;= '2022-08-01'
  </code></pre>
  <p>Resultado do GA4</p>
  <p><a href="https://i.stack.imgur.com/ZvFPY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZvFPY.png" alt="Result GA4" /></a></p>
  <p>Result BQ = 37024</p>
  <p><a href="https://i.stack.imgur.com/glhOn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/glhOn.png" alt="enter image description here" /></a></p>