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/ 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

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/.*

Is possible to disable a link after some time in a newsletter?

I work in a company where we sent many offer newsletters a week.

When the offer time has passed we replace some of the images of the newsletter so that it is clear the offer has ended.

Lets say that we have an image of the product and of course it has a link to our website. Apart from changing the image with the word “Ended” , is it possible to disable the link as well?

I know it might not sound possible, but wondering if there is way.

which url is better for google SEO, recursively or directly? [duplicate]

This question already has an answer here:

Problems ranking in different countries for .com site [closed]

I’ve got something confused with My website is hosted in United states, and its language is English. However, when i search a keyword in India, actually my website naming, my site ranks #34. On the other hand, mysite ranks #20 in United States’s Google search results.

Same as above my some keyword is #12 in United Stated and that same keyowrd when i’m in india and find in that keyword is #48.

Why does that happen? already know that different locations may lead different search results, but my site is hosted in United States, why India result better than United States result for the same keyword?

i already geographic target has been set United State in Google Webmaster tool
and also i set language is English

Anyone could help?Thank you!

Google analytics tracking code

MY google analytics tracking info shows

  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),

  ga('create', 'UA-107xxx48-13', 'auto');
  ga('send', 'pageview');


but the code im the site html shows

    <script type="text/javascript">
    var _gaq = _gaq || [];
            _gaq.push(['_setAccount', 'UA-107xxx48-29'],['_trackPageview']);
    ['panel._setAccount', 'UA-107xxx48-13'],

Does difference between the ‘ga send’ in the code and the ‘gaq.push’ on the site matter?

Title in Google does not match <title> of document [duplicate]

This question already has an answer here:

Arduino ADC value and practices to store data to buffer

I’m writing Arduino application which has timer interrupt to acquire ADC value. Main loop has serial transmission procedure to send data from buffer.

I’m not sure how to store data in buffer. Best way would to have queue, but Arduino has so less memory. I will connect SPI Static RAM for my buffer. And this memory has only write/read data at index.

I have only buffer. And I need to add values and removes in FIFO order. So how to solve this problem ?


Representing category splits in a personal finance database

I’m working on developing a personal finance applications (e.g. Quicken/ I plan to store the data in a SQLite database. I’m stuck trying to determine how I want to represent splits in the database. Each transaction will be assigned a category such as “Food and Dinning” or “Rent”. However, a single transaction may be split across multiple categories. For example a transaction at a grocery store may be split between “Groceries” and “Household”.

Here’s one version of my Transactions table. Transactions that are split would have a Catagory of “Split”.

---Transactions Table (Option 1)---
REAL Amount
TEXT Description
TEXT Comment
TEXT Category

And here’s my Splits table which identifies how much of each transaction is assigned to specific categories.

---Splits Table (Option 1)---
INTEGTER TransactionId
REAL SplitAmount
TEXT Category

The problem I have with this setup is the two tables could potentially get out of sync with one another. If a split is added or removed then the code has to know to switch the transaction category to and from “Split”. Also the total amount of the splits associated with a transaction need to match the actual transaction amount.

Alternatively I was thinking of just treating everything as a split or “TransactionCategory”. So rather then assigning an amount to the transaction the amount is just assumed to be whatever the sum of the “TransactionsCategories” are for each transactions. Transactions that are not split would just end up having a single associated “TransactionCategory” row to identify the amount and category of the transaction. If for some reason a Transaction did not have an associated “TransactionCategory” entry it could just be assumed to be an uncategorized transaction of 0 amount.

 ---Transactions Table (Option 2)---
TEXT Description
TEXT Comment

---TransactionCategories Table (Option 2)---
INTEGTER TransactionId
REAL Amount
TEXT Category

I’m leaning towards this option as I do not have to keep the two tables in sync, but I’m worried about the overhead of having to join the two tables and take the sum of the TransactionCategories table anytime I need to show a list of transactions and their total amounts.

Syntax for if-then-else in Racket

I have a problem with Racket.

(I’m using the tutorial at

I tried to write a function that does this: If x is smaller than 4, then it should be incremented by 1, else it should be multiplied by 2.

(define (number x)
  (if (< x 4) 'x+1 'x*2))

So I compiled it on DrRacket, but it does nothing. The (if (< x 5) 'x+1 'x*2)) -Part is marked black! I think the Problem is the ' thing.

DDD: service/repo operations on IDs or instances?

This might be silly, but: let’s say I want to delete a Book from the repo. Should I:

  • deleteBook(bookId) – send the ID since in the most of the time, the ID is passed from the UI


  • deleteBook(Book) – but then I need to fetch the book first? And this would be just a shortcut for above: deleteBook(book.getId()).

My guts tells me both should exist. Any wisdom on this?

Question and Answer is proudly powered by WordPress.
Theme "The Fundamentals of Graphic Design" by Arjuna
Icons by FamFamFam