Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
reddys310
Not applicable

Re: How to interpret Google Analytics data in Qlik Sense

Hi Swetha,

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

Thanks,

Sangram.

Not applicable

Re: How to interpret Google Analytics data in Qlik Sense

Did you ever get an answer on this?

john9inno
Not applicable

Re: How to interpret Google Analytics data in Qlik Sense

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