Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shriram_sakunta
New Contributor II

How to load google analytics data into Qlik Sense using REST connectors?

I have established connection using REST connectors with google analytics.

I'm currently facing problem when i'm trying to pull the data from the connection path. I want to load one dimension (User Type) and one metric(Users), I have obtained the URL from Google API and established a connection in Qlik Sense. When I try to load the data, the resultant is coming in a single column.

The result should be,

User Type         Users

New Users        1000

Existing             3000

But what I get is,

New Users

1000

Existing

3000

How can I get a proper table format ? is the problem due to JSON format? if so, How can I solve it ?

P.S Also, When I tried reloading the data after sometime, I get a error "Data has not been loaded", should we have to re-establish connection with google analytics every single time ?