Differences Between Tableau and Google Analytics Data

Summary of Differences:

1. Web Analytics dashboards in Tableau is fed by the Google Analytics (GA) data.
2. The raw data is transformed in our data warehouse, thus its interpretation is different from that of Google.

Tableau Data Transformation Detail:

While Google Analytics feeds the web traffic data to Ohio State’s Tableau dashboards, there are several important differences between the data as reported by Google Analytics tools (GA interface and Data Studio) and the data in the Tableau dashboards. They come from the data cleansing and transformations that are performed in our data warehouse before the data is summarized for reporting.

• Bot traffic. Weekly traffic spikes from automated crawlers, like SiteImprove, and other bots are removed from the Tableau dashboards. This is by far the largest difference in the data.
• Sessions with no pageviews are excluded in the Tableau session counts but are counted in Google Analytics. Other metrics, such as engagement time, engagement session indicators, or outbound link clicks that happen during these sessions are generally included in the Tableau reports.
• Attribution - Channel definitions differences.
  • Internal Channel. In Tableau, Internal channel is traffic from internal sites and apps, such as Zoom, Teams, Sharepoint, and the Wexner Medical center. In Google Analytics, this traffic typically appears under Referral channel.
  • AI referrals. Traffic from ChatGPT, Perplexity, and other AI sources is reflected in Tableau.
  • Video channels. In Google Analytics, YouTube and TikTok traffic appears under Organic and Paid Video, while in Tableau, we roll it into Social traffic.
  • ‘Other’ channel. The definition of ‘Other’ channel in Tableau is wider than that of Google Analytics’ Unassigned channel and covers rarely used channels, such as SMS and Shopping traffic.
  • Non-pageview channel. This channel is used to identify events like Outbound link clicks when they happen during a session with no pageviews. This typically happens in an interrupted session, when a page remains open in the browser for over 30 minutes.
  • Direct channel. For Direct channel, Google reports last non-direct channel for the user's sessions within the prior 30 days. Tableau reports these sessions as Direct.
• Unique Pageviews. Tableau reporting includes Unique Pageviews metric, which is currently not available in GA. Unique Pageviews are a count of unique sessions on a page. They typically match session counts for individual page URLs in Google Analytics. In Tableau, session count metric is not available on a page URL level (use unique pageviews), but is available on a landing page level.
• Go link redirects. Go Link redirects originate from a custom event in Google Analytics and are available in Tableau. However, Google Analytics UI has no built-in reports for custom events like Go link redirects.
• Users. Currently, Tableau reports do not include user counts because it is impossible to calculate unique users from the summarized tables. We are looking for other solutions that allow reporting unique user counts.
• Engagement rate over 100%. On occasion, a session without any pageviews is an engaged session. In that case, the session is not counted in total sessions but counted as an engaged session. For example, when many visitors to a page let the session lapse and re-engage later, then the engagement rate may climb over 100%.
• Page URL. In Tableau, all page URLs are cleaned for query strings and utm parameters. They are also standardized to remove ‘/’ at the end of the URLs.
• ‘Other’ page URLs and hostnames. Occasionally, the event data contains broken, numeric, or localhost URLs and hostnames. In Tableau, they are summarized under “Other” category.
• Session source. In Tableau, many common traffic source values are cleansed and summarized. For example, m.facebook.com is replaced with Facebook.
• Not set. Google Analytics shows ‘Not set’ when the value is not available in the breakdown. For example, ‘Not set’ is the value assigned to the landing page URL in sessions with no pageviews. Tableau dashboards typically show Null when the value is not available.

Web Analytics Hub

Request access to the Tableau dashboards and learn more about the Web Analytics dashboards at Ohio State:

Get Help

Contact OMC-AnalyticsPerformance@osu.edu to get help with data questions or request a new dashboard.