google cloud platform - Trouble Looking For Events WITHIN a Session In BigQuery or WITHIN Multiple Sessions -

-

i wanted second pair of eyes & confirming best way within session @ hit level in bigquery. have read bigquery developer documentation thoroughly that provides insight on working within session. challenge this. let assume write high level query count number of sessions exist , group sessions device.device category below:

select device.devicecategory,  count(distinct concat (fullvisitorid, string (visitid)), 10000000) sessions (table_date_range([xxxxxx.ga_sessions_], timestamp('2015-01-01'), timestamp('2015-06-30'))) group each device.devicecategory order sessions desc

i run follow query following find number of distinct users (client id's):

select device.devicecategory,  count(distinct fullvisitorid) users (table_date_range([xxxxxx.ga_sessions_], timestamp('2015-01-01'), timestamp('2015-06-30'))) group each device.devicecategory order users desc

(note broke because of sheer size of data working produces runs greater 5tb in cases).

my challenge following. feel have wrong approach , have not had success within function. every user id (or full visitor id), want within various sessions find out how many sessions many had desktop , how many mobile. basically, these cross device users. want collect table these users. started here:

select count(distinct concat (fullvisitorid, string (visitid)), 10000000) sessions (table_date_range([xxxxxx.ga_sessions_], timestamp('2015-01-01'), timestamp('2015-06-30'))) device.devicecategory = 'desktop' , device.devicecategory = 'mobile'

this not correct though. moreover, version write of within query giving me non-sense results or results have 0 number. have strategies or tips recommend way forward here? best way use within function sessions may have multiple events happening within session (with goal being collecting user id's meet requirements within session or on various sessions). 2 days ago did in manual way manually working through steps , saving intermediate data frames generate counts. said, wanted see if there guidance using single query?

i'm not sure if question still open on end, believe see problem, , not misuse of within function. data understanding problem.

when dealing ga , cross-device identification, cannot reliably use combination of fullvisitorid , visitid identify users, these derived cookie ga places on users browser. thus, leveraging fullvisitorid identify specific browser on specific device more accurately specific user.

in order track users across devices, must able leverage userid functionality follow link. requires have user sign in in way, giving them identifier can use across of devices , tie behavior together.

after implement type of user identification can control, rather ga's cookie assignment, can use details across sessions , within individual sessions.

hope helps!


Comments

Post a Comment

Popular posts from this blog

c# - Better 64-bit byte array hash -

-
i need hash algorithm produces 64-bit hash code ( long ) fewer collisions string.gethashcode() , fast (no expensive calls cryptographic functions). here's implementation of fnv still shows 3% of collisions after testing 2 million random strings. need number way lower. void main() { const string chars = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz!#@$%^&*()_+}{\":?><,./;'[]0123456789\\"; const int n = 2000000; var random = new random(); var hashes = new hashset<long>(); int collisions = 0; for(int = 0; < n; i++) { var len = random.next(chars.length); var str = new char[len]; (int j = 0; j < len; j++) { str[j] = chars[random.next(chars.length)]; } var s = new string(str); if(!hashes.add(get64bithash( s ))) collisions++; } console.writeline("collision percentage after " + n + " random strings: " + ((doubl
Read more

webrtc - Which ICE candidate am I using and why? -

-
[questions in bold below] i have setup kurento media server 5.1.3 in datacenter behind firewall running os ubuntu 14.04. has 2 network cards: 222.222.222.222 (eth0 - private ip) 111.111.111.111 (eth1 - public ip) attached below sdp (setremotedescription) when browser connected kurento media server type: answer, sdp: v=0 o=- 5487318114793304426 0 in ip4 0.0.0.0 s=kurento media server c=in ip4 0.0.0.0 t=0 0 a=group:bundle audio video m=audio 59068 rtp/savpf 111 0 c=in ip4 111.111.111.111 a=rtpmap:111 opus/48000/2 a=rtpmap:0 pcmu/8000 a=sendrecv a=rtcp:59068 in ip4 111.111.111.111 a=rtcp-mux a=ssrc:669011897 cname:user39019747@host-6e83e4c2 a=extmap:3 http://www.webrtc.org/experiments/rtp-hdrext/abs-send-time a=mid:audio b=as:20 a=ice-ufrag:ymdk a=ice-pwd:lylifk5ueqzpwm91ddj37e a=fingerprint:sha-256 ff:0f:81:8c:41:4e:b4:b6:c6:d8:36:f3:d6:5f:09:fd:5f:af:13:b3:9d:fc:12:66:ac:f3:56:d6:5b:0a:73:5d a=candidate:1 1 udp 2013266431 111.111.111.111 55239 typ host a=candidate:2 1 udp
Read more

php - Zend Framework / Skeleton-Application / Composer install issue -

-
i trying create zend framework application using skeleton in netbeans. when run composer install, following error message: "c:\php\php.exe" "c:\composer\composer.phar" "--ansi" "--no-interaction" "update" "--dev" using deprecated option "dev". dev packages installed default now. loading composer repositories package information updating dependencies (including require-dev) requirements not resolved installable set of packages. problem 1 - package requires php >=5.5 php version (5.4.42) not satisfy requirement. problem 2 - installation request zendframework/zendframework 2.5.1 -> satisfiable zendframework/zendframework[2.5.1]. - zendframework/zendframework 2.5.1 requires php >=5.5 -> php version (5.4.42) not satisfy requirement. done. apparently, zend framework only needs php 5.3+ contradicts above. need use php 5.4. my composer.json following: { "name": "
Read more