Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to interpret Google Analytics data in Qlik Sense

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

3 Replies
reddy-s
Master II
Master II

Hi Swetha,

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

Thanks,

Sangram.

Not applicable
Author

Did you ever get an answer on this?

john9inno
Creator
Creator

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