Google analytics sample query

Table of Contents

• Best product topn
• Source sample
• Check new user
• Keyword
• Outbound link
• ECommerce
  • Add to cart session =1
  • Add to cart session>2
  • Without transations session =1
  • Without transations session >2
  • with transations session =1
  • with transations session >2
• Error

Best product topn

• https://ga-dev-tools.appspot.com/query-explorer/?start-date=7daysAgo&end-date=today&metrics=ga%3AproductDetailViews&dimensions=ga%3ApageTitle%2Cga%3AproductSku&sort=-ga%3AproductDetailViews&include-empty-rows=false

Source sample

https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A102963457&start-date=7daysAgo&end-date=today&metrics=ga%3Apageviews&dimensions=ga%3Asource%2Cga%3ApagePathLevel3%2Cga%3ApageTitle&include-empty-rows=false

Check new user

https://ga-dev-tools.appspot.com/query-explorer/?ids=ga%3A102963457&start-date=1daysAgo&end-date=today&metrics=ga%3Ausers&dimensions=ga%3AuserType%2Cga%3AreferralPath%2Cga%3Asource%2Cga%3AbrowserVersion%2Cga%3ApagePathLevel3%2Cga%3ApageTitle%2Cga%3AcountryIsoCode&filters=ga%3AcountryIsoCode%3D%3DCA&include-empty-rows=false

Keyword

• English Only

• https://ga-dev-tools.appspot.com/query-explorer/?start-date=100daysAgo&end-date=today&metrics=ga%3Apageviews&dimensions=ga%3Akeyword&filters=ga%3Akeyword%3D~%5E%5B0-9a-zA-Z%20%5D*%24&include-empty-rows=false

• Others (without English only)

• https://ga-dev-tools.appspot.com/query-explorer/?start-date=100daysAgo&end-date=today&metrics=ga%3Apageviews&dimensions=ga%3Akeyword&filters=ga%3Akeyword!~%5E%5B0-9a-zA-Z%20%5D*%24&include-empty-rows=false

Outbound link

• https://ga-dev-tools.appspot.com/query-explorer/?start-date=300daysAgo&end-date=today&metrics=ga%3AtotalEvents&dimensions=ga%3AeventLabel&filters=ga%3AeventLabel%3D%40%22href%22%3Bga%3AeventLabel!%40%22href%22%3A%22%22%3Bga%3AeventLabel!%40SiteName

ECommerce

Add to cart session =1

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource%2Cga%3Adimension1%2Cga%3AshoppingStage&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AshoppingStage%3D%3DADD_TO_CART%3Bga%3AproductDetailViews%3E%3D3&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3D%3D1%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3C%3D0&include-empty-rows=false

Add to cart session>2

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource%2Cga%3Adimension1%2Cga%3AshoppingStage&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AshoppingStage%3D%3DADD_TO_CART%3Bga%3AproductDetailViews%3E%3D3%3Bga%3Asessions%3E1&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3E%3D2%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3C%3D0&include-empty-rows=false

Without transations session =1

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource%2Cga%3Adimension1&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AproductDetailViews%3E%3D3%3Bga%3Asessions%3D%3D1&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3D%3D1%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3C%3D0&include-empty-rows=false

Without transations session >2

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource%2Cga%3Adimension1&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AproductDetailViews%3E%3D3%3Bga%3Asessions%3E%3D2&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3E%3D2%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3C%3D0&include-empty-rows=false&max-results=1500

with transations session =1

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AproductDetailViews%3E%3D3%3Bga%3Asessions%3D%3D1%3Bga%3Atransactions%3E%3D1&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3D%3D1%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3E%3D1&include-empty-rows=false

with transations session >2

https://ga-dev-tools.appspot.com/query-explorer/?start-date=18daysAgo&end-date=today&metrics=ga%3Asessions%2Cga%3Atransactions%2Cga%3AproductDetailViews&dimensions=ga%3AuserBucket%2Cga%3Asource%2Cga%3Adimension1&filters=ga%3Asource%3D%40line%3Bga%3Adimension1!%3D0%3Bga%3AproductDetailViews%3E%3D3%3Bga%3Asessions%3E%3D2%3Bga%3Atransactions%3E%3D1&segment=users%3A%3Acondition%3A%3Aga%3Asource%3D%40line%3Busers%3A%3Acondition%3A%3Aga%3Asessions%3E%3D2%3Busers%3A%3Acondition%3A%3Aga%3Atransactions%3E%3D1&include-empty-rows=false&max-results=1500

Error

https://ga-dev-tools.appspot.com/query-explorer/?start-date=today&end-date=today&metrics=ga%3AtotalEvents&dimensions=ga%3Abrowser%2Cga%3AeventLabel%2Cga%3AdateHourMinute&sort=-ga%3AdateHourMinute&filters=ga%3AeventAction%3D%3DScriptError%2Cga%3AeventAction%3D%3DInitScriptError&include-empty-rows=false