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

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

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

python - PyCharm Type error Message -

-
i'm newbie trying out ml/dbn in python (3.4) under pycharm (comm.ed 4.5). following definition def make_thetas(xmin,xmax,n): xs = np.linespace(xmin,xmax,n) widths = (xs[1:] - xs[:-1])/2.0 thetas = xs[:-1] + widths return thetas throws error "class 'tuple' not define ' sub ', '-' operator cannot used on instance" on - operator on third line (widths = ....) ideas on how code running under pycharm - works alright in interactive python window. thx. to all, after g'g lot have found workaround seems work within pycharm. workaround because (even python newbie) expected python not need explicit typecasting, not when using datatypes imported lib such numpy. def make_thetas(xmin,xmax,n): xs = np.array(np.linspace(xmin,xmax,n)) widths = (xs[1:] - xs[:-1])/2.0 thetas = xs[:-1]+ widths return thetas using docstrings type-hinting such below did not work def make_thetas(xmin,xmax,n): "&q
Read more