Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Why do you want an alternative - QVSource is very good abd written by people who relly understand QlikView?
Hi Philip, the answer is: money, i cant buy anything now. Maybe in same months…
Thanks.
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
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,ga:pageviews,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.
Thanks a lot Ferran…..i will try to use your example to start
gerardo
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