This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Missing Data in BigQuery vs GA

Posted on 11-13-2024 02:16 PM
kllecher
New Member
Reply posted on --/--/---- --:-- AM

I am pulling user data from a google analytics instance into a data visualization tool (Tableau) using a big query connector.  However, I have noticed the data is incorrect.  When I compare user exports directly from GA (users, sessions, etc.) and the BigQuery data set Tableau accesses, I see users listed in the GA data that aren't in BQ when comparing the same time frame in both systems. 

Example, GA tells me that for a specific user set, 15 people logged in during October. But dashboarding driven from BQ is telling me only 9 users logged in during the same time.  

I do not know how to troubleshoot the missing data. What resources can I use to walk through this issue? Any suggestions?

0 1 195
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
marckevin
Staff
Reply posted on --/--/---- --:-- AM

Hi @kllecher,

Welcome to Google Cloud Community!

Discrepancies between Google Analytics(GA) and BigQuery exports can stem from various reasons. Here are some potential causes and suggestions that may help solve the discrepancies between GA and BigQuery:

  • Date and Time: Ensure that the time zones in GA and BigQuery are the same when exporting data. Mismatched time zones or changes in the reporting time zone can lead to missing data in the exports. Also, make sure the time ranges while exporting in both GA and BigQuery are aligned. Misalignment in time can cause discrepancies in the data.
  • Configuration: Check the export configuration to ensure it is properly set up and verify if there are any misconfigurations regarding the range to which your data was exported in BigQuery. Any misalignment during the export period can lead to missing data.
  • Billing: Any changes on the billing account can affect the exported data during the period of export. And those missing data cannot be re-exported.
  • BigQuery Export limit: Ensure exporting to BigQuery does not exceed the limit of quota set on your account.
  • Dimensions and Metrics: It is also important to note that some metrics between GA and BigQuery may use different counters. Ensure that all metrics are aligned, and check if any fields have changed during the export period.

If the issue persists, I recommend reaching out to Google Cloud Support for further assistance, as they can provide insights into whether this behavior is specific to your project.

I hope the above information is helpful.

 

0 Likes