I have a search page on a hotel property website that can have up to 12 parameters in the url. Note that sometimes it may have none of these parameters. The parameters are all for optional facilities that the hotel could provide. If the parameter is present it's value is always 'Yes'.
What I want to do is simply create a visual report such as a bar chart within Data Studio that shows a count of page views for each of these 12 parameters.
To do this I started making custom dimensions using the following REGEX. Each dimension looks for a specific url parameter. In this case 'offers'. To clarify, there are 3 possible scenarios here. A page may not have the url or it may have it with either 'Yes' or 'No' as a value.
REGEXP_MATCH(Page, '(?i)\boffers=yes\b' )
I know that this is definitely a valid REGEX expression that can detect the url parameter "offers=yes", and it can do this without case sensitivity.
However even creating a simple table with dimensions using the exact REGEX above and a third column using the 'Page' dimension never seems to show a 'true' result in my table.
Ultimately I want to visualise this into a bar graph that shows columns for the number of references to each url parameter I am tracking, irrelevant of the page the parameter was part of. Here is a mockup of this ideal end result...