Analytics
2.3K members online now
2.3K members online now
Ask questions about filter set-up and issues with using filters in Google Analytics reports
 
Guide Me
star_border
Reply

How to group by filters regexp

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

I am using https://ga-dev-tools.appspot.com/query-explorer/ to retrieve some data.

 

This is my query:

  • start-date
    • 2016-04-01
  • end-date
    • 2016-06-30
  • metrics
    • gaSmiley Tongueageviews
  • dimensions
    • gaSmiley TongueagePath
  • sort
    • -gaSmiley Tongueageviews
  • filters
    • gaSmiley TongueagePath=~/mysellingprocess/product1/

 

This returns data as follows, e.g.

Page Pageviews

/mysellingprocess/product1/step13,987
/mysellingprocess/product1/company1/step211
/mysellingprocess/product1/company2/step23

 

Ideally, I would like instead to group by steps, so that I would get e.g.

Page Pageviews

/mysellingprocess/product1/step13,987
/mysellingprocess/product1/*/step214

 

Is it possible to do that directly in Google Analytics/Google Query Explorer?


Thanks a lot

1 Expert replyverified_user
Marked as Best Answer.
Solution
Accepted by topic author Michele D
July 2016

Re: How to group by filters regexp

Top Contributor
# 2
Top Contributor
Unfortunately no, that would be a job for Excel or your favorite pivot-table-capable spreadsheet tool
VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Re: How to group by filters regexp

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
OK, pity! Smiley Sad