title: BigQuery data not matching Firebase Analytics
body: <p>I'm currently trying to query BigQuery to grab the analytics data that Firebase is exporting to it. I'm able to successfully query the tables and get data back but when I run my query, the returned number does not match what Firebase is giving me for that particular day. </p>
  
  <p>Right now I'm just trying to grab all first_open events for a single day, I hope to make this so I can tally up the month and week also. </p>
  
  <pre><code>SELECT count(FORMAT_TIMESTAMP('%m/%d/%Y', TIMESTAMP_MICROS(user_dim.first_open_timestamp_micros))) as dateAccessed 
  FROM `table_here` 
  WHERE FORMAT_TIMESTAMP('%m/%d/%Y', TIMESTAMP_MICROS(user_dim.first_open_timestamp_micros)) = '01/05/2017'
  </code></pre>
  
  <p>The above query returns <code>88</code> where in my firebase console, the <code>first_open</code> event only has a count of <code>14</code>. I'm not familiar with how the app that sends the events works. </p>
  
  <p>Running the query on the <code>intraday</code> table gives me <code>11</code> events, where in Firebase it's only reading a single event being tracked today. </p>
  
  <p>Any help with this would be greatly appreciated, thanks!</p>