Google Analytics in QlikView by using QVSource

[Anonymous]

Hi all,

Is there anyone who can help me with the development of Google Analytics in QlikView by using QVSource?

The question is: I am loading all the articles which are published on our website into QlikView from 2009. You can imagine this is a big load.

Is it possible to load the data from 2009 until today once (it will not change anymore) and with every reload, load the new data into it, without reloading from 2009? And after that the same for the next day, and so on.

Any suggestions?

Kind regards,

Henco

[chrisbrain]

Hey Thanks - Sounds like a great solution, I had never really tried using the SQL INSERT, UPDATE commands from QlikView script! Can you insert entire tables worth of data in single commands or do you need to do some sort of row level loop?

Thanks!

Chris

[chrisbrain]

Hi Henco - I'd be happy to have a screen share with you to see if I can help you develop/debug the script, you can always post the solution back here for the benefit of others. It might even be useful as a sample on the QVSource wiki.

[Anonymous]

Hi Chris, thanks for that. That would be great. I will send you an e-mail when I'm ready for it, ok? Kind regards, Henco

[chrisbrain]

That's fine!

[Anonymous]

Hi Henrik,

Could you please explain to me in which way I can load data for a whole year into QV by using the sleep function? Do I need to make 365 scripts, one for each date (I don't think so)? I am not familiair with the loop function in QV, so I'm not sure on how to use it. I hope you can help me some further.

[#7]

Hi,

I can see a few queries in google analytic in QVSource.

BUT, how do i link them up?

For example, i can have isolated table for visit by country, by page, by keyword searched.

But, i can't have the info for which keyword is searched the most from which country and they land on which page?

Any tips ?

Thanks.

nick

[Anonymous]

Unfortunately there is no key like visitor_id or anything.  My solution was to create a concatenated key to get as close to an individual visitor as possible.  I combined date, hour, latitude and longitude to create a key.  The problem is that you can only query 7 dimensions at once, so that only left me with 3 more dimensions.  So I just created separate queries each with the 4-field key and 3 separate dimensions.  They all became associated in QlikView based on the 4-field key.

[#9]

Hi Chris

I have doubts in QV source connector.. can you share ur email id pls..

Doubts regarding linkedln.. and analysing my company profile in Facebook etc

[chrisbrain]

Sure - please contact me through:
http://www.qlikster.com/contact.aspx

With your email address and I can answer your questions.