How to Create a Google Analytics Custom Report
We are drowned in too much data and it becomes so overwhelming we start to ignore analytics. Application developers keep on adding on more and more analytics whereas sometimes we just want a simple report.
Do you celebrate your good results? We do! Here’s a picture of my mum and dad when we were out celebrating a good month. We’re Irish so of course we celebrate over a drink!
Ok, Let’s move on!
Google analytics provides you with the ability to create custom reports which can be e-mailed to you daily, weekly or monthly. You can set up these reports so they are suitable to your needs and this means you can ignore the noise and focus on what is important to your business.
One part of our site that is important to us is e-mail conversions. I want to know how many conversions we get and I want to know what is the source of these conversions. Is it from twitter or Facebook, from guest blogs we did, articles we appeared in or other. If you know you get great conversion from a particular task or site this encourages you to do more of it.
In this post I give a demonstration of a weekly report I set up based on eMail conversions on the site.
1. Creating the report
In Google Analytics select the customization option followed by ‘New Custom Report’.
In the example below the report we want is one that shows where traffic is coming from, how many email conversions we get from this traffic and what is the overall conversion rate. We want to see is Facebook working better than twitter, is guest posting on blogs working on some blogs better than others etc.
Note: For this to work you will need to set up goals. Read our post on which shows how to set up goals in google analytics.
1 Enter the overall name of the custom report.
2. Within the report you can have multiple sub reports. So add one on if you want one!
3. Each sub report needs a name.
4. Decide on the type of report you want.
- Explorer report – This is the same style you are used to when looking at Google analytics data.
- Flat Table – The flat table report is if you want a very basic table report, you’ll probably use this if you want to export your report to excel.
- Map Overlay - The map overlay report is a report that shows you your data on a map. Use this if you want to see results by country.
5. Metric Groups – These are the rows within the table that you want displayed. In our example above I have selected the following:
- New Visits – The number of new visits to the site (this will be broken down by source, see dimension below)
- eMail Conversion Goal – The total number of people that converted to an e-mail subscriber
- eMail Conversion Rate – The percentage conversion which is visits divided by goals achieved.
6. Dimension Drill Down – This is how how you want the metrics above displayed. In our case I want to display the source (where the traffic is coming from) so I can see where we are getting the best conversion.
7. Filter – You may want to filter out some traffic or data from your report.
8. Additional Profiles – If you have more than one website you may want to use this report for other websites/profiles.
Running the Report
When you run the report you see a graphical display which shows the visits and then it will show a summary of statistics for visits and conversions.
You can also drill down to find out what the traffic is coming from and which channel is getting the best conversion. In the example below LinkedIn is achieving the highest conversion rate so this could be a channel we should spend more time on.
2. Set up an automated eMail
Once you have a the report set up you should then set up an automated eMail so you get it on a weekly basis. By reviewing these figures on a weekly basis this will help significantly to focus your attention on improving conversion and spending time in the right places!
Then configure the settings for the email you want sent. You can define the address you want it sent to, the day of the week it should be sent, format of the report etc.
So there you go! Now you’re ready to set up a Google analytics custom report and you will become more focussed on conversion.
Let me know if you have any custom reports and/or if this post was useful to you.