Loading

Expected Dimensions and Measures Not Available When Connecting to Google Analytics

Publiseringsdato: Apr 13, 2024
Beskrivelse
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.
Løsning
Verify the fields exist in Google's Core Reporting API. For more information, see Query Explorer in Google Analytics Demos & Tools.
Flere ressurser
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


Knowledge-artikkelnummer

001474142

 
Laster
Salesforce Help | Article