topic Qlikview and Google analytics in QlikView

Qlikview and Google analytics

Thu, 23 Feb 2012 19:47:20 GMT

Hi everybody,

I have a question. I am getting data from google analytics API and call the api with the limit dimensions and metrics.

My problem starts when i try to create the datamodel in qlikview because there is not a primary key and the date+hour is not possible.

Does anybody a solution with QlikView and Google analytics?

Thank you very much.

Qlikview and Google analytics

rbecher — Thu, 23 Feb 2012 22:43:23 GMT

Hi,

we have a full featured commercial Web Analytics solution based on the QVSource connector. It shows the metrics for 11 dimensions (7 is the GA limit).

http://twitpic.com/8cb1o1/full

- Ralf

Qlikview and Google analytics

Thu, 23 Feb 2012 22:47:50 GMT

Hi, Please provide your test qvw.

Qlikview and Google analytics

Fri, 24 Feb 2012 08:27:02 GMT

Thank You very much,

How does qvsource works to create a PK in QlikView datamodel?

We are using GoogleAnalyticsClient.jar

Any idea?

Best regards

Qlikview and Google analytics

rbecher — Fri, 24 Feb 2012 08:40:17 GMT

QVSource doesn't create a PK... You have to work it out on your own.

Qlikview and Google analytics

Fri, 24 Feb 2012 08:45:44 GMT

Thanks Ralf,

So there is another way to do it, and make drilldown throught the data in qlikview.

The point is when we need to show the returning visitor and new visitor from the differntes perspective by date.

Thank you for your help.

Qlikview and Google analytics

rbecher — Fri, 24 Feb 2012 09:03:32 GMT

I don't really know what is your problem. Can you post an example. Then I can help, maybe..

Qlikview and Google analytics

Fri, 24 Feb 2012 09:35:25 GMT

Of course,

I will try to explain.

We need to show all the info of GA in qlikview mode.

If we wanto to show all the GA info we are going to get some differents tables. We cant call the api with all the dimensions because there is a limit as you know. Each table has important info, and all the info should provide to the user returning and new visitors(visitor type) sum or total. For each call of the api, the dimension visitor type provide us different values.

An easy example is when the user want to know returning visitors and new visitors sum by the differents dimensions GA provide us. for example, for a date we are selecting by one country, source, final url, and others dimensions, to navigate througth the information in qlikview document. , the returning and new visitors sum more records when i select the country and final url for example.

I dont know if the solution is create a big table, with other small tables for helping the main table. Our problem is the sum of visitors by date and others fields selected.

Is difficult to explain the issue, i hope you can understand me.

regards

Qlikview and Google analytics

rbecher — Fri, 24 Feb 2012 15:13:54 GMT

How we did it:

All values of dimensions and metrics are loaded into one table. So, this prevents the problem you have with different aggregation results using different tables because of different dimensionality and/or granularity.

But in this way, as you also mentioned, it is not possible to use all data GA is providing. First you have to choose what is important or relevant.

In the next step you can think about how to bring everything together in one table using the same dimensionality and granularity

- Ralf

Qlikview and Google analytics

Mon, 27 Feb 2012 08:57:51 GMT

Thank very much Ralf.

Re: Qlikview and Google analytics

Thu, 05 Dec 2013 09:03:37 GMT

Hi Ralph,

Is QV Source connecter is mandatory or can we get data from Google Analytics without it?

Would you have an example.qvw ?

best regards

Chris

Re: Qlikview and Google analytics

rbecher — Thu, 05 Dec 2013 09:44:23 GMT

You can download GA data as CSV files also..

Re: Qlikview and Google analytics

Thu, 05 Dec 2013 09:48:32 GMT

Thank you Ralph

I guess it is more simple and less expensive BUT less flexible than implement a QV source connector to GA.

Means we have to extract data into csv files from GA. IS there an automatic google process included in GA?

Do you have any idea of complexity and time to implement QV Source?

Best regards

Chris

Re: Qlikview and Google analytics

rbecher — Thu, 05 Dec 2013 11:05:13 GMT

I do not see any additional complexity or time to implement QV Source. Perhaps the opposite, you will save time and gain stability.