AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Analytics
4.4K members online now
4.4K 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
1 ACCEPTED SOLUTION

Accepted Solutions
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

View solution in original post

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