How is domain_sessionidx calculated?

[robin....@triptease.com]

From what I've read the domain_sessionidx is the count of the number of sessions a given user has. How is this generated? I assumed it would be generated from the data within the database, however I got an entry with a domain_sessionidx of 16 in a database that had previously been wiped, so I'm intrigued as to how this count is generated.

[Christophe Bogaert]

Hi Robin,

The domain session index is generated by the Javascript tracker and stored client-side in a cookie. Because this is done client-side, it is independent of the Redshift database. The process is explained in more detail in our documentation: https://github.com/snowplow/snowplow/wiki/1-General-parameters-for-the-Javascript-tracker#cookies

All the best,

Christophe

Snowplow Analytics

The Roma Building, 32-38 Scrutton Street, London EC2A 4RQ, United Kingdom
+44 (0) 203 589 6116
+44 (0) 7598 006 851

On Wed, Jul 29, 2015 at 5:08 PM, <robin....@triptease.com> wrote:

From what I've read the domain_sessionidx is the count of the number of sessions a given user has. How is this generated? I assumed it would be generated from the data within the database, however I got an entry with a domain_sessionidx of 16 in a database that had previously been wiped, so I'm intrigued as to how this count is generated.

--
You received this message because you are subscribed to the Google Groups "Snowplow" group.
To unsubscribe from this group and stop receiving emails from it, send an email to snowplow-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[robin....@triptease.com]

Hi,

Thanks for your swift response.

Does the fact that it's generated client side mean that the figure will be inaccurate when tracking cross domain sessions using the Clojure collector?

Robin

[Christophe Bogaert]

Hi Robin,

The Javascript tracker supports some cross-domain tracking: http://snowplowanalytics.com/blog/2015/03/15/snowplow-javascript-tracker-2.4.0-released/#cross-domain

This should make it possible to link users that move between domains, but each tracker sets its own session index. In those cases, it might be best to do the sessionization server-side instead. The following blogpost explains quite nicely how to do this in SQL: blog.modeanalytics.com/finding-user-sessions-sql/

All the best,

Christophe

Snowplow Analytics

The Roma Building, 32-38 Scrutton Street, London EC2A 4RQ, United Kingdom
+44 (0) 203 589 6116
+44 (0) 7598 006 851