Home DevShare Designing BIRT Reports

Google Analytics ODA Plugin

Share

Designs & Code

by arjung

DevShare - 1 postLeaderboard - 1 timePoll Voter
Posted 15 Apr 2012 - 03:52 AM

(8)  (0)   (907 views)

Download (3.91 MB)

By downloading this item, you are agreeing to the Terms of Use for the site.

Google Analytics ODA plugin extracts data from from Google Analytics account and feeds the same to Birt, which can be used to create custom reports.

Birt Version:-2.5

This devshare submission qualifies for Plug In 2 BIRT Contest

Have you ever created an account in Google Analytics to monitor your web pages ?? Just Try it once, as this is one of the wonderful web service provided by google. You can pulll out loads of information using this service like who all visited your page and other lots of informations...

         So why cant we have a ODA plugin for Google Analytics in Birt ??? and now here it is ... 

This custom ODA plugin can query Google analytics with your google credentials and extracts data from the same and you can use this to create your custom reports..You have to register your website in Google Analytics to pull out reports .

Please download the files attached with this submission.. you will find all you needed there...

I have attached a user guide which will take you through an introduction of Google Analytics, then about the plugin and a detailed explanation of how to use the plugin ( even though its very simple) 

Just copy the jar files to your eclipse plugin directory and you will be ready to use the plugin. Querying protocols is explained in the guide and some sample queries are attached :). Also a sample report is there which may help you to explore the plugin . :) you can use the demo google credentials which i have specified in the user guide to start with the plugin if you dont have a google Analytics Account.

I believe in the quote 'Nothing is Perfect ' .. please help me to find out the problems in the plugin, if any and also give your valuable suggestions :)

Download (3.91 MB)

By downloading this item, you are agreeing to the Terms of Use for the site.


Post a Comment

DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 16 Apr 2012 - 11:35 AM

Just updated the Jar files as there was a problem regarding the proper naming conventions of jars :)

NehaM

Posted: 18 Apr 2012 - 08:56 PM

Nice Idea... The ODA is working great :)
Forum - 500 postsDevShare - 50 postsBlog - 25 postsPoll Voter

averma

Posted: 19 Apr 2012 - 02:12 PM

The oda works great, thanks for your submission. Couple of changes could make it even better - 1. Hide the password 2. Provide a query template in the data set query editor
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 19 Apr 2012 - 09:23 PM

Thanks Ashwini.. I will do the change :)
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 20 Apr 2012 - 06:31 AM

Hi Ashwini, I jus made all the changes .. please download the new jar files and just try out :)
Forum - 10 posts

madhur

Posted: 26 Apr 2012 - 08:01 AM

Hi Arjun, Thank you very much for the plugin.I'm trying to add some filters to my query like this<filters>ga:customVar1==Val1</filters>But it is not filtering properly. Any idea about this?
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 26 Apr 2012 - 11:28 AM

Hi Madhur ..:)Thank you for trying out the plugin... You cant give a filter like that... The plugin doesnt support filters in query as if now except date.... Somehow you can add custom filters from 'edit data set' window :)
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 26 Apr 2012 - 11:33 AM

Hey guys.i wanted to bring one thing into notice as many people asked me this .you can add multiple dimension and metric tag in your query.(valid combinations). :) just explore google analytics to understand more about dimensions and metrics. :)
Forum - 10 posts

madhur

Posted: 26 Apr 2012 - 08:54 PM

Ok. Thanks :-)When I created a Data set using GA, it has automatically added a parameter under parameters named param_1. Do we need that? Is it ok if I remove it as I don't need a parameter.?
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 26 Apr 2012 - 09:01 PM

@madhur, Sure .. you can remove that :):)

Maria Elsa

Posted: 03 May 2012 - 08:04 AM

Hi Arjun, Your Plugin is workin awesome.. Dont we need access tokens and all to connect to Analytics using Google Account ??
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 03 May 2012 - 09:19 AM

@Maria : Hi Maria, for this plugin forget about all access tokens and secret keys. Just give your username and password..Thats all you need :)
DevShare - 10 postsForum - 100 postsCommunity AdvisorPoll Voter

Megha Nidhi Dahal

Posted: 16 May 2012 - 04:28 AM

Amazing idea. The ODA is very well written as well. Great work Arjun! To make use of dynamic parameters, you can make use of query string substitutions on the beforeOpen method of the data set.
DevShare - 1 postLeaderboard - 1 timePoll Voter

arjung

Posted: 16 May 2012 - 06:17 AM

Thanks Megha....

viltor

Posted: 31 Oct 2012 - 06:27 AM

Hi, thanks for your plugin, is amazing, but i cant run it. When i make the query, i cant push the OK button for accept. it look like disabled. I think that it is because the query rules changed and now the plugin doesnt work. Best regards
 
Participate

Contribute to DevShare

Help make DevShare even better by adding items you think others will find useful.

Filter by Topic
All Topics
Designing BIRT Reports
Ad Hoc & Interactive Reporting
Spreadsheet Automation
Deploying BIRT Reports
Using BIRT with Rational
Using BIRT with Maximo
Filter More
Filter Clear