How to interpret Google Analytics data in Qlik Sense

[#1]

Hi Experts,

I used the REST Connector to connect to the GA account in Qlik Sense and pulled the following metrics and dimensions

METRICS

1. "ga:users",
2. "ga:sessions",
3. "ga:avgSessionDuration",
4. "ga:hits",

DIMENSIONS

1. ga.date
2. ga.year
3. ga.month
4. ga.yearmonth
5. ga.country
6. ga.sessionDurationBucket

Now I have the following tables -

1. metrics
2. rows
3. totalsForAllResults
4. columnHeaders

There is no relation among these tables. Has anybody been successfully able to relate the data? There is very little information on this in the community. It will very helpful if the experts can throw some light on this topic.

Thanks

Swetha

[reddy-s]

Hi Swetha,

Isn't there any session ID which can link back to the dates of each user?

Thanks,

Sangram.

[#3]

Did you ever get an answer on this?

[john9inno]

When you look at data table from GA. it looks awful.

that was my first thought as well.

you can get a complete set of data that has relevant metrics and value.

please see below link.

REST CONNECTOR locate the Authorization token

this will get you how to do this.

thanks.

J