Add to Google Add to Bloglines Add to Newsgator Add to Yahoo! Contact ROI Revolution Sign Up for the ROI Newsletter Unofficial Google Analytics Blog Feed Unofficial Google Analytics Blog
Unofficial Google Analytics Blog by ROI Revolution

Categories Search This Blog Blogroll Archive

| |

February 18, 2008

Update to Matching Specific Transactions to Specific Keywords

By Jeremy Aube, Google Analytics Support Tech

Money ShirtShawn wrote an article back in May which showed you how to use filters in Google Analytics to modify your transaction list to see source, medium and keyword data for each transaction. As many of you have noticed by now, there have been some issues since January 15th involving custom fields which have caused this and other advanced filters to stop working.

Since then, we have found a way around using custom fields for this particular set of filters. Your reports will look and function as before.

Here are the details:

Using the same naming convention as in Shawn's post, this first filter will be called Trans List Mod 1. It will append the campaign source to the transaction order id.

Click here for Filter #1

The second filter appends the campaign medium to the now modified transaction order id. After this filter, the "e-commerce transaction id" field should now contain the campaign source and medium of the visit in addition to the transaction order id.

Click here for Filter #2

The final filter appends the keyword (bid term only) to the modified transaction order id. So now the "e-commerce transaction id" field should contain source, medium, and keyword info for the transaction in addition to the transaction order-id.

Click here for Filter #3

There you have it! Again, if you need more information about why you might want this filter set and what it will do for you, refer to Shawn's article. Once we are able to use custom fields again there will be zero benefit to using this filter set over Shawn's. This is just an alternate way to get this same data in your reports that happens to not use custom fields.

Find The Secret To Solid, Sustainable Improvements To Your Website
Learn the insider secrets to making more money from your website than ever before – Guaranteed! Get started right away with the Google Analytics Training Course.

Posted by Jeremy Aube at 11:56 AM









Filed under:

TrackBack

TrackBack URL for this entry:
/mt/mt-tb.cgi/283.

Comments

You speak like custom fields are definitely coming back - is that the case?

Posted by: Tyson at February 18, 2008 4:31 PM

@Tyson Yes, you will be able to use custom fields again at some point in future. Google is aware of the issue and is taking steps to resolve it. I am merely giving this alternative so that we can still have this data in the meantime.

Posted by: Jeremy Aube, Google Analytics Support Tech Author Profile Page at February 19, 2008 8:58 AM

Great, just read Shawns article. Simple to setup and should produce the association between referrer and transaction that is likely to save me a heap of time.

Posted by: Richard at February 27, 2008 5:48 PM

@Richard:

Thanks for reading! We actually use that method ourselves and have found it to be a great help. I hope it proves as useful to you!

Posted by: Shawn Purtell, Google Analytics Support Tech Author Profile Page at March 3, 2008 9:29 AM

If and when we're able to use custom fields again, would there be any reason to switch back to Shawn's original filter setup? If Jeremy's filters work equally well, I'd imagine we could just stick with those.

BTW, thanks *very* much for the workaround. We're trying it out today...

Posted by: Winooski at March 3, 2008 11:33 AM

@Winooski: No, there would be no reason to switch back. Both filter sets function exactly the same. Similarly, once custom fields start working again, anyone using Shawn's filters shouldn't bother switching to mine.

You're welcome :)

Posted by: Jeremy Aube, Google Analytics Support Tech Author Profile Page at March 3, 2008 12:57 PM

I just added these filters without success. Will the data be 'granfathered' into the previous transactions or only work from here on out?

Posted by: Marco at April 25, 2008 2:17 PM

@Marco:

These filters, just like all filters within Google Analytics, only apply to the data moving forward. Your historical data is not affected. In a day or two you should see results from the filters.

Posted by: Shawn Purtell, Google Analytics Support Tech Author Profile Page at April 28, 2008 8:19 AM

The filters seem to be working fine, they are gathering the source, keyword etc but the unique transaction id no longer appears, it is just the source, etc.

Any ideas?

Posted by: Dan at June 2, 2008 8:30 AM

@Dan: Without seeing your setup, I can't say for certain what the issue is. I would double check the first filter and make sure that it matches the one I gave. Leaving out the parentheses on the first field or something like that could potentially cause the issue. You might also what to create a raw profile and see what the transaction id looks like without filters.

Posted by: Jeremy Aube, Google Analytics Support Tech Author Profile Page at June 2, 2008 8:50 AM

@Jeremy:

I removed the filters and the tracking returned to normal. Our transaction ID's are simple unique numbers (TS-5373262).

The filters were exact, I triple checked them and got others to check for me.

Everything worked fine, except it overwrote the unique ID.

Posted by: Dan at June 2, 2008 7:28 PM

@Dan: Have you tried Shawn's filter set? It's function is the same as this one and should work fine now that custom fields are working again. There may be a temporary issue that's causing these to not work anymore. Also see this article which gives you a way to segment reports by transaction id, allowing you to get much of the same data without the need for filters.

Posted by: Jeremy Aube, Google Analytics Support Tech Author Profile Page at June 2, 2008 11:22 PM

Post Your Comments

Post a comment

Contacting ROI Revolution

Telephone Number:
(919) 954.5955 ext. 306
ask for Meredith Smith

Office Fax:
(919) 954.4767

Address:
3109 Poplarwood Ct.
Suite 219
Raleigh, NC 27604


Authorized Google Analytics Consultant

Google Analytics Certified Service and Support Consultant


Free Webinar!

Join a Live FREE Google Analytics Training Webinar
Register now to learn how to
turn Google Analytics into
pure profit! You'll learn how to use many of the key reports, a ten-step system for properly configuring Google Analytics on your website, and how to apply what you learn to the attainment of your online goals. Register for our free Google Analytics training webinar today.


Subscribe to the
ROI Revolution Google
Analytics Newsletter today

Free monthly email publication that contains valuable, practical tips, secrets, and much more! Subscribe to our free Google Analytics newsletter today.


Looking to Purchase
Urchin 5 Software or Fee
Based Support?

We are a Urchin software certified service and support partner! Buy Urchin 5 software, profile packs, load balancing modules, campaign tracking, or fee-based support today.