search

roniest / google-apis-explorer

Automatically exported from code.google.com/p/google-apis-explorer
Apache License 2.0
0 stars 0 forks source link

Wrong Datatype for ga:transactionspervisit #99

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi,

I am using google analytics plugin in Pentaho data intergation (where you need 
to provide your email, password and sumple API key to get access to google 
data). I am using as a metrics ga:transactionsPerVisit but I am receiving the 
data in the wrong format! It seems to me, it's mixed with conversion rate and 
schows up as %, not number!

For instance:

ga:date       ga:sourceMedium    ga:deviceCategory    ga:visits    ga:pageviews 
   ga:pageviewsPerVisit    ga:transactions    ga:transactionsPerVisit  
2013/07/24  (direct) / (none)       desktop           161           544         
         3.4                   3              1.9   

As you can see, pageviews per visit is calculated correctly (544/161=3,4) BUT 
transactions per visit should be 3/161=0,019! 

This is what I got with Services > Google Analytics API v3 > 
analytics.data.ga.get

"name": "ga:transactionspervisit",
"columnType": "METRIC",
"dataType": "PERCENT"

As you can see, the data type is percent instead of integer. On Dimensions & 
Metrics website is clearly explained that transactions per visit = transactions 
/ visit

Would be great if it can be fixed!

Original issue reported on code.google.com by goo...@classmarkets.com on 29 Jul 2013 at 9:07