Common AQL Queries
Top Page Paths by Pageviews
SELECT METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, ga:entranceBounceRate ON COLUMNS DIMENSIONS ga:pagePath ON ROWS BY ga:pageviews DESC FROM default WHERE TIMEFRAME lastMonth, default
Top Page Titles by Pageviews
SELECT METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, ga:entranceBounceRate ON COLUMNS DIMENSIONS ga:pageTitle ON ROWS BY ga:pageviews DESC FROM default WHERE TIMEFRAME lastMonth, default
Top 15 Traffic Sources
SELECT METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS DIMENSIONS ga:source ON ROWS TOP 16 BY ga:visits DESC FROM default WHERE TIMEFRAME yesterday FILTER ga:source != "(direct)"
Social Media KPIs
SELECT METRICS ga:pageviews, ga:avgTimeOnPage, ga:entrances, ga:entranceBounceRate ON COLUMNS DIMENSIONS ga:source ON ROWS BY ga:visits FROM default WHERE TIMEFRAME lastMonth, default FILTER ga:source == "twitter.com" OR ga:source == "facebook.com" OR ga:source == "linkedin.com"
Top Site Sections
CUSTOMDIM sp:folders LABEL "Folders" MEMBER "Commercial" AS FILTER ga:pagePath =@ "/commercial/" MEMBER "Government" AS FILTER ga:pagePath =@ "/government/" MEMBER "Education" AS FILTER ga:pagePath =@ "/education/" SELECT METRICS ga:pageviews, ga:avgTimeOnSite, ga:pageviewsPerVisit, ga:entranceBounceRate ON COLUMNS DIMENSIONS sp:folders ON ROWS FROM default WHERE TIMEFRAME lastCalendarWeek
Top 10 Keywords Last Week
SELECT METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS DIMENSIONS ga:keyword ON ROWS TOP 10 NOOTHER BY ga:visits DESC FROM default WHERE TIMEFRAME lastCalendarWeek FILTER ga:keyword != "(not set)"
Top 10 Referral Sources Last Week
SELECT METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS DIMENSIONS ga:source ON ROWS TOP 10 NOOTHER BY ga:visits DESC FROM default WHERE TIMEFRAME lastCalendarWeek FILTER ga:visits != "0" SEGMENT ga:medium == "referral"
Top Search Traffic Sources Last Week
SELECT METRICS ga:visits, ga:pageviews, ga:pageviewsPerVisit ON COLUMNS DIMENSIONS ga:source ON ROWS BY ga:visits DESC FROM default WHERE TIMEFRAME lastCalendarWeek SEGMENT "Search Traffic"
©2021 ShufflePoint, Inc.