adCost shows up with value 0 when making queries combining month, medium, adcost, and itemQuantity

201 views
Skip to first unread message

Spanishgringo

unread,
Feb 8, 2010, 11:55:28 AM2/8/10
to google-analytics-api - GA Data Export API
I sent in this bug report regarding adCost in the API.
http://code.google.com/p/gdata-issues/issues/detail?id=1852

Dimension: ga:month
Metric: ga:adCost and ga:itemQuantity
Segment: dynamic::ga:medium=~cpc

Output is fine for quantity, but adcost only shows 0. If this is an
invalid combination (although I do not know why it would be), it is
not indicated in the chart in the api docs nor does it through an
exception.

Please advise.

We want to calculate CPL and without these 2 together it is no good.


Nick

unread,
Feb 8, 2010, 4:58:45 PM2/8/10
to google-analytics-api - GA Data Export API
Hi,

This issue is with querying AdWords related data from advanced
segments. Currently all AdWords related metrics in queries that also
define an advanced segment will return 0's.

-Nick


On Feb 8, 8:55 am, Spanishgringo wrote:
> I sent in this bug report regarding adCost in the API.http://code.google.com/p/gdata-issues/issues/detail?id=1852

Spanishgringo

unread,
Feb 9, 2010, 3:39:12 AM2/9/10
to google-analytics-api - GA Data Export API
This problem is not only with Advanced Segments. If I include Medium
as a normal dimension and not a segment, I still get the same problem
so long as I also include itemQuantity as a metric as well.

Here is the query
https://www.google.com/analytics/feeds/data?ids=FOOBAR&dimensions=ga%3Amonth%2Cga%3Amedium&metrics=ga%3AadCost%2Cga%3AitemQuantity&start-date=2009-10-01&end-date=2009-10-31&max-results=50

PS: Thanks for the answer on GA TV to my question. Any ETA on unique
visitors getting rolled out to the API?

-Michael

Nick

unread,
Feb 9, 2010, 12:41:38 PM2/9/10
to google-analytics-api - GA Data Export API
Hey Michael,

No Problem. Getting unique visitors rolled out is something we're
looking at closely.

Regarding the combination, at this point the API is following the same
logic as the custom reporting in the web interface. Currently that
combination is allowed, but also only returns 0's for ad cost when
queried with medium. So this combination isn't supported in GA.

-Nick



On Feb 9, 12:39 am, Spanishgringo wrote:
> This problem is not only with Advanced Segments.  If I include Medium
> as a normal dimension and not a segment, I still get the same problem
> so long as I also include itemQuantity as a metric as well.
>
> Here is the queryhttps://www.google.com/analytics/feeds/data?ids=FOOBAR&dimensions=ga%...
Reply all
Reply to author
Forward
0 new messages