I have been asked about this time and time again. I will provide a very short description of how to create some custom filters in the Google Analytics admin area. The goal here is to have your transaction / order IDs matched up with a keyword when applicable.
Order #12345 google-organic (e-commerce)
The Advanced/custom filter option allows you to construct Fields for reporting from one or two existing Fields. POSIX regular expressions (regex) and corresponding variables can be used to capture all or parts of Fields and combine the result in any order you wish. These custom filters below will capture and match what a user typed in Google to that transaction.
Note: All this may change with the release of Google APIs or other methods of doing this
1. Login to your Google Analytics account as an admin
2. Click the “Analytics Settings” at the top left
3. Click the “edit” button next to the site you want to edit.
4. Scroll down to the Filters Applied to Profile section. Click “Add Filter”.
5. Create your first custom filter. Please to make it look exactly like the screenshot below.
6. Create your second custom filter. Please to make it look exactly like the screenshot below.
7. Create your third and last custom filter. Please to make it look exactly like the screenshot below.
8. Once you have all the custom filters, you must arrange them in order of priority. Click the Assign Filter Order link. They should all be at the top and in numerical order.
1. Transaction List #1 Advanced Edit Remove
2. Transaction List #2 Advanced Edit Remove
3. Transaction List #3 Advanced Edit Remove
9. Make sure that for each Transaction List you have added the profile to be customized to the “Apply Filter to Website Profiles” area. Basically, you select the profile from the left box and “Add” it to the right box. Click save and your done.
10. After about 24 hours, go back to the Analytic reporting area. Click on the e-commerce link at the left. Then, click on the Transactions link. This is where you will start to see some exciting information on which keywords caused which sale. Salivate!
Thanks goes out to…