search

wojtekmo / analytics-issues

Automatically exported from code.google.com/p/analytics-issues
0 stars 0 forks source link

Different data returned depending on how query is built #93

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
--------------------------------------------------------------------------
NOTE: This issue tracking system is for developer products only.  If you
are not a developer/programmer and have a problem with a Google web site,
please report the problem to the appropriate group.  More information can
be found here: http://www.google.com/support/
--------------------------------------------------------------------------

Name of API affected:
Analytics Data Export API

Issue summary:
--------------
Performing a query using a dimension vs. performing a query using a segment.  I 
believe the queries should return the same data values.  I'd like to understand 
why the queries are returning different values for *some* of the metrics.

According to the 
http://code.google.com/apis/analytics/docs/gdata/gdataReferenceDataFeed.html 
documentation, the dimensions parameter is optional and can be used to segment 
the metrics (I'm imagining this is similar to SQL group by functionality).

The segment parameter is optional and can also be used to segment the data by 
one or more *dimensions* and/or metrics (I'm imagining this is similar to SQL 
where clause functionality).

Steps to reproduce issue:
-------------------------
1.Data Feed Query Explorer 
(http://code.google.com/apis/analytics/docs/gdata/gdataExplorer.html)
2. Query 1
2.1 Dimensions = ga:medium
    Metrics = ga:bounces,ga:entrances,ga:exits,ga:newVisits,ga:pageviews,ga:timeOnPage,ga:timeOnSite,ga:visits
    Start date = 5/23/2010
    End Date = 5/23/2010
    Max Results = 10000

2.2 Result set
 ga:medium    ga:bounces    ga:entrances  ga:exits  ga:newVisits  ga:pageviews  ga:timeOnPage     ga:timeOnSite     ga:visits 
(none)  162 541 [534]   450 [3081]  [151694]    153904  541
cpc 48  227 218 183 1199    43747   44409   227
organic 323 1110    1130    909 6193    245526  241765  1110
ppc 0   1   1   0   13  332 331 1
referral    60  132 128 104 445 14930   15807   132

2. Query 2
2.1 Metrics = 
ga:bounces,ga:entrances,ga:exits,ga:newVisits,ga:pageviews,ga:timeOnPage,ga:time
OnSite,ga:visits
    Degment = dynamic::ga:medium==(none)
    Start date = 5/23/2010
    End Date = 5/23/2010
    Max Results = 10000

2.2 Result set
    ga:bounces    ga:entrances  ga:exits  ga:newVisits  ga:pageviews  ga:timeOnPage     ga:timeOnSite     ga:visits 
(none)  162 541 [541]   450 [3103]  [153902]    153904  541

Expected output:
----------------
I would expect the numbers for ga:exits, ga:pageViews, and ga:timeOnPage to be 
tthe same regardless of whether I used a dimension or a segment to get the 
metric data.

Actual results:
---------------
When using a dimension vs. a segment I get different values for ga:exits, 
ga:pageViews, and ga:timeOnPage

Notes:
------

Original issue reported on code.google.com by mjbe...@gmail.com on 29 Jul 2010 at 9:42

GoogleCodeExporter commented 8 years ago 
Removing an obsolete label that was used when these issues were in the 
gdata-issues project.

Original comment by jrobbins@google.com on 21 Jul 2011 at 10:04

GoogleCodeExporter commented 8 years ago 
 va bene
CMS

Original comment by carlomar...@gmail.com on 26 Apr 2015 at 3:50