Create the ultimate Google Analytics Dashboard for Drupal – Part 1

Create the ultimate Google Analytics Dashboard for Drupal – Part 1

5
By George Papadongonas 19th September 2012 Drupal

As the ability to calculate digital marketing return on investment (ROI) is critical and even the C-suite cares about conversion rates, web analytics are becoming more important. All the members of an organization start to demand more information about the web site’s statistics. As it is not enough any more to just create reports about visits and pageviews, the access to different data for different persons became necessary.

Of course, we could start creating custom dashboards inside Google analytics, but then we would have to create credentials for different persons and also train them on how to use Google Analytics (GA) and how to locate important to them information.
 
Using the Google Analytics Reports module, we can begin by easily creating a dashboard with the basic metrics inside our Drupal web site. Then, by using the Google Analytics Data Export API, we can create custom reports, to inform for example the management for KPI’s of different channels, like SEO, social media or newsletter campaigns. There reports will be easily accessible by just signing in with their Drupal accounts, without the need to use an external system. 
 
The first step is to install the Google Analytics Reports module. Prerequisites are the Google Charts API module and the OAth module. Do not forget to set the module’s permissions about who has access to the reports.
 
After installing the modules, you have to authorize your site to use data from Google Analytics, from admin/config/system/google-analytics-reports. If your domain is registered with Google Apps for Business, you can enter it in the related field. The easiest way is to authenticate with your Google Analytics account, by clicking on “Start setup and authorize account”.  
 
 
In the next step, you allow access to your Google Analytics account from the website, to obtain access to the data. If you have multiple GA profiles, you choose the appropriate one. In this step you can also choose a Query cache period, as the GA quota is 50,000 requests per project per day. 
 
 
After this step, the basic dashboard is ready at: admin/reports/google-analytics. The layout and the provided information are too basic, but at least we now have a framework to start creating our ideal dashboards.
 
 
There are also two blocks named “Google Analytics page traffic” and “Google Analytics site visits” that can be enabled for specific roles.
 
 
In the next part we are going to examine how we can use the Google Analytics Data Export API, to create more useful reports and how we can customize their layout.
 

Comments

Rob's picture
Rob
24th September 2012 - 02:09

I would be very interested to see the next post. I have set up the same as you have in the Blog post on my site and found that this is a little basic. It would be great to see how this can be expanded and customised to suit our needs. Thanks for posting on this topic.

Dan's picture
Dan
24th September 2012 - 18:09

I'll echo Rob's comments. Looking forward to the next post.

Gole's picture
Gole
19th October 2012 - 06:10

Great post. One such article on Google analytics i found and think it could be also beneficial for users ia at http://searchenginemind.com/make-web-analytics-data-informative-and-insi...

Jon's picture
Jon
21st November 2012 - 00:11

Very interesting post. However, you are pointing your link to the google_analytics module instead of google_analytics_reports

daniel truninger's picture
Daniel Truninger
21st November 2012 - 13:11

@Jon: Thanks for pointing out. Changed the link accordingly.

Add comment

Search form

Categories

Latest comments

  • accounting information systems 12th edition chapter 1's picture

    Whats up! I just want to give a huge thumbs up for the nice information you will have here on this post.

    I will likely be coming back to your blog for extra soon.

    accounting info...
    23.05.2013
  • infojunkie's picture

    Thanks for using Views Auto-Refresh and glad it's working out for you! The new version at http://drupal.org/project/views_autorefresh now uses an area handler to allow site builders to set it up. It should be functionally equivalent to the Views Hacks version, in addition to the bug fixes that went into it since it moved.

    infojunkie
    22.05.2013
  • daniel truninger's picture

    @Gurpreet

    Not sure I understand your question fully.

    If you try run this on your local without a web server you might get a bunch of errors or no unicorn at all. Vectron uses Ajax requests to get the SVG file, for this you need to have a local web server or run it on a real environment. More about this issue can be found here.

    If your question is of a different nature why not ask it over on Stack Overflow, where you can ask your question to a broader audience. I'm sure somebody there will have had the same challenge as you.

    Daniel Truninger
    22.05.2013

Open jobs at Amazee Labs

Check out our events

We are also a bit extreme!