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]

Dear Khim

we are still facing some problem the error will be come field are not found .

we don't have a idea how to run java program in commend prompt.

Regards

Ashish

[#3]

hi Ashish,

go to

1. Start -> Run -> type CMD and click OK. This will open the command prompt.

2. Go to the directory where you save the java file. (just type "cd <full path to the folder>" without the quotes)

3. Once you are inside the folder, paste this command:

java -jar GoogleAnalyticsClient-20100127.jar -u noel@cleartrip.com -p advertising -f 25040351 -d ga:date,ga:country -m ga:visits,ga:pageviews,ga:newVisits -s 2009-01-01 -e 2009-12-31 --start-index=2001 --max-results=2000

The code above is based on the code you provided earlier. And the username/password is NOT correct/cannot be authenticated by Google. So, please replace the username, password, and the profile id with the correct one.

4. then press enter.

5. look at the result.

[#4]

hi

[#5]

Hmm... weird. I dont have problem using with my Google account. I suspect that it might be because you are not using a google.com domain for your account. But this is something that you have to ask the Java developer as this is not a problem with QlikView.

[#6]

Dear Asish,

I think that the problem is related with the java code. My qv file has also the same problem like yours. You should write your problem to below forum:

http:///support.gooddata.com/

Best Regards,

[#7]

Dear ASIM

I think there is no solution for this error.

thank of you helping me.

Regards

Ashish

[#8]

Hi,

this version of the GoogleAnalyticsClient didn't support non-gmail users.

A new version that fixes this limitation has just been uploaded to the GoodData support portal.

Please let me know if it helps.

Regards,

Pavel

--
Pavel Kolesnikov
Senior Consultant
GoodData
pavel@gooddata.com

[#9]

Hi

Thanks for helping me .

Now we fetch the data from google analytic but there is some bug this code because of when we put

gDateStart='2010-05-01' to gDateEnd='2010-05-31' it's give me only data from 2010-05-01 to 2010-05-08(only eight day data).

not give me whole may month data.

And i have more then two dimension so how can we fetch all dimension wise data.

Kindly help me .

Regards

Ashish

[#10]

Hi Ashish,

This is completely related with the limitations of Google API. There is nothing to do with the java file. Google API allows maximum 50K rows for each time. You can make a loop to have mutliple data with multiple file:

<code>

LET

gDateStart = makedate(2010, 1, 21)

;

LET

gDateEnd = makedate(2010, 1, 25)

;

LET

NoOfDays = gDateEnd -

gDateStart;

For

dt = 0 to

NoOfDays

Let

myDate = text(date(gDateEnd - dt, 'YYYY-MM-DD'));

Let

myFile = 'visits-' & myDate & '.csv';

EXECUTE

java -Dhttp.proxyHost=192.168.249.10 -Dhttp.proxyPort=3128 -Dhttps.proxyHost=192.168.249.10 -Dhttps.proxyPort=3128 -jar GoogleAnalyticsClient-20100127.jar -u $(gUserName) -p $(gPassword) -f $(gProfileId1) -d $(gDimensions1) -m $(gMetrics1) -s $(myDate) -e $(myDate) --max-results=5000 --filters=$(filters1) -o $(myFile);

Next

</code>

And you can use maximum 7 dimension and metric as below:

<code>

SET

gDimensions1='ga:date,ga:country,ga:city,ga:longitude,ga:latitude,ga:pageTitle,ga:source'

;

SET

gMetrics1='ga:visits,ga:pageviews,ga:newVisits,ga:exits,ga:timeOnPage,ga:timeOnSite'

</code>

;

[#11]

Hi Asim;

If you have sample file kindly send me sample file.

So i can understand easily.

Regards

Ashish srivastava