Databases
StackOverflow2013
Postsdbo
PObig difference in "visitor" count
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PObig difference in "visitor" count
    text
    copied!<p>I try to pull out the (unique) visitor count for a certain directory using three different methods: * with a profile * using an dynamic advanced segment * using custom report filter</p> <p>On a smaller site the three methods give the same result. But on the large site (> 5M visits/month) I get a big discrepancy between the profile on one hand and the advanced segment and filter on the other. This might be because of sampling - but the difference is smaller when it comes to pageviews. Is the estimation of visitors worse and the discrepancy bigger when using sampled data? Also when extracting data from the API (using filters or profiles) I still get DIFFERENT data even if GA doesn't indicate that the data is sampled - ie I'm looking at unsampled data. </p> <p>Another strange thing is that the pageviews are higher in the profile than the filter, while the visitor count is higher for the filter vs the profile. I also applied a filter at the profile to force it to use sample data - and I again get quite similar results to the filter and segment-data.</p> <pre><code> profile filter segment filter@profile unique 25550 37778 36433 37971 pageviews 202761 184130 n/a 202761 </code></pre> <p>What I am trying to achieve is to find a way to get somewhat accurat data on unique visitors when I've run out of profiles to use.</p> <p>More data with discrepancies can be found in this google docs: <a href="https://docs.google.com/spreadsheet/ccc?key=0Aqzq0UJQNY0XdG1DRFpaeWJveWhhdXZRemRlZ3pFb0E" rel="nofollow">https://docs.google.com/spreadsheet/ccc?key=0Aqzq0UJQNY0XdG1DRFpaeWJveWhhdXZRemRlZ3pFb0E</a></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload