8 replies to this topic

[DJKay]

Hi There-

I am a marketer by trade but have been learning some RegEx. I have figured out all but one step of the goal set I need. The ugly urls I have to work with are these:

Step 1: subdomain.mydomain.com/folder/US/register.aspx?u=db1227

Step 2: subdomain.mydomain.com/folder/US/register.aspx?s=&usergroup=US&order=06f99883-7a1e-4d30-ab43-bf746271c6b5&step=summary

Step 3: subdomain.mydomain.com/folder/US/register.aspx?s=&usergroup=US&order=06f99883-7a1e-4d30-ab43-bf746271c6b5&step=payment

Step 4: subdomain.mydomain.com/folder/US/register.aspx?s=&usergroup=US&order=06f99883-7a1e-4d30-ab43-bf746271c6b5&step=receipt

With steps 2, 3 & 4, I can use step=summary, step=payment and step=receipt respectively in RegEx GA goal set up and they work fine. Its Step 1 I am having problems with.

Step 1 can include any number of the following string iteration types:

subdomain.mydomain.com/folder/US/register.aspx?u=&s=
subdomain.mydomain.com/folder/US/register.aspx?u=us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=14-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db0103-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db1229-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=1227-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln1220-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db1227-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln1227-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln14-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=bejemployee&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db0106-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln1121-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln23fin-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db1202-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=Column5HR-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db0106&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db1219-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln1121us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=e12a0e27-8c8d-48f2-967d-49a671e3bd68
subdomain.mydomain.com/folder/US/register.aspx?u=Add&s=
subdomain.mydomain.com/folder/US/register.aspx?u=column5hr-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=DB0106-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=db1227
subdomain.mydomain.com/folder/us/register.aspx?u=ln104-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln24cpe-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=ln24fg-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=lnfin-&s=
subdomain.mydomain.com/folder/US/register.aspx?u=test-jhan-us&s=
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=7bd05a0c-3acd-4291-b9df-2a8f0f0e1e37
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=7dc526ec-6b14-482e-a7c9-d0e23fc7e1c8
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=98327d3f-4f82-4143-b401-f568d34ba2ff
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=ae1ffc0b-b5e9-47cb-bc92-c431fbebcf8c
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=b687b6da-990f-4985-8c4e-a0620c55012f
subdomain.mydomain.com/folder/US/register.aspx?u=us&s=c3f28ee8-5335-4807-a847-2f26dfde341d
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=d2914f43-4701-48f4-a0b7-211a44e2674d
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=d5b16f85-cc79-4ecd-b811-e1d391c130cf
subdomain.mydomain.com/folder/US/register.aspx?u=US&s=e9e993b2-8131-470a-8ac0-a1c4d9afc5eb


I have tried multiple iterations but cannot get it to work when I put it in the pages report under content to test. I am offering two free drinks on me at the next SEMNE meeting in Framingham if they can come up with a Regex that works.

Thanks,

DJKay

[Jill]

You know I'd do just about anything for free drinks, DJkay, but I don't even know what Regex is. Plus I won't be at the next SEMNE event as I'll be in Hawaii!

[DJKay]

You know I'd do just about anything for free drinks, DJkay, but I don't even know what Regex is. Plus I won't be at the next SEMNE event as I'll be in Hawaii!

Good for you Jill! We will miss you! RegEx stands for regular expressions, its the third option after exact and head match in Google Analytics. I have talked to my IT department until I am blue in the face but to no avail.

So..like I said, I will buy you two free drinks at the next SEMNE meeting in Framingham.

Thanks, DJKay

[DJKay]

Well -- I just found out that because we use something called "negative look up" GA regular expressions don't necessarily work for us. So I am just going to have to wait until they apply the program I had them develop to create fake urls which show up in GA and can be used in exact match.

DJKay

[Jill]

Oh, you're talking about Google Analytics. I don't think you mentioned that anywhere. I'll move this to the Analytics forum.

[DJKay]

Yes, absolutely Jill..Thanks, Mary Kay

[Tiggerito]

Can you show us what you have so far.

My guess would be:

1:
/folder/US/register\.aspx\?u=.*

2:
/folder/US/register\.aspx\?.*step=summary

3:
/folder/US/register\.aspx\?.*step=payment

4:
/folder/US/register\.aspx\?.*step=receipt

[DJKay]

Can you show us what you have so far.

My guess would be:

1:
/folder/US/register\.aspx\?u=.*

2:
/folder/US/register\.aspx\?.*step=summary

3:
/folder/US/register\.aspx\?.*step=payment

4:
/folder/US/register\.aspx\?.*step=receipt

Hi - Thanks for the try - they don't work. I put them into the search under the pages report in the content section and they are not yielding anything.

DJKay

[DJKay]

Tiggerito - They work. Thanks a bunch. I am very excited. One caveat I want to throw out, the mistake I was making was not going to the section withing the pages report that says "advanced filter". This feels like a new GA feature but I don't know. Then you need to make sure you match the pull down to "matching Regex' expression.

Thanks DJKay

Hi - Thanks for the try - they don't work. I put them into the search under the pages report in the content section and they are not yielding anything.

DJKay