GA Experts came up with a way to get detailed PPC keyword data from Google Analytics. In case you need some extra help to configure this filter for www.domain.com, follow the instructions below.
- Go to the GA Account for domain.com.
- Click on Filter Manager.
- Click on Add Filter.
- For Filter Name, use something like Data Filter – PPC Keywords 1
- Filter Type is Customer filter.
- Choose Advanced.
- For Field A -> Extract A, choose Referral and enter in (\?|&)(q|p)=([^&]*)
- For Field B -> Extract B, choose Campaign Medium and enter in cpc|ppc
- For Output To -> Constructor, choose Custom Field 1 and enter in $A3
- The next 3 options should be yes followed by no for case sensitive.
- Hit Save Changes.
- Click on Add Filter.
- For Filter Name, use something like Data Filter – PPC Keywords 2
- Filter Type is Customer filter.
- Choose Advanced.
- For Field A -> Extract A, choose Custom Field 1 and enter in (.*)
- For Field B -> Extract B, choose Campaign Term and enter in (.*)
- For Output To -> Constructor, choose Campaign Term and enter in $B1, ($A1)
- The next 3 options should be yes followed by no for case sensitive.
- Hit Save Changes.
- Almost done! Click on the link that says Analytics Settings, then click on +Add Website Profile.
- Choose “Add a Profile for an existing domain” , make sure your domain is chosen, and enter in PPC Keywords for the Profile Name. Click on Finish.
- Click on Edit besides the PPC Keywords profile. Configure Main Website Profile Information, Conversion Goals and Funnel, and Users with Access to Profile just like it was configured for the other profile.
- Click on +Add Filter, choose “Apply existing Filter to Profile” , choose you’re other filters (if applicable) along with the two new filters you just created. Make sure Filter – PPC Keywords 1 comes in the list before Filter – PPC Keywords 2. In fact, these should probably be the top two filters. Hit Finish.
- Click on Analytics Settings. Your new profile will have data in it within hours or days depending on website traffic.