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]

Here it is.

[#3]

Thanks a ton Asim you are helping me

but now we are facing new problem we want to add one more gMetrics

As SET gMetrics='ga:visits,ga:pageviews,ga:newVisits,ga:AbsoluteUniqueVisitors';

It give me error massage field not found .

kindly help me how can we add one more gMetrics and gDimensions.

Regards

Ashish Srivastava

[#4]

Dear Ashish,

The "ga:AbsoluteUniqueVisitors" metric is not listed in the below link:

http://code.google.com/intl/tr-TR/apis/analytics/docs/gdata/gdataReferenceDimensionsMetrics.html

Google API only supports the listed metrics and dimensions and the maximum metric or dimension cannot be more thane 7.

Best Regards,

ASIM AKIN

[#5]

Hi Asim ,

You are great .

more one question about google analytic it's working 8.5 or not .

we have tested in 9.0 it's working but not in 8.5 .

kindly reply below question.

Regards

Ashish Srivastava

[#6]

Dear Ashish,

I'm not sure but I guess it should work. Because there is nothing special other than java code.

Best Regards,

[#7]

Hi Asim

When i tested same thing our production server it gave me error message field not found

but when i see in csv file field is there .

so i can not understand what is error .

kindly help me .

Regards

Ashish Srivastava

[#8]

Most likely is because the csv file is empty. Check the csv file, if it is empty, run the java program in command prompt to check for any error message. I also face similar issue before, and it was because of the invalid combination of measure and dimension. You can check the GA's doc for the valid measure/dimension combination. (If this is the error you facing)

[#9]

Hi Khim

When i tested same file in our local PC it run perfectly when i run same qvw file in our production server then it

give me error message .

Regards

Ashish Srivastava

[#10]

Hi All

How can save csv file in particular location.

Regards

Ashish Srivastava

[#11]

Thanks all of you helping me

Now i am able to pull data from google analytic and make the report .

Regards

Ashish Srivastava