{"id":385,"date":"2018-12-25T13:48:00","date_gmt":"2018-12-25T08:18:00","guid":{"rendered":"https:\/\/testing.radon-media.com\/?p=385"},"modified":"2024-02-12T15:07:50","modified_gmt":"2024-02-12T09:37:50","slug":"how-to-exclude-query-parameters-from-urls-using-google-analytics-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.radon-media.com\/blog\/how-to-exclude-query-parameters-from-urls-using-google-analytics-spreadsheet\/","title":{"rendered":"How to exclude query parameters from URLs using Google Analytics spreadsheet"},"content":{"rendered":"\n

Did you ever looked at your Google analytics content report and found a confusing result displaying different page views reports for the same page? And then you have to sit and carry out a tedious job of filtering each result to get an actual total value. \u00a0<\/strong><\/p>\n\n\n\n

But why did this happen?<\/p>\n\n\n\n

Well, the reason for this confusion is \u201cQuery Parameters\u201d<\/p>\n\n\n\n

Query Parameters<\/h3>\n\n\n\n

\u2018Query parameters\u2019 can transform an ordinary URL into a never-ending string of characters. Each website is built on parameters and each parameter has a purpose. These parameters are added to a URL when a visitor navigates deeply through a website, land on a page or come to the site through a specific digital marketing campaign.<\/p>\n\n\n\n

If you have ever tried Google analytics content report, you must have realized how difficult it gets to navigate these URLs. The number of pages can multiply with just the addition of a few parameters, making it difficult to navigate.\u00a0<\/p>\n\n\n\n

Example of Query String<\/gwmw><\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n

As you can see the URL is difficult to read and decipher, also changing any one single parameter from the URL may signal Google analytics to treat it as a different page altogether.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The above screenshot is an example of how a single page \u2018myaccount.html\u2019 is reported differently using a different URL each time. So you need to analyze every URL in order to get the real value. It doesn\u2019t seem like a daunting task for the current website with just a few different URL\u2019s, but websites with thousands and millions of page visitors cannot afford to invest time and efforts to filter each URL to get the actual value.<\/p>\n\n\n\n

Problems with Query Parameters<\/h3>\n\n\n\n