I need to set up a filter (or segment) so we can view all product page stats together in one report. In other words we need to be able to report on just a list of product pages for "Pageviews", "Bounce Rate", "Revenue" and so on like you can view under "Site Content".
I have been looking for filters and segments for the past hour or so to do this but as our urls don't have id= for product ids so I can't work out how to tell analytics I want a report on pages that end in /productnumber only!?
Our url structure for products/categories is:
The number at the end is a random product number as you likely guessed ;)
So my plan was to set up a filter or segment saying if the url starts with /products and ends with /number include it in the report.
My problem is I can't find how to do this! For example, what would you put in for /number to tell analytics to only include urls that end with /random-number? I know I should be able to create a regular expression on the filter so only urls with numbers will appear be used with Regex, but I can't work out the code to enter in the filters.
Can anyone help me with the code for this one as I have tried a few different ones I thought might work with no luck and I don't want to continue trying more 'random' codes in case I mess something up.
FYI: I'm adding these filters to a copied profile not the original and know it will only work for new data not old data.