Posted by: Evaldas Balcius
Posted on: July 25, 2012 10:27 am
If you are using Google Adwords and Google Analytics pre-set reporting features to produce the KPI reports, you may find that there is no an easy way how to show all the Pay per Click and other website stats (such as clicks, costs, ctr, cpc, conversions, CPA, avg. visit duration, bounce rate, etc.) in a single report. This tutorial will guide you through the creation of combined Google Analytics and Google Adwords stats using “Custom Reporting” and Google Analytics Filters.
The following examples will demonstrate what type of reports you can generate using a mix of custom reporting and Google Analytis filters’ features.
*Please be aware these reports are just the examples of what you can do with custom reporting.
Examples of “Custom Reports” for Google Adwords traffic
1. An example of a custom report for lead generation website reporting the KPIs such as clicks, cost, CTR, CPC, leads, cost per lead, conversion rate, avg. site duration, bounce rate and pages/visit.
2. An example of a custom report for ecommerce site website reporting the KPIs such as visits, impressions, clicks, cost, CTR, CPC, Revenue and ROI
How to configure Google Analytics in order to produce combined PPC reports
1. Create new analytics profile. Login to your Google Analytics account you want to report and create a new profile (Admin – > “+New Profile”). Set an appropiate name for that report like domainname.com – PPC reporting.
2. Set a filter to include Google Adwords traffic. Stay in the admin area and select the profile you have just created. Click on the “Filters” tab and create two new filters (the first one for CPC medium and a second for Google source).
Filter for CPC medium
Filter for Google source
3. Link Google Adwords and Analytics accounts. Link the Analytics profile with Google Adwords account to want to report. You can do it by clicking on the “Profile Setting” tab, then going to the “Adwords Cost Source Settings” section and ticking the box on the adwords account you want to link. (You must have the administrator rights for Adwords account you want to link)
4. Set goals. Configure Google Analytics goals. More info about setting GA goals can be found here
5. Create custom reports. Click on “Custom Reporting” button, which is located in the top menu and create new custom report. Then you will a see window where you can design you own report with the metrics you want report. It is all done, you just need to configure all the parameters and metrics.
The image below is the design view of the first example.