Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Question about connecting Google's web analytics API and QlikView

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

74 Replies
Not applicable
Author

It's on my team's roadmap, but we havent' begun implementation. GA's API is really new, so I'd actually be surprised if people had full integration yet (at least synced up with a major application that has sales data, etc.).

Not applicable
Author

Yea I gree completely with the above. I like that GA's API is new and we can take advantage of moving quick and efficiently.

Imagine combining CRM and GA data for that elusive "All-in-one" dashboard.

Heck, while we are at it let's integrate social media metrics and activity as well...

Jon,,

Not applicable
Author

"Heck, while we are at it let's integrate social media metrics and activity as well..."

Yes please...

disqr_rm
Partner - Specialist III
Partner - Specialist III

Anyone had luck with it?

I am trying to make authentication (token) working via Java Script but no luck so far.

Any ideas to use GA APIs directly into QlikView and extract data periodically - with every reload?

Not applicable
Author

See this extremely simple example how to read data from Google Analytics.

http://community.qlik.com/media/p/90513.aspx

chrisbrain
Partner - Specialist II
Partner - Specialist II

I also posted demo for this here - this one uses a helper component from a QlikView macro to fetch the data from Google Analytics (and there's a similar demo for downloading data from Google Spreadsheets), although I really like the approach of the above sample which does it all from the load script.

This has now been replaced by a much more versatile solution for connecting QlikView to APIs and other difficult-to-load datasources:

http://www.qvsource.com/wiki/MainPage.ashx

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Not applicable
Author

Dear Jonathan,

I use GA API to fetch data into qlikview, but it is very limited. The maximum rows supported by API is 50000 rows but I cannot fetch more than 6000 rows. I also put the longtitude and latitude points on to the google map. It looks like cool but the limitations makes it unusable. Because you cannot be sure that you fetch all the data or not. If you have any solution for that I will more than happy to get your support.

Best Regards,

disqr_rm
Partner - Specialist III
Partner - Specialist III

You can always loop through dates and fetch reports per day in that loop. While looping you can keep your QVD accumulated, so at the end you have QVD with all the record you need. ASAIK GA will not restrict you calling API hundreds of times. I have tested for 180 days atleast and seems to be fine.

Hope this helps.

Rakesh

Not applicable
Author

Dear Rakesh,

Thanks for your advice. Would you please send a sample file. Because I'm still in doubt for getting all of the data without gap. Because the API cannot know the maximum row number or the index number of the row. Your sample file will be helpful.

Best Regards,