Geek Answers Handbook

Analytics Posting Sequence

I retrieve data from Google Analytics Premium and try to report the sequence of pages that the user viewed in one session.

I used the following query:

SELECT fullvisitorID,visitid,visitnumber,hits.hitnumber,hits.type FROM 
(TABLE_DATE_RANGE([mydata.ga_sessions_], 
                TIMESTAMP('2014-04-25'),timestamp('2014-05-26')
               )) where visitid=123456789;

The results show me the following hit types:

Hitnumber: 1 Hit Type: Page

Hitnumber: 3 hit type: event

Hitnumber: 4 Hit Type: Page

Hitnumber: 5 Type of hit: event

It seemed strange to me that there was no number 2 in this result set. I saw other visits where the hit scraper jumped from 2 to 16 with nothing in between. I do not filter any types of strokes, so I could not understand why I would not see everything in sequence. The total number of hits for the above results is 4, which is consistent with the results, but it would be interesting to know why number 2 is skipped.

/ .

+4
1

Google Analytics Raw Big Query, :

  • . , : hits.isInteration false, hits.isInteration false, hits.hitNumber
  • , , .hitNumber ( ). , hits.time. , - hit.hitNumber hits.time.
  • - , , , . , , , , Google Analytics, .

, Big Query .

+1

More articles:


All Articles