Skip to content


How to Filter Google Checkout Transactions in Google Analytics

Hey everybody!

I’ve been neck deep in work (and loving every second of it) since landing the position of ecommerce manager at AVISPL, but I need to chug out a post – even if it’s a quick one  - just so I get back into the blogging mindset again.

One of the things we’ve been working on since I arrived is trying to close the loop on transaction reporting, specifically matching up final transaction and revenue numbers to reported phone and web sales.

Google Analytics ecommerce tracking was already implemented, but we weren’t recording the Google Checkout transactions – an easy enough fix, but then we wanted to filter out those transactions vs the transactions that took place on the site.

The problem was there’s no easy way to set up an advanced filter to show only those transactions that went through Google Checkout. The only difference in transactions was the length of the transaction number.

Regex to the rescue! Here’s what you do:

Go to the Goals > Ecommerce > Transactions tab in Google Analytics. In the on-page filter box, edit the filter and select regex, then add this regex code:

^\d{1,8}(\s+\d{1,8})*$

You can choose to include or exclude depending on your needs. Then simply save to dashboard and you’re good to go.

Posted in Analytics, Google.


12 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

  1. Jeremy says

    Any insight on how to filter this same way but through Custom Reports or Advanced Segments? Every time I’ve attempted to, it always gives obviously incorrect data.

    Any insights would be great!
    Jeremy

  2. on-line marketing says

    Pretty great post. I simply stumbled upon your blog and wished
    to mention that I have truly loved surfing around your blog posts.
    After all I’ll be subscribing on your rss feed and I’m hoping you write again very soon!

  3. roofing Contractors worcester says

    I think the admin of this web site is truly working hard for
    his web site, for the reason that here every information is quality based data.

  4. Gino says

    Hey, I think your site might be having browser compatibility issues.
    When I look at your blog site in Chrome, it looks fine but when opening in
    Internet Explorer, it has some overlapping. I just wanted to give you a
    quick heads up! Other then that, excellent blog!

  5. www.Amazon.com says

    Thanks for another fantastic post. Where else could anybody get that kind of information in such an ideal manner of writing?

    I’ve a presentation subsequent week, and I am on the search for such information.

  6. www.pixiepalace.com says

    I’m not sure exactly why but this website is loading incredibly slow for me. Is anyone else having this problem or is it a problem on my end? I’ll check back later
    on and see if the problem still exists.

  7. Agueda says

    Its like you read my mind! You seem to know a lot about this, like you wrote
    the book in it or something. I think that you could do with some pics to drive
    the message home a little bit, but instead of that, this
    is great blog. A great read. I’ll certainly be back.

  8. Anonymous says

    Hey there! I’m at work surfing around your blog from my new apple iphone! Just wanted to say I love reading your blog and look forward to all your posts! Carry on the excellent work!

  9. Monserrate says

    Hi there, You have done a fantastic job. I will definitely digg it and personally
    recommend to my friends. I am confident they’ll be benefited from this web site.

  10. Shantell says

    Great post! We will be linking to this particularly
    great article on our site. Keep up the great writing.

  11. Jerry says

    Just wish to say your article is as astonishing. The clarity
    in your post is simply spectacular and i could assume you’re an expert on this subject. Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please continue the rewarding work.

  12. amme says

    Thank you, this post totally solved my problem. I’ve been looking for a solution to this for hours and just happened to stumble on your blog. :)



Some HTML is OK

or, reply to this post via trackback.