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:
You can choose to include or exclude depending on your needs. Then simply save to dashboard and you’re good to go.