Question about connecting Google's web analytics API and QlikView

[#1]

Hey all,

I am working on web analytics here at QlikTech and am wondering if anyone else has tried to hook Google Analytic's API into QlikView. Google's analytics is certainly a great value but I am really interested to see how much more powerful the data can be when tied with QlikView.

anyway, if you have any thoughts please let me know, send me a PM or add below.

Thanks and look forward to exploring this

Jonathan Moody
Global Online Lead Gen
QlikTech International

[#2]

Hello Pavel,

I am using the code and is working a treat but I cannot seem to be able to pull results with a filter on an advanced segment using the gaid::123456789

EXECUTE java -jar GoogleAnalyticsClient-20100702.jar -u $(gUserName) -p $(gPassword) -f $(gProfileId) -d $(gDimensions) -m $(gMetrics) -s $(gDateStart3) -e $(gDateEnd) --filters="gaid::123456789" --max-results=10000 -o Filename.csv;

Is this possible to do or is there no solution, I have tried various syntax but none worked.

--filters="gaid==123456789"

--filters="gaid==gaid::123456789"

Many thanks for any help you or anyone else can give.

Regards

Greenee

[#3]

Hello everyone,

I'm using the code for almost 5 months and everything goes fine... till now.

I can load data only once a day. At a twice load it brings no error, but now data was loaded.

The whole time before it works perfectly.

Can anyone help me? Or did anyone experience the same?

Thanks for any help.

Best Regards.

Anna

[IAMDV]

Hi Pavel / Others,

Thanks for doing this and it works great. Does this support custom segments? I wanted to use some custom segments within this tool. Is this possible?

Thanks again for you help.

Cheers - DV

[IAMDV]

Hi Greenee,

Have you got this working with advanced segments? Please can you help or suggest alternative solution.

Thanks in advance.

Cheers - DV

[Anonymous]

Hello,

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

http://bit.ly/1PQZ0Wj

Best Regards,