Thursday, July 18, 2013

Digest for - 2 Messages in 1 Topic


    hagit Ben shoshan <> Jul 16 10:28PM -0700  

    While watching the latest presentation of "*Google Analytics and AdSense
    Data Analysis in BigQuery*" on, I tried to understand the structure of "sessions_YYYYMMDD" tables .
    > [gumtree-uk-ga:google_analytics.sessions_20130421] AS t1
    > WHERE
    > hits.customVariables.index = 1

    What is the structure and the purpose of this table ?
    Is it a daily summary table ?
    what are the different values within the "customVariables" array ?
    Can anyone please refer me to documentation source ?
    Thank you , Hagit


You received this message because you are subscribed to the Google Groups "AdSense API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
To post to this group, send email to
Visit this group at
For more options, visit

1 comment: