How to integrate Google Analytics?

[#1]

Hello everyone,

I've download the Google Spreadsheet Macro Helper for QlikView Demo Pack 0.9.1 and would like test the Google Analytics Macro Helper Demo but i get some errors.

I did everything of the How-To Read Me First:

In order to try out this demo you will need to first install:
IndustrialCodeBox.QlikViewMacroHelpers.Setup VERSION.msi

done

You should then be able to open and run either of the demo files:
Google Analytics Macro Helper Demo.qvw

done

Note that you will need to set the 'Current Local Security' for
macros to 'Allow System Access'.

done

There are additional instructions and information for the Google Spreadsheet demo applications
on the wiki at: http://www.qlikster.com/wiki/QlikView%20Macro%20Helpers.Quick-Start-Guide.ashx

fine, but nothing about the Google Analytics macro

I had edit the Logininformation and Google Analytics feedpath to: https://www.google.com/analytics/reporting/visitors?id=15215840&pdr=20100419-20100519&cmp=average#lts=1274346569633&start-index=[START-INDEX]

If I start the script, i get following error:

"Fehler beim öffnen der Datei 'x:\abc\def\GoogleAnalyticsDataForQlikView_*.xml'
dimension:
LOAD name....
FROM [GoogleAnalyticsDataForQlikView_*.xml"

Has anyone an idea what i had wrong? The How-To is very shot and give no answer.

Much thanks and greetings

Daniel

[chrisbrain]

Hi Daniel,

Sorry you had problems with this and that I only just spotted this post!

We now have a much improved solution for connecting QlikView to all sorts of APIs and other difficult-to-load sources including Google Analytics:

http://www.qvsource.com/wiki/Google-Analytics-Connector.ashx

[Anonymous]

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,