: Sum of completed and not completed doesn't add up correctly in the Google Analytics API I have a simple funnel situation. The users start at /start/ . Some of them reach the result at /result/

Posted in: #AnalyticsApi #GoogleAnalytics #RegularExpression

I have a simple funnel situation. The users start at /start/ . Some of them reach the result at /result/ and obviously some don't.

So it seems logical to me that:

users who went to the start page =
user who did see the result page afterwards
+ user who did NOT see the result page afterwards

However my results are

users who went to the start page << user who did see the result page afterwards + user who did NOT see the result page afterwards
user who did see the result page afterwards is smaller than users who went to the start page and has about the same pageview ration as the API calls tell me.
user who did NOT see the result page afterwards is just 10% smaller than users who went to the start page

The calls are run via the spreadsheet addin to the API.

all three calls share these attributes:

Metric: ga:users
no filter
are for the last 30 days
Sampling: HIGHER_PRECISION

The segments differ for each call

users::sequence::ga:pagePath=~/start/$
users::sequence::ga:pagePath=~/start/$;->>ga:pagePath=~/result/.*
users::sequence::ga:pagePath=~/start/$;->>ga:pagePath!~/result/.*