Question about connecting Google's web analytics API and QlikView

[#1]

Hey all,

I am working on web analytics here at QlikTech and am wondering if anyone else has tried to hook Google Analytic's API into QlikView. Google's analytics is certainly a great value but I am really interested to see how much more powerful the data can be when tied with QlikView.

anyway, if you have any thoughts please let me know, send me a PM or add below.

Thanks and look forward to exploring this

Jonathan Moody
Global Online Lead Gen
QlikTech International

[#2]

Hello,

When i executed the following code just to test my acct. i got an exception, anyone has a solution?

<pre>java -jar GoogleAnalyticsClient-20100702.jar -u foo@bar.com -p mypassword -f 123456 \ -d ga:date,ga:country -m ga:visits,ga:pageviews,ga:newVisits \ -s 2009-01-01 -e 2009-12-31 --start-index=2001 --max-results=2000

[#3]

Ok, the previous error is fixed by correcting the PATH:

n now, i got another error...

[#4]

As part of QVsource, our new generic application for better connecting QlikView to APIs and other difficult-to-load datasources, we also have a Google Analytics Connector in development:

http://www.qvsource.com/wiki/Google-Analytics-Connector.ashx

In addition to connectors for Google Spreadsheets, LinkedIn, FaceBook, OData and a number of other sources.

[amien]

can do java GA solution also be updated using QV server? do i need to set special settings? i see that the EXECUTION statement is used, and perhaps QV server doesnt like that .. any experiance? tips?

@cba .. can QVsource also be used commercial?

[chrisbrain]

Hi Amien,

QVSource is still in beta so that we can gather feedback, add new connectors, fix bugs and generally improve and refine the concept - therefore I would not recommend using it in production just yet.

If we feel there is sufficient demand and interest then we would hope to have something commercially available soon.

[amien]

anyone knows what ga: is should have for the absoluteunqiueusers?

[dasilva]

Absolute unique visitors = ga:Visitors, but you have to be aware of for what period you are picking the data. For example if you use the ga:day, the visitor is counted once per day. If you use ga:month the user is counted once per month and so on

[dasilva]

Hi again Amien!

Forgot to answer your question about QV server and the java-solution; I'm updating the file using QV server and it works fine!

[#10]

Hi,

I'm happy see see some of you are using the GoogleAnalyticsClient java tool I have written some time ago.

As the tool was originally built to enable loading data from Google Analytics into GoodData (a cloud based business intelligence platform) I just want to mention that we have recently released an online app that can easily import detailed Google Analytics data into a GoodData analytics project, which includes pre-built metrics, KPIs and dashboards.

If you are interested, please check out this page including the app description and a video.

Note GoodData is a full business intelligence platform, not just a reporting tool. It means that you are not limited to looking at pre-build reports but you can also slice and dice your GA metrics by any possible combination of dimensions or even load more data from other sources for any possible cross analyses.

I hope you don't mind posting this into a QlikView forum, I hope it's relevant as there seems to be a number of users of my GA utility here. Actually, as QlikView is on premise software and GoodData is cloud based, we can treat our solutions as complementary rather than competing 🙂

Pavel

[amien]

Thanks .. works fine here too