Data doesn't match the UI

Funnel fetches Google Analytics data from the Analytics Reporting API v4 by querying the dimensions and metrics you select upon connecting a data source. Depending on the selected dimensions and their values, the API can sometimes filter data. The Google Analytics API will in come cases only return data for rows that have values for all dimensions queried. So when data is missing for one or more of the dimensions, Google will not return that row, hence filtering the data. The API should however be consistent with the UI. This means that you can confirm if the data for a certain Google Analytics data source in Funnel is correct by creating a custom report containing the same dimensions in the UI that you selected when connecting your data source.

If the custom report matches the numbers you are seeing in Funnel we suggest that you either remove the dimension(s) that are filtering the data from your data source, or if these dimensions are necessary for your reporting, that you connect another data source without them. If you choose to connect a new data source, please be mindful of double counting and remember to filter your data on data source if you choose overlapping metrics.

Dimensions affecting metric totals

Age

Age does not include data for users younger than 18 years.

Age and Gender

Age and Gender are likely to cause Google Analytics to filter rows because of privacy reasons. The more dimensions you select and the more specific report you create the more rows will be filtered. Read more about the Data Thresholds that are protecting the users' privacy here: https://support.google.com/analytics/answer/2799357#thresholds


Custom dimensions

Custom dimensions will filter data that don't have any values for the dimension in question. This means that if you don't assign a custom dimension to a user/session or hit, then it won't be included if you look at that user/session or hit in Funnel. Choosing two custom dimensions means that each row must have some set value for both of these dimensions. If one is missing the row will not be part of the segment of data returned. This is the same behaviour as in the Google Analytics UI. Read more in our help article about custom dimensions in Google Analytics.

Mobile Device

Choosing any of the Mobile Device dimensions below might lead to unexpected total values, as they will not include data for desktop users. This is the same behaviour as in Google Analytics' UI, and has to do with the fact that data is only returned for rows where these dimensions have values:

  • Mobile Device Model

  • Mobile Device Branding

  • Mobile Device Marketing Name

  • Mobile Device Info

Event Label

Event metrics may be affected if the optional dimension Event Label has been included in Funnel, but some or all events do not send Event Label to Google Analytics. This is due to how Google filters data with no values for a dimension, meaning that when a report is created which includes the Event Label, any events that do not have values for that dimension will be filtered out.

Client ID

Client ID may affect metric totals as Google Analytics can only deliver the top 10,000 unique Client IDs per day. If you have more visitors than that per day it will result in exceeding data being omitted.

Transaction ID

Adding the Transaction ID dimension will lead to all rows that do not have an associated Transaction ID being filtered out. Only rows containing Transaction ID will be returned by the API which can lead to unexpected metric totals.

Missing recent data

If the numbers for the last two days are too low that can be due to Google's data freshness (the delay before the data is available). The same delay applies to the Google Analytics UI but depending on when you look in GA vs Funnel or if Funnel hasn't received that data yet this can still happen. For standard properties this delay is up to 48h before all data has stabilised. For a 360 property it's up to 4h when looking at today and up to 24h when looking at previous days.

Read about the limits limit in Google help article here: https://support.google.com/analytics/answer/7084038

Missing or too few goal completions

Goal completions based on events will not be viewable per Page. This is because events can fire multiple times per session while goals only can fire once, meaning that a goal completion can be spread out on multiple pages.

Missing goal metrics

Smart goals are not included per default, because of a limitation in the Google Analytics API we can't see beforehand if a user has any or not. If you need this metric please write to the Funnel support and ask us to toggle it for your data sources.

Metric values being slightly off

If you have a lot of data GA might read some of it and then estimate the rest. This sampling is done in the UI as well, look for if the shields becomes yellow in GA (see picture below). Read more about sampling for GA here.

Double counting data

When connecting several data sources for one property make sure that you do not look at the same data twice as this will lead to skewed numbers.

Data sources with segments included

When adding multiple Segments you will get all data in segment A plus all data in segment B. This means that you have to include the Segment dimension in your queries when looking at segments with overlapping data to not get too high values.

Read more about Google Analytics segments in Funnel here.

Comparing Funnel data with the Google Ads report

The Google Ads report in Google Analytics filters the data on the source and medium values "google / cpc". You have to filter on the same thing in Funnel to not include data from other traffic sources or else you will see higher values in Funnel.

Did this answer your question?