Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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,