James Doc avatar

James Doc

Content Drilldown with the Google Analytics Core Reporting API

Today I’ve been trying to replicate the content drilldown function from Google Analytics through their Core Reporting API. The solution I came to requests pagePathLevel# in the dimension, and then filters on various pagePathLevel#:

For example if you wanted to the page views for the content drilldown at /level1/level2/level3 you could run this:

id=ga:#######
metrics=PageView, Sessions, etc
sort=-ga:page views
start-date=2014–11–16
end-date=2014–12–16
filters=ga:pagePathLevel1==/level1/;ga:pagePathLevel2==/level2/
dimensions=ga:pagePathLevel3

A handy tool to test these queries is the Google Analytics Query Explorer.

In my case I wanted to get a list of the most popular exhibitions at the V&A. The URL structure is: content/exhibitions/[expo-slug], so the query I am running is:

id=ga:#######
dimensions=ga:pagePathLevel3
metrics=ga:pageviews
filters=ga:pagePathLevel1==/content/;ga:pagePathLevel2==/exhibitions/
sort=-ga:pageviews
start-date=2014–11–16
end-date=2014–12–16
max-results=50

Right now, Constable and Horst are top of the list!

Hopefully this will help someone else.

Recent entries...