Custom Reports: removing url parameters and combining

I've spent a couple of hours searching for this solution and have come up blank. Any assistance would be appreciated.

I've created a custom report with a couple of standard metrics (visits, goals, goal completions, goal conversion rate).

The numbers get reported ok, but what I'm seeing are hundreds of similar dimensions being listed - such as:

mysite.com/campaign1/page-one.php
mysite.com/campaign1/page-one.php?adID=23&src=Google
mysite.com/campaign1/page-one.php?adID=23&src=Bing
mysite.com/campaign1/page-one.php?adID=23&src=YAHOO
mysite.com/campaign1/page-one.php?adID=23&src=Facebook

(the same for "campaign2" and "campaign3", etc.)

How can I combine, for example, those five distinct URLs into a single group/url for reporting purposes?

 

Can you share more information? Aint getting you.
Get in touch - twitter - @bonirulzz

 

I apologize. I know in my head what I'd like done, but it doesn't always come out very well explained. Let me try again...

Instead of looking at a report that lists each landing page separately like so:
mysite.com/campaign1/page-one.php?adID=23&src=Google
mysite.com/campaign1/page-one.php?adID=23&src=Bing
mysite.com/campaign1/page-one.php?adID=23&src=YAHOO
mysite.com/campaign1/page-one.php?adID=23&src=Facebook
mysite.com/campaign1/page-one.php?adID=23&src=Twitter
mysite.com/campaign1/page-one.php?adID=23&src=LinkedIn

I'd like to group those 6 pages (and all of their pageviews and stats) into a single listing:
mysite.com/campaign1/page-one.php

When I view my reports - I see 1,000s of URLs but most of the time it's the same page (like "page-one.php") but with different parameters...

I'd like to have all "page-one.php" combined.

 

Hi Michael,

I Understood your problem. Here is the solution:-

1) Go to Admin
2) View Settings
3) Exclude (the idea is to exclude parameters like adID and src from reporting in pageviews)
4) Enter adID and src
5) Save

We told GA to exclude parameters(for reporting) by explicitly mentioning them in the exclude section.

Refer to this link for more info: http://actionablewebanalyticstips.wordpress.com/2012/02/21/excluding-url-query-parameters-from-google-analytics/
Hope this helps
Boni

 

Indeed that does help. Thank you! I'll follow those steps and monitor...

 

Hi - how did this one pan out for you Michael?

I have a similar problem in that I want to remove a query string beginning '?app_data' which seems to be appearing randomly in URLs in GA landing page reports, splitting a single landing page over several different results.

The string always begins '?app_data=' and then includes a series of numbers, letters and special characters which do not necessarily follow a fixed format but which always end with a curly bracket, i.e. }

I want to remove this from my reports but I do not want to affect any cmapaign tracking (I am worried that excluding all query parameters will strip this out).

I was hoping that there would be a regex I could use but none of them appear to work without affecting campaign tracking. Is there a way to exclude specific campaign parameters?

Thanks

G

 

So far it looks as though it's working as expected!

If you simply want to remove the '?app_data=' string from displaying in your results, then go under ADMIN > VIEW SETTINGS > "Report View Settings"

Just add "app_data" (no quotes) in the "Exclude URL Query Parameters" box.

It's not retroactive so only future reporting should show that Parameter being off your stats.

 

@glava -what michael should work for you

 

Just add "app_data" (no quotes) in the "Exclude URL Query Parameters" box worked for us