Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Alternative qvsource google analytics api

Hi everyone,

        Are there any alternative tool to use google analytics inside qlikview. Or Can i import the data from google analytics without qvsource api tool into qlikview.

Thanks for any advice.

Gerardo

5 Replies
philip_doyne
Contributor

Alternative qvsource google analytics api

Why do you want an alternative - QVSource is very good abd written by people who relly understand QlikView?

Not applicable

Re: Alternative qvsource google analytics api

Hi Philip, the answer is: money, i cant buy anything now. Maybe in same months…

Thanks.

De: philip.doyne

Enviado el: jueves, 24 de mayo de 2012 07:39 a.m.

Para: Pauza, Gerardo

Asunto: - Re: Alternative qvsource google analytics api

QlikCommunity <http://community.qlik.com/index.jspa>

Re: Alternative qvsource google analytics api

created by philip.doyne <http://community.qlik.com/people/philip.doyne> in New to QlikView - View the full discussion <http://community.qlik.com/message/222457#222457

Employee
Employee

Re: Alternative qvsource google analytics api

Hi Gerardo,

Google Analytics has an api to extract data. You can use this API, but you will need to understand it. As you know all api's are complex and need time to learn, so probably you will spend more money writing code for the API than using qvsource, but if you want to use the api I've an small example I can share with you.

// Google Analytic settings

SET gUserName='xxxx@xxx.com';

SET gPassword='xxxx';

SET gProfileId='xxxxxxx';

// dates

SET gDateStart='2010-01-01';

SET gDateEnd='2011-02-04';

// Mesures  and Dimensions

// More Info in: http://code.google.com/apis/analytics/docs/gdata/gdataReferenceDimensionsMetrics.html

SET gDimensions='ga:date,ga:country,ga:city,ga:browser,ga:latitude,ga:longitude,ga:networkDomain';

SET gMetrics='ga:visits,gaSmiley Tongueageviews,ga:newVisits,ga:timeOnPage,ga:timeOnSite,ga:searchVisits';

// Get data from GAnalytics and save it in a csv file

EXECUTE java -jar GoogleAnalyticsClient.jar -u $(gUserName) -p $(gPassword) -f $(gProfileId) -d $(gDimensions) -m $(gMetrics) -s $(gDateStart) -e $(gDateEnd) --max-results=5000 -o visits.csv;

Know you have to load the csv file.

This example is made with an old version of the Google API but still works.

Ferran.

Not applicable

Re: Alternative qvsource google analytics api

Thanks a lot Ferran…..i will try to use your example to start

gerardo

De: Ferran Garcia Pagans

Enviado el: jueves, 24 de mayo de 2012 10:45 a.m.

Para: Pauza, Gerardo

Asunto: - Re: Alternative qvsource google analytics api

QlikCommunity <http://community.qlik.com/index.jspa>

Re: Alternative qvsource google analytics api

created by Ferran Garcia Pagans <http://community.qlik.com/people/fgs> in New to QlikView - View the full discussion <http://community.qlik.com/message/222561#222561

Anonymous
Not applicable

Re: Alternative qvsource google analytics api

Hello,

I've found a way, if you want, you can see here:

http://bit.ly/1PQZ0Wj

Best Regards,