topic Re: import Google Analytics data without 3rd party software in QlikView

import Google Analytics data without 3rd party software

Mon, 19 Mar 2012 12:43:52 GMT

I am working on a solution to import Google Analytics data into my Qlikview rapport and I have found two options:
- via javascript
- via QVsource software

The last option works fine, but there is a licence, so I was wondering is there is an alternative.
My current load script is:

GoogleAnalyticsConnector_Data:

LOAD
id as Data_id,
updated as Data_updated,
title as Data_title,
dim_month as Data_dim_month,
dim_year as Data_dim_year,
dim_day as Data_dim_day,
metric_visitors as Data_metric_visitors,
metric_timeOnSite as Data_metric_timeOnSite
FROM
[http://localhost:5555/QVSource/GoogleAnalyticsConnector/?table=Data&username=XXXXXXXXXXXXXl&password=XXXXXXXXXXXXXX&feed=https%3a%2f%2fwww.google.com%2fanalytics%2ffeeds%2fdata%3fids%3dga%253AXXXXXXXXX%26dimensions%3dga%253Amonth%252Cga%253Ayear%252Cga%253Aday%26metrics%3dga%253Avisitors%252Cga%253AtimeOnSite%26segment%3dgaid%253A%253A-1%26start-date%3d2011-01-01%26end-date%3d2012-12-31%26max-results%3d10000&format=html]
(html, utf8, embedded labels, table is @1);

import Google Analytics data without 3rd party software

Anonymous — Mon, 19 Mar 2012 14:17:52 GMT

I tried various options a few months back.

Import into Excel and then into QV also works but to be honest I think QV source is the best solution here.

Re: import Google Analytics data without 3rd party software

Anonymous — Wed, 17 Feb 2016 18:40:38 GMT

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,

Re: import Google Analytics data without 3rd party software

Anonymous — Wed, 17 Feb 2016 18:40:44 GMT

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,