google analytics api query a specific url

Question

I am accessing the Google analytics API with PHP which works on my end but I'd love to filter the results a bit further. Right now I am using:

$OBJresult = $analytics -> data_ga -> get(
    'ga:' . $profilID,
    '2012-01-01',
    date( "Y-m-d" ),
    'ga:visits',
    array(
        'dimensions' => 'ga:pagePath',
        'metrics' => 'ga:pageviews',
        'sort' => '-ga:pageviews',
        'max-results' => '25'
    )
);

Currently this returns a set of 25 pages sorted by its hits. I would love to restrict the results to a specific path within the server. So e.g. only query domain.com/news and only see what the most hit news pages are. I can filter with PHP but rather have the query as specific as possible.

Thanks for the help

klipach · Accepted Answer · 2015-03-20 08:37:27Z

19

Use the filters option.

$OBJresult = $analytics->data_ga->get(
    'ga:' . $profilID,
    '2012-01-01',
    date("Y-m-d"),
    'ga:visits',
    array(
        'filters' => 'ga:pagePath==/news',
        'dimensions' => 'ga:pagePath',
        'metrics' => 'ga:pageviews',
        'sort' => '-ga:pageviews',
        'max-results' => '25'
    )
);

See here for the list of page tracking dimensions you can filter on.

edited Mar 20, 2015 at 8:37

klipach

8167 silver badges22 bronze badges

answered May 24, 2013 at 5:33

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dominik Over a year ago

thank you! I actually found using the == insteat of =@ works better for me but same problem here: can I filter the absolute address? so domain.com/interviews/article/news would not be found in the result for 'filters' => 'ga:pagePath==/news',?

Barmar Over a year ago

== should be an exact match, =@ looks for anything that contains the expression. See developers.google.com/analytics/devguides/reporting/core/v3/… for all the operators you can use in filters.

Dominik Over a year ago

yeah well thats the problem. this now returns nothing as /news alone is not a page but domain.com/news/something is.... so I guess I am looking for something like 'filters' => 'ga:pagePath==/news*',

Dominik Over a year ago

ended up using 'filters' => 'ga:pagePath=~^/news/', thanks again!

Barmar Over a year ago

You might also want to look at ga:pagePathLevel1, which just matches the first directory of the path.

|

David Shaw · Accepted Answer · 2013-05-24 05:45:20Z

11

You need to use the filters string to say "if path includes /news" which can be done as follows:

$OBJresult=$analytics->data_ga->get(
    'ga:'.$profilID,
    '2012-01-01',
    date("Y-m-d"),
    'ga:visits',
    array(
        'filters' => 'ga:pagePath=@/news',
        'dimensions' => 'ga:pagePath',
        'metrics' => 'ga:pageviews',
        'sort' => '-ga:pageviews',
        'max-results' => '25'));

The answer supplied by Barmar will only find an exact match for the /news page.

answered May 24, 2013 at 5:45

David Shaw

5651 gold badge4 silver badges13 bronze badges

1 Comment

Dominik Over a year ago

thats it really. thanks! though this will look into the url and find all urls that have "/news" in its path. domain.com/news/article and domain.com/interviews/article/news alike... is there a way to limit to domain.com/news/?

Robert Sinclair · Accepted Answer · 2018-03-22 03:30:56Z

Reporting V4 example that may be useful. Thank god for these queries, their objects and poor documentation can cause severe ass cancer..

function segmentRequest(&$analyticsreporting) {

$query = [
        "viewId" => "XXXXXXX",
        "dateRanges" => [
            "startDate" => "2018-02-01",
            "endDate" => "2018-02-15"
        ],
        "metrics" => [
            "expression" => "ga:pageviews"
        ],
        "dimensions" => [
            "name" => "ga:pagepath"
        ],
        "dimensionFilterClauses" => [
            'filters' => [
                "dimension_name" => "ga:pagepath",
                "operator" => "EXACT",
                "expressions" => "/en/some_cool_page.php"
            ]
        ]
    ];

  // Call the batchGet method.
  $body = new Google_Service_AnalyticsReporting_GetReportsRequest();
  $body->setReportRequests( array( $query) );
  $response = $analyticsreporting->reports->batchGet( $body );

  printResults($response->getReports());
}

Collectives™ on Stack Overflow

google analytics api query a specific url

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related