Loading

Expected Dimensions and Measures Not Available When Connecting to Google Analytics

Дата публикации: Apr 13, 2024
Описание
When connecting to Google Analytics, you are unable to find fields that are visible in the Google Analytics API.
 

Cause

Tableau Desktop will only display dimensions and measures that are available in Google's Core reporting API.
Решение
Verify the fields exist in Google's Core Reporting API. For more information, see Query Explorer in Google Analytics Demos & Tools.
Дополнительные ресурсы
Some metrics may not appear to be available because they are defined as a calculation based on metrics that are available. 
  • For example, the metric "Pages/Session" (ga:pageviewsPerSession) does not appear in Tableau Desktop; however, this metric is defined as ga:pageviews / ga:sessions, both of which are available metrics.  
  • Tableau Desktop functionality allows for the flexibility to create metrics that aggregate this ratio in different ways, such as SUM(ga:pageviews)/SUM(ga:sessions), SUM(ga:pageviews / ga:sessions), or the use of other aggregations, such as AVG.

More information on the available Google Analytics dimensions and measures can be found in the below page maintained by Google:
https://developers.google.com/analytics/devguides/reporting/core/dimsmets#mode=api


Номер статьи базы знаний

001474142

 
Загрузка
Salesforce Help | Article