Open navigation

How to fix discrepancies in Google Analytics data

If you’re seeing discrepancies between your Google Analytics data and the data you see in your Supermetrics reports, follow this guide to solve the issue.


In most cases, there are 2 reasons for a discrepancy between Supermetrics and Google Analytics: data sampling, or delays in communication between Google Analytics and the Google API (API latency).


Data sampling

Google Analytics can sample the results it delivers to Supermetrics. This can cause differences — usually in the range of 1% to 4% — between the values displayed by Supermetrics and Google Analytics. 


Sampling is most common in queries with advanced segments, very large data sets, large amounts of session data, or data that’s split by multiple dimensions. Learn more about this in Google’s documentation.


Check for sampling

Check for sampling using the instructions below before taking any other steps.

Google Sheets
  1. Open the ‘SupermetricsQueries’ tab. (This tab is hidden by default — click Add-ons → Supermetrics → Manage queries to open it.)
  2. Navigate to the “Results contain sampled data” row.
  3. If that row contains the value TRUE, the query in that row has sampled data.

To reduce the likelihood of sampling, open the Supermetrics sidebar and select Try to avoid Google’s data sampling in the Options section.


Complex queries will still be sampled even if this option is enabled. Try simplifying your queries to reduce the chance of sampling.


If the discrepancies still appear after the avoid sampling option is enabled and your queries are streamlined, there's no further action that you can take to reduce the discrepancy.


Excel
  1. Open the ‘SupermetricsQueries’ tab. (This tab is hidden by default — click Add-ons → Supermetrics → Manage queries to open it.)
  2. Navigate to the “Results contain sampled data” row.
  3. If that row contains the value TRUE, the query in that row has sampled data.

To reduce the likelihood of sampling, open the Supermetrics sidebar and select Try to avoid Google’s data sampling in the Options section.


Complex queries will still be sampled even if this option is enabled. Try simplifying your queries to reduce the chance of sampling.


If the discrepancies still appear after the avoid sampling option is enabled and your queries are streamlined, there's no further action that you can take to reduce the discrepancy.


API latency

The Google Analytics API and the Google Analytics web interface are not always totally in sync. Supermetrics communicates with the Google Analytics API, which may in some cases deliver figures that differ from the ones shown in Google Analytics. 


If you suspect something like this may be affecting your reports, there are a few places where you can investigate the issue:



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.