Google Analytics transform report data

I want to build a custom report on the past year's (historical) data in Google Analytics that has a custom column that's a transformation of data from another column.

That is, I want to strip out the querystring and /##### at the end of the URI to make another column so that all pages are grouped properly. I don't want to filter the raw data that's coming into GA, just the data on the report.

Is this possible?

1 answer

  • answered 2019-09-11 21:44 Michele Pisani

    It is not possible in Analytics reports. You can export the data in a Spreadsheet (or Excel) and clean it, or in the reports you can filter all the desired rows (eg with a regex) and read the total values ​​of the metrics in the total row (under the header of the tabele).