(Some) metrics with float values incompatible with Google Charts API

[Nick Wei]

I've run into a problem with one of the chart data sources that I've generated using the Super Proxy.

The query in question looks like this:

https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3AXXXXXXXXX&start-date={90daysago}&end-date={1daysago}&metrics=ga%3AavgSessionDuration%2Cga%3ApageviewsPerSession&dimensions=ga%3Adate&sort=ga%3Adate

which in plain English would be something like "get Average Session Duration and Page Views per Session broken by date for the last 90 days"

I'm trying to use this as a data source for a line chart with 2 axes, one for each metric but I've found that ga:avgSessionDuration prevents this from working properly presumably because the Super Proxy returns that metric with quotes and the Google Charts API returns output to the effect "Axes #0 cannot be of type string".  Both metrics in this case are floats but for whatever reason, avgSessionDuration looks like this: "215.335623256" while pageviewsPerSession looks like this: 4.352647554.  There are a number of ways I can think of to solve this like pulling the data from the Super Proxy into a separate variable and casting the string into a float (ie. handle this client side), modify the Super Proxy itself to repackage floats as floats in the JSON format (server side), or modify the gviz_api JSONEncoder (also server side).

I'm curious if anyone else out there has run into this and what their workaround was?

Thanks

Research shows that organizations with high online analytics maturity get better ROI from their digital marketing and analytics investments. Not sure what your organization's analytics maturity is? Do you want to see how you compare to over 900 companies worldwide? Take the Online Analytics Maturity Assessment (OAMA) and find out now!

This email, including any attachments, is for the sole use of the intended recipient and may contain confidential information. If you are not the intended recipient, please immediately notify us by reply email or by telephone, delete this email and destroy any copies. Thank you