Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

import Google Analytics data without 3rd party software

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...]
(
html, utf8, embedded labels, table is @1);



3 Replies
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,

Anonymous
Not applicable
Author

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,